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
- 6206 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 |
How to resolve -504 sql code in DB2?
What is schema in db2?
What is precompiler in db2?
What techniques will be used to avoid deadlock??
What is the difference between static and dynamic SQL?
how to fetch first 100 rows in db2
Explain how can you do the explain of a dynamic sql statement?
What do you mean by commit and rollback?
What is REORG? When is it used?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How to find the number of rows in a db2 table?
COBOL 
