tips and tricks

1.1            Defining connection for Sybase Central and connectng to database

Open Sybase Central for Java edition

 

"Choose Connection Profiles"

 

Choose "New" to define name & description

Click OK to choose or define ODBC connection

Important: To choose previously defined ODBC connections use

Browse..àShow all data sources .

 

Double click or choose connect:

 

1.2           Choosing code to debug and search criteria management

Choose Procedures & Functions

Define filter in SQL like format

You may use settings buton to filter on users

Important: You have to use submit buton to apply search criteria

 

1.3            Debug mode

Double click on code to open in editor.

Choose dubug button to switch debug mode

 Important: Choose only debug DB user to prevent affecting other users

 

1.4            Break point tanımlanması ve kodun debug modda çalıştırılması

Click on the left side to define break point

Call procedure using a querry tool

 

 

 

 

to get folder size in readable format use
du -gs *| sort -n

click for SUN Solaris command

One of the best ways to send HTML mail from SybaseIQ on IBM AIX is to use sendmail.
Unfortunately sendmail has linelength limit (2040 characters default). After 2040th character sendmail is adding ! and new line characters to text which is ruining HTML.

To fix this problem:

1. Change Linelimit info in Sendmail.cf file. Add L=4096 (or any other suitable value) to corresponding mailer.
2. To identify correct mailer check mail log at /var/log/maillog file. Mailer name is mostly Mrelay
3. After these steps ! character shall be removed from your mail.
4. You may add ||  CHAR(13) || CHAR(10) after each </tr> statement to add new line in SQL as well.

Sample script which sends HTML mail from Sybase IQ is below

To split delimiter separated values in to rows use sa_split_list function

Usage:

SELECT * FROM sa_split_list( 'Tee Shirt,Baseball Cap,Visor,Shorts' );

AIX code is below, for orther unix systems use lower h
du -gH /* | sort -n

"words exceeding the maximum permitted word length not supported" error means you did not defined enough/correct delimiters for WD index.

Maximum word length for WD index is 255 characters. You need to delimit your text with correct delimiters to reduce maximum word length under 255.

For columns, which holds SQL statements, delimited by ' ,;=' clause seems valid.This statement means string will be delimited by any of those characters. '.' character is willingly ommited to be able to find 'owner.tablename' format faster.


You may check Sybase Infocenter for detailed information.

"Obsessively specialize. No niche is too small if it's yours."


For sure this is one of the best tips for successful career.
Knowing something about everything can be good in daily life but to climb steps in your career, know everything about something. It doesn't matter if it is small or big topic. nBe expert, get as many certificates as possible (if they exist), share your expertise online and build reputation around it.

When you compile any procedure with '\' in Sybase IQ, your code will be replaced with '\\' to avoid whis
use CHAR(92) instead.

CREATE PROCEDURE MY_TEST
BEGIN
        SELECT LIST(TABLE_NAME, CHAR(92)) FROM SYSTABLES;
END;
/

Oracle's LTRIM/RTRIM supports second parameter to remove other characters than blank.
For example
select LTRIM('My Textaaaa', 'a') from dual; will return 'My Text'.
Same behavior can be simulated with Sybase IQ as well

LTRIM:
substr(<STRING>, length(<STRING>)-length(ltrim(replace( <STRING> ,<CHARACTERS TO REMOVE>,' ')))+1)

RTRIM:
substr( <STRING> ,1,length(rtrim(replace( <STRING> , <CHARACTERS TO REMOVE> ,' '))))

Sybase IQ equavalent for Oracle wm_concat and SQL group_concat is LIST() function.

This function takes 2 parameters column_name (mandotory) and separator (optional default ",").

Sample query:
select list(table_name) from systable

Click for related Sybase Central entry

Oracle translate function has many great usages like Eliminating Double Quotes, Encryption/Decryption etc.

I just wrote SybaseIQ version of it. Code can easly be improved but version 1.0 is not a bad place to start.
Source code is below please feel free to use and comment.


CREATE FUNCTION TRANSLATE (
-- -------------------------------------------------------------------------------------
-- Designer    : Ongun Demirler
-- Author    : Ongun Demirler  
-- Description  :    Sybase IQ replacement for Oracle Translate function
--                    Overrides
--
-- Ammedments   :
--    When        Who                    What
--    ===========    ========            =========================================
--    03.04.2012    Ongun DEMIRLER        Initial design and implementation
--
--    Parameters:
--                P_STR: original string
--                P_SRC: source characters
--                P_DEST: destination characters
--  
-- -------------------------------------------------------------------------------------
    P_STR VARCHAR(4000),
    P_SRC VARCHAR(4000),
    P_DEST VARCHAR(4000) )
RETURNS VARCHAR(4000)
BEGIN
 
    DECLARE a_ret_str varchar(4000); --Return string
    DECLARE a_pointer integer; --Character pointer
    DECLARE a_src_length integer; --Length of source string
 
    set a_src_length = LENGTH(P_SRC);
    --No characters to translate from, source or to
    IF LENGTH(P_STR) = 0 OR a_src_length = 0 OR LENGTH(P_DEST) = 0 THEN RETURN ('') END IF;
 
    --Create replace statement for each character in p_src
    SET a_pointer = 1;
    SET a_ret_str = P_STR;
 
    --Replace each character from src with corresponding character from dest
    WHILE (a_pointer <= a_src_length) LOOP
        SET a_ret_str = replace(a_ret_str, SUBSTR(P_SRC, a_pointer, 1) , SUBSTR(P_DEST, a_pointer, 1));
        SET a_pointer = a_pointer + 1;
    END LOOP;
 
    RETURN (a_ret_str);
END

Özellikle Airties modem kullanıcılarını etkileyen bu sorun aslında modeminizle ilgili.

This bug mainly affects Airties users. There is new trojan which changes DNS setting on your modem to use their search engines. (garantibul.com, aramamotoru.com are famous ones in Turkey. Please do not visit these web pages.). To be able to fix this issure just power off your modem. After few seconds you can restart it.
Do not forget to set new password for your modem.

To be able to correctly display and query non unicode languages such as (Turkish) you should
deselect "Enable Unicode features", "For Oracle, Use UNISTR for Unicode strings" and "For Sybase, use TO_UNICAR for Unicode strings". SQL one too if you need it.

Settings are under "Options > General > Unicode Options"

Summary: You have to install quicktime to be able to add videos to iTunes.

Although I fully installed and dig trough all settings the in iTunes I wasn't able to add videos to the library even they are in correct format. After spending long time on iternets. It turned out I just have to install quicktime too.

Although quick time is not that good to watch videos here is the link:
http://www.apple.com/quicktime/download/

I will just try to share tips &Tricks, how to's which are critical and hard to find on iternets