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


Hi Everyone...
Under the Logical files, when am working on multiple rec
format logical file,

I have joined two pf's using the multiple record format
logical file concept, but when i run queried the LF only the
first mentioned pf records are reflecting and I am not able
to see any of the field records specified under the second pf.
Kindly let me know whats the reason behind this.

Below is the str of LF.,

R rec PFILE(LOGICAA)
CUSTNO
CUSTNAME
BILL
K CUSTNO
R rec1 PFILE(LOGICAA1)
CUSTNO
ADD
K CUSTNO .....


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is a bind in db2?

0 Answers  


what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,


How would one remove old reorg information from the DB2 catalog?

2 Answers  


Explain transactions, commits and rollbacks in DB2.

3 Answers  


How to resolve -805 error in DB2?

1 Answers   Cap Gemini,


What keyword does an SQL SELECT statement use for a string search?

2 Answers  


How do I delete a table in database?

0 Answers  


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  


1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


Categories