Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
Answer Posted / guest1
Using the Dynamic sql the preparation of bind-plan will be
costly. As you know the data it is advisable to use the
static sql directly.
Dynamic sql is also valid.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What parameters are used to control the free space in DB2?
Define sqlca.
Define buffer pool.
What is a system catalog table in db2?
What is the function of logging in the db2 database?
What is db2 bind?
Can you tell me how can you find out the # of rows updated after an update statement?
How do I delete a table in database?
What is release/acquire in bind?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a db2 tablespace?
Explain the function of data manager.
Mention the location where the output received from explain statement is stored.
Define declaration generator (dclgen).
Discuss about db2 bind?