Search results for query: *

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

U can try this: VAR_1 =sprintf("%.4d",value); The VAR_1 will contain the desired result.

tried nawk but it did not help. I am working on AIX 3.4. Don't have gawk installed to check it up..

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