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...
