Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Regarding plan

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Thu Sep 23, 2004 8:08 pm    Post subject: Regarding plan
Reply with quote

Hai

i have some doubts in db2

1) while compling cobol-db2 program what stands for

my prog()
dsn system()

and where actually we will be giving program name.

2)can planname and program name can be same.

3)if have 10 sql stmts and after precmpliation we get 10 call stmts
and my doubts is how many dbrms will be produced whether only one or 10 dbrms

thanks
ashwin
Back to top
View user's profile Send private message
References
priya

Moderator


Joined: 24 Jul 2003
Posts: 624
Location: Bangalore

PostPosted: Sat Sep 25, 2004 8:41 am    Post subject: Hi
Reply with quote

Dear Aswin,

You already became a member only.

Anyway

Quote:
1) while compling cobol-db2 program what stands for

my prog()
dsn system()


My Program used to specify your program name.
DSN youd to specify the DB2 sub system name.

Quote:
can planname and program name can be same.


Yes, Plan name, DBRM Name, Program name, Even Load module name also may be same.

Quote:
)if have 10 sql stmts and after precmpliation we get 10 call stmts
and my doubts is how many dbrms will be produced whether only one or 10 dbrms


Pre-Compiler will create ONLY ONE DBRM, even if you have thousands of SQL queries in your program.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1