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...


Can we use select * statement in cobol program without
giving field names ???

Answers were Sorted based on User's Feedback



Can we use select * statement in cobol program without giving field names ???..

Answer / vish

Yes we can do it but as a practice people don't use "SELECT
*..." in COBOL program. Possibly the main reason for this
is that if there is any modification to the table in future
(e.g. a column addition) then all such programs needs to be
at least recompiled once even if there is no code changes
into them. This is ensure taht they use latest DCLGEN for
the modified table else the programs will abend for column
mismatch.

Is This Answer Correct ?    14 Yes 0 No

Can we use select * statement in cobol program without giving field names ???..

Answer / shailendra

yes

Is This Answer Correct ?    4 Yes 0 No

Can we use select * statement in cobol program without giving field names ???..

Answer / guest

Shouldnt the code be changed to handle the new column that
would be returned by the SELECT *...

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


What is copy pending status in db2?

0 Answers  


Is the primary key a clustered index?

0 Answers  


How can you find out the # of rows updated after an update statement?

0 Answers  


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,


What is meant by AUTO COMMIT?

3 Answers  


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,


difference between group clause and order clause

1 Answers  


What is dbrm? What it contains?

0 Answers  


What is view db2?

0 Answers  


Categories