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 .....
How to resolve -818 sql code in DB2?
How does DB2 determine what lock-size to use?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is a db2 table?
what is static sql? what is dynamic sql? Give me details
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is blu acceleration in db2?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is a collection?
What does sqlcabc has?
How to execute stored procedure in db2 command editor?
How will you return the number of records in table?