Author |
Message |
Topic: ARRAY OCCURS CLAUSE |
deeptik
Replies: 2
Views: 1925
|
Forum: Application Programming Posted: Fri Sep 11, 2009 1:19 am Subject: ARRAY OCCURS CLAUSE |
Hi,
I want to understand the advantage that the OCCURS DEPENDING ON clause provides over a normal OCCURS clause.
Does the OCCURS DEPENDING ON clause save in terms of memory as the array size wo ... |
Topic: Dual cobol code i.e both batch and online |
deeptik
Replies: 1
Views: 1673
|
Forum: Application Programming Posted: Thu Aug 06, 2009 12:32 am Subject: Dual cobol code i.e both batch and online |
Hi,
Can anyone let me know what things need to be taken care of while developing a cobol code that can be used both as a batch and online module. for eg..do we need to take care of defining any ppt ... |
Topic: Updating DB2 tables in succession |
deeptik
Replies: 3
Views: 1864
|
Forum: Database Posted: Thu Jul 30, 2009 11:43 pm Subject: Updating DB2 tables in succession |
Yes, this method can be used . I am trying to find if this entire process can be done by using cursors or is there any other way of doing this . |
Topic: Updating DB2 tables in succession |
deeptik
Replies: 3
Views: 1864
|
Forum: Database Posted: Thu Jul 30, 2009 11:16 pm Subject: Updating DB2 tables in succession |
Hi,
There is a table T1. For each row of T1, I need to update tables T2, T3 and T4 in succession i.e if T2 update is successful, then update T3 and if T3 successful then T4 and so on. What is the ... |
Topic: Varchar |
deeptik
Replies: 7
Views: 3730
|
Forum: Database Posted: Wed May 21, 2008 11:25 pm Subject: Varchar |
Thank you so much Sharon ! I am clear on this now... |
Topic: Varchar |
deeptik
Replies: 7
Views: 3730
|
Forum: Database Posted: Wed May 21, 2008 1:24 am Subject: Varchar |
Thanks for your replies, I think what I understood is that you will need to tell Db2 what length needs to be stored in case of static SQL.
I have a couple of more q's, I could have tried out mysel ... |
Topic: Varchar |
deeptik
Replies: 7
Views: 3730
|
Forum: Database Posted: Tue May 20, 2008 4:29 am Subject: Varchar |
ok..but why is it necessary ? Will the query fail if we don't populate the lvl 49 length variable ?
Also , again if the insert/update is done outside the application program .i.e say through QMF it ... |
Topic: Varchar |
deeptik
Replies: 7
Views: 3730
|
Forum: Database Posted: Tue May 20, 2008 1:48 am Subject: Varchar |
While using embedded sql in cobol application program to insert data into a varchar field , is it necessary to populate the length host variable as well..or does Db2 automatically store the actual len ... |
|