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
- 6234 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 |
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is plan in cobol db2?
Describe the elements of the SELECT query syntax?
What is dbrm in db2 database?
What is a Resource Control Table(RCT)? Describe its characteristics.
What are catalog tables in db2?
What does db2 plan contain?
When the like statement is used?
What is the function of buffer manager?
List out the data types available.
How to execute stored procedure in db2 command editor?
How to update more then one record using update?
COBOL 
