Hi all,
I wanted to know about the performance of the indexes when I create a composite index on F1,F2,F3 on the three columns below:
F1 F2 F3
|20030203|CA |098765|
Or to concat the above field into one, and create a singal index on the whole field as below (F1), as my queries will...
I tried working out as You said, but could not succeed..
SET V_SQL_STMT ='SELECT CHAR('|| V_ELEMENT_NAME ||
') FROM ODS.'||V_TABLE_NAME||' WHERE '|| V_JOIN_COLUMN1||' = ? ';
PREPARE s1 FROM V_SQL_STMT;
DECLARE c1 CURSOR FOR s1;
OPEN c1 using V_KEY1;
FETCH c1 into V_VALUE;
Tell me if I am...
Hi,
I want to fetch a values from a dynamic SQL, but don't know what would be the syntax and way to do it..
I have the synamis SQL as :
SET V_SQL_STMT ='SELECT CHAR('|| V_ELEMENT_NAME ||
') FROM ODS.'||V_TABLE_NAME||' WHERE '|| V_JOIN_COLUMN1||' = ? ';
PREPARE s1 FROM V_SQL_STMT ;
EXECUTE s1...
HI,
I am trying to run a GAWK program. When I am running it standalone from the shell prompt, its running fine, but when I am calling that program in a batch program, the program is getting killed:
splitting_routine.sh[104]: 14964 Killed
I am using AIX 4.3 with gawk version 3.0.5
I am not sure...
I am trying to input a record to a awk program which has a line having 25000 char. When I read the line and print $0 in the program it is returning only 10240 characters. Even doing a length is returning the same count.
Could any one tell me how to change this setting so that it can read the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.