How does a cursor work?

933

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

2324

What is dbrm?

1053

If I have a view which is a join of two or more tables, can this view be updateable?

1096

Is db2 a programming language?

999

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2801

what is a corelated subquerry?

1079

What is db2 stogroup?

1113

What are packages in db2?

989

What is precompiler in db2?

976

Why do chiropractors use drop table?

1059

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1063

How do I delete a column in db2?

1068

What is dbrm? What it contains? When it will be created?

1006

How many databases can be created inside an instance in db2 ?

994