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
- 6354 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 |
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
How do I import data from excel to db2?
can i code union in cobol-db2 pgm ?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How would the varchar column remarks defined?
The only place of VSAM KSDS in DB2 is?
What is the use of dclgen in db2?
What is bind and rebind in db2?
What does runstats do in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What are some SQL aggregates and other built-in functions?
What is a DB2 bind?
COBOL 
