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
- 6212 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 |
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
How to design maps
What does it mean if the null indicator has -1, 0, -2?
What is the use of db2 optimizer?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is db2 purescale?
Do we need cursor for Count(*)?
Can we update view in db2?
How can deadlocks be resolved?
What is the default page size of buffer pools?
What is the difference between nvl and coalesce?
COBOL 
