Monday, December 3, 2012
How to debug in Sybase IQ
Sybase IQ-
Debugging
1.1
Defining connection for Sybase Central and connectng to database
Open Sybase
Central for Java edition
"Choose Connection Profiles"
Choose...
Tuesday, November 13, 2012
Sybase IQ variable/parametric unload filename
To assign variable in set temporary option temp_extract_name1 use code below:
begin
declare file_name varchar(100);
declare option1 varchar(100);
set
file_name...
Readable folder size command in IBM AIX
to get folder size in readable format use
du -gs *| sort -n
click for SUN Solaris comm...
Wednesday, August 15, 2012
HTML mail from SybaseIQ- Sendmail linelength problem (weird ! character)
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...
Thursday, June 14, 2012
SYBASE IQ - Split coma seperated values in to rows
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' );
line_numrow_value
1Tee Shirt
2Baseball Cap
3Visor
4Shorts
For detailed intormation check...
Thursday, June 7, 2012
How to get folder and subfolder size in readable format unix
AIX code is below, for orther unix systems use lower h
du -gH /* | sort...
Tuesday, June 5, 2012
Sybase IQ - Word Index limitations
"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...
Tuesday, May 29, 2012
Sybase IQ equavelent for while break structure
Sybase IQ uses labes to exit loops. Instead
of break you have to use exit label structure.
Sample "while break" code:
.
.
lbl:
WHILE 10 <15 LOOP
SET i = 1;
IF i = 1 THEN
LEAVE lbl;
END IF;
END LOOP ...
Wednesday, May 9, 2012
Important tip about great career building
"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...
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...
Friday, March 23, 2012
Goldan Gate - GGS ERROR 160 Bad column index
Unfortunately error message is not explaining much here.[Date Time] GGS ERROR 160 Bad column index ([Column Count]) specified for table [Owner].[Table Name], max columns = [Column Count].
But reason and...
Wednesday, March 21, 2012
iPhone Facebook wifi bağlantı problemi
Özellikle Airties modem kullanıcılarını etkileyen bu sorun aslında modeminizle ilgili.
DNS ayarlarınızı değiştirerek kendi arama motorlarını kullanamızı sağlamaya çalışan garantibul.com, aramamotoru.com (lüften bu siteleri ziyaret etmeyin.) gibi siteler...
iPhone Facebook connection problem over wifi
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...
Tuesday, March 20, 2012
AQT (Advanced Query Tool) non unicode character problem
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...
iTunes video add problem - even they are in correct format
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....
Something crutial about everything
I will just try to share tips &Tricks, how to's which are critical and hard to find on itern...
