Interested to Buy Any Domain ? << Click Here >> for more details...
Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
- 2 Answers
- 6469 Views
- I also Faced
- E-Mail Answers
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 |
What is db2 look?
can we drop column from a table
What are the contents of a dclmgen?
What are the various data types available in db2?
What is image copy in db2?
What is a plan and package in db2?
How do you do the EXPLAIN of a dynamic SQL statement?
what is copy pending and check pending ?
What is the difference between CS and RR isolation levels?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What is a db2 tablespace?
What is a host variable?
COBOL 
