DB2 doubt. canu plz expail anyone plz.....

kiran.s
Posts: 6
Joined: Sun May 02, 2010 9:48 pm
Skillset: cobol,jcl,db2,vsam
Referer: google

DB2 doubt. canu plz expail anyone plz.....

Postby kiran.s » Sun May 02, 2010 9:56 pm

How can we define a table? How can we apply SEARCH ALL on this?
any one plz. provide the answer with the syntax also ?

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: DB2 doubt. canu plz expail anyone plz.....

Postby dick scherrer » Sun May 02, 2010 11:16 pm

Hello,

Suggest you talk with the dba to define a table. . .

SEARCH ALL is a cobol statement to search an array defined in cobol (not db2). There is SELECT for accessing database tables (not SEARCH ALL).

You need to more clearly post what you want to do and show what you have done and where you are stuck.

We will help, but not actually write the code.
Hope this helps,
d.sch.