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
- 6309 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 the picture clause of the null indicator variable?
What is a bind card?
What is a DB2 access path?
Describe major components of db2?
What is the purpose of using commit?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is an inner join, and an outer join ?
Which is faster delete or truncate?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is the function of logging in the db2 database?
Explain the use of the WHERE clause?
COBOL 
