Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)
- 2 Answers
- 5711 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
List down the types of triggers in the db2 database?
What is a trigger in the db2 database?
Explain packages.
What is dbrm? What it contains? When it will be created?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
what is the difference between join and union?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How is a typical db2 batch pgm executed?
Can we update view in db2?
What Utility is used to migrate DB2 from one release to the next?
What is isolation level?
COBOL 
