|
|
| Author |
Message |
ashwinreddy
Active User
Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad
|
|
|
|
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 |
|
 |
References
|
 Posted: Thu Sep 23, 2004 8:08 pm Post subject: Re: Regarding plan |
|
|
|
|
priya
Moderator
Joined: 24 Jul 2003
Posts: 630
Location: Bangalore
|
|
|
|
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 |
|
|
|
|
