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


Please Help Members By Posting Answers For Below Questions

How can you classify the locks in db2?

862


What is db2 connect?

833


How can deadlocks be resolved?

752


What is a db2 package?

819


What does db2 blu stand for?

919


When do you specify the isolation level?

813


What is blu acceleration in db2?

856


What is a cursor in programming?

853


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3351


What do you mean by between and in? Is between inclusive of specified range values?

892


What's The Percentage Free Space ?

992


What is clone table?

823


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

7548


What are db2 objects?

855


What db2 400?

933