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 tablespace be moved to another dasd volume that is allocated for that tablespace?

979


What are db2 objects?

835


What is nvl in db2?

828


Define predicate?

871


Define declaration generator (dclgen).

884


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

875


My sql statement select avg(salary) from emp yields inaccurate results. Why?

864


What is netezza database?

778


what is db2 restart?

1907


What is a storage group (stogroup)?

993


What does sqlcabc has?

797


What is the purpose of using commit?

834


What is runstats utility in db2?

767


What is iseries database?

790


What is the purpose of rollback and commit?

812