Wednesday, April 11, 2012
How to use '\' character in Sybase IQ procedures
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 style LTRIM / RTRIM for SYBASE IQ
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>,...
Tuesday, April 10, 2012
Sybase IQ equavalent for Oracle wm_concat and SQL group_concat
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...
Tuesday, April 3, 2012
Oracle Translate function equivalent for Sybase IQ
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...
