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

What is db2?

739


What is performance tuning db2?

616


What is the advantage in De-normalizing tables in DB2?

743


What is cursor with hold option in db2?

612


What are the contents of a dclmgen?

628






Which components manage deadlocks in db2?

606


How do I create a view in db2?

599


How does db2 sample database connect?

566


How can you find out the # of rows updated after an update statement?

637


How do you stop a db2 database in linux?

566


Is schema the same as database?

627


What do you mean by cursor?

582


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

658


What is dbrm in db2 database?

586


What is the default page size of buffer pools?

644