IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Regarding plan


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts current batch plan DB2 3
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Usage/Utiliy of Plan in DB2 DB2 4
No new posts How do I define a DB2 plan for a web ... CICS 5
No new posts Finding the plan when code compiled u... DB2 2
Search our Forums:

Back to Top