Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sr
Yes we can do. Like we retrieve the data from the
production tables to PS files and by Load utility we ca
load the tables. Whereber we we use sql..that we can use n
the dynamic sql.
Hope this helps.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to take the back up of the DB2 table.
What does CURRENTDATA option in bind indicate
When would you prefer to use VARCHAR?
what is the name of the default db2 catalog database?
What is a data page?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
what is parm utility
What is the difference between spufi and qmf?
What is a plan and package in db2?
What is correlation names?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?