Where to Create Table in Working Storage or Procedure Div

ayyappa_22523 · New User Joined: 02 Jun 2005 Posts: 36 Location: Hyderabad

hi

i had a question that based on db2

u had every permission on a table . in cobol + db2 prog where u use create table command in working storage section and procedure division.

priya · Posted: Sun Jun 05, 2005 12:32 am

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

ayyappa_22523,

In addition to this,
Go through the syntax of CREATE TABLE at following site

aurora.vcu.edu/db2help/db2s0/frame3.htm#sqls0621

Hope this helps,

Regards
Mayuresh

yogesh · New User Joined: 27 May 2005 Posts: 21

i will suggest not to create the table in the program, u should create it in SPUFI and then use it in the application program

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

hi frnd,
the better thing is u can create the table in the procedure division will b the right choice.
Eg.
EXEC SQL
CREATE TABLE TNAME(....
...
) in ..;
END-EXEC.

hope above works