Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
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 dbrm? What it contains?
What is blu acceleration in db2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
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 is the difference between db2 and oracle?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is the purpose of using commit?
What is the meaning of -805 SQL return code?
What is buffrpool? Where we use it ?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is an alias and how does it differ from a synonym?