How does coalesce work?

667

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

1981

What is db2 stogroup?

777

How can you classify the locks in db2?

719

Is db2 a mainframe database?

644

B37 abend during spufi?

1080

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1915

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

746

What is db2 plan table?

705

define clustering index.

700

i want to maintain uniqueness on pdf without make lf??????????

1730

What are the various data types available in db2?

704

Can we delete records from view?

649

What is a db2 package?

681

How do you find the maximum value in a column in db2?

732