Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
Answer Posted / 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 |
Post New Answer View All Answers
What is cursor stability in db2?
Define buffer pool.
What is check constraint. Explain with example.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Can we delete records from view?
What is the usage of open cursor command?
How does coalesce work?
Explain about dbrm.
Define db2 and its databases?
What is dbrm? What it contains? When it will be created?
define clustering index.
What are the 2 sqlcodes that are returned?
What is the function of logging in the db2 database?
Explain db2.
What is a page in db2?