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
What is a bind in db2?
what is the difference between normal select query and currosor
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.
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.
How would one remove old reorg information from the DB2 catalog?
Explain transactions, commits and rollbacks in DB2.
How to resolve -805 error in DB2?
What keyword does an SQL SELECT statement use for a string search?
How do I delete a table in database?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
Which one allows duplicate values Union or Union All ?
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).