Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate)

Answers were Sorted based on User's Feedback



Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediat..

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

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediat..

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

Post New Answer

More DB2 Interview Questions

how to take the back up of the DB2 table.

7 Answers  


What does CURRENTDATA option in bind indicate

1 Answers   IBM,


When would you prefer to use VARCHAR?

3 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


What is a data page?

1 Answers  


Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  


what is parm utility

2 Answers   IBM,


What is the difference between spufi and qmf?

0 Answers  


What is a plan and package in db2?

0 Answers  


What is correlation names?

1 Answers  


How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,


Categories