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 |
what is the maximum number of tables that can be joined ?
What is a clustering index ?
What is the difference between nvl and coalesce?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How to update more then one record using update?
What will the FREE command do to a plan?
What is dbrm?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
what is different three logs in DB2?
What's the maximum number of volumes that can be added to a STOGROUP?
how can i pull up a query which was previously stored in qmf
What is a buffer in memory?