MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 8 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: ARRAY OCCURS CLAUSE
deeptik

Replies: 2
Views: 1925

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group