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
- 6204 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the usage of open cursor command?
How to find the number of rows in db2 tables?
Which isolation level provides maximum concurrency?
What are the different types of base tables?
How to find schema of a table in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is load utility in db2?
What is concurrency?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do I delete a table in database?
What is dbrm? When it will be created?
How can you do the explain of a dynamic sql statement?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is coalesce in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
