Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
Answer Posted / 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 |
Post New Answer View All Answers
What is reorg and runstats in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is db2 purescale?
How to find the maximum value in a column in the db2 database?
What is null in db2?
What is the use of dclgen in db2?
Is db2 a mainframe database?
Why do chiropractors use drop table?
What is package in db2 mainframe?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain packages.
What is an instance in db2?
What do you mean by rollback?
What's The Percentage Free Space ?
What is sqlca’s maximum length?