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
- 6333 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 Static and dynamic linking
How will fetch last 5 rows from table in db2
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the difference between using bind () and rebind () methods of naming class?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
How can you compare table column after update and before update?
can we drop column from a table
What are the rules for db2 programming?
What are the bind parameters ibm db2?
What does the CHECK Utility do ?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
COBOL 
