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
- 6359 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 copy the host variables from ps file into cobol program other than include statement
What is the function of buffer manager?
What happens in bind step in a db2 program?
What are data types?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What information is contained in a SYSCOPY entry?
What is DYNSLT keyword? How do you perform selection using DYNSLT
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
How to find the maximum value in a column in the db2 database?
What is the purpose of rollback and commit?
What is dbrm? When it will be created?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
COBOL 
