Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
View previous topic :: :: View next topic  
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

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us