Author |
Message |
Topic: max value in a string |
bonnie_mathew
Replies: 3
Views: 2101
|
Forum: Application Programming Posted: Thu Aug 18, 2005 4:04 am Subject: max value in a string |
Kolusu,
Correct me if I am wrong, but I think the following logic can do the job.
MOVE T-STR(1) TO WS-TMP-STR
PERFORM
VARYING W-SUB1 FROM 1 BY 1 UNTIL W-SUB1 >= 8
IF T-STR ... |
Topic: Search a string |
bonnie_mathew
Replies: 3
Views: 1848
|
Forum: Utilities Posted: Thu Aug 11, 2005 7:55 am Subject: Search a string |
U can specify columns also in find command.
F '<SEARCH-KEY>' 1 50 |
Topic: load tables in simple tablespace |
bonnie_mathew
Replies: 5
Views: 2105
|
Forum: Database Posted: Tue Aug 09, 2005 8:31 am Subject: load tables in simple tablespace |
Deepa,
When you use a LOAD REPLACE, the table space and all its indexes need to be reset to empty before records are loaded. With this option, the newly loaded rows replace all existing rows of all ... |
Topic: load tables in simple tablespace |
bonnie_mathew
Replies: 5
Views: 2105
|
Forum: Database Posted: Tue Aug 09, 2005 4:39 am Subject: load tables in simple tablespace |
Hi,
Please check if the tables mentioned are sharing a table space. You can use the following query :
select tsname from sysibm.systables where name in (<give table names here>); |
Topic: Compare comp & numeric |
bonnie_mathew
Replies: 3
Views: 1878
|
Forum: Application Programming Posted: Sat Aug 06, 2005 12:29 am Subject: Compare comp & numeric |
It is possible to compare, but it is always better to compare same data types. |
Topic: Right justifying alpha numeric data |
bonnie_mathew
Replies: 8
Views: 10983
|
Forum: Application Programming Posted: Sat Aug 06, 2005 12:27 am Subject: Right justifying alpha numeric data |
sorry for that.
Hi,
Actually justify works in procedure division also. In your case if you move from the PIC X(17) variable to a PIC X(18) JUST variable you will get it right justified. Please t ... |
Topic: Right justifying alpha numeric data |
bonnie_mathew
Replies: 8
Views: 10983
|
Forum: Application Programming Posted: Sat Aug 06, 2005 12:25 am Subject: Right justifying alpha numeric data |
Hi,
Actually justify works in procedure division also. In your case if you move from the PIC X(17) variable to a PIC X(18) JUST variable you will get it right justified. Please try this out and see ... |
Topic: copy pending status |
bonnie_mathew
Replies: 3
Views: 1912
|
Forum: Database Posted: Sat Aug 06, 2005 12:12 am Subject: copy pending status |
Copy pending happens when loading a table from file. This can be avoided by giving LOG YES in the syspunch dataset instead of LOG NO. And once the table goes into copy pending status it can be brought ... |
|