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)

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 parameters are used to control the free space in DB2?

1017


Define sqlca.

1062


Define buffer pool.

1005


What is a system catalog table in db2?

1119


What is the function of logging in the db2 database?

1079


What is db2 bind?

1021


Can you tell me how can you find out the # of rows updated after an update statement?

1052


How do I delete a table in database?

987


What is release/acquire in bind?

1069


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4229


What is a db2 tablespace?

1010


Explain the function of data manager.

999


Mention the location where the output received from explain statement is stored.

1072


Define declaration generator (dclgen).

1072


Discuss about db2 bind?

1056