What are the two types of logging in the db2 database? Explain them.

573

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

1893

Which command is used to connect to a database in DB2 ? Give the Syntax.

599

What is database manager in db2?

549

What are the 2 sqlcodes that are returned?

633

Is the primary key a clustered index?

607

List down the data types in the db2 database.

632

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

705

How can we read records for specific member in CL? AND rpg?

228

How can you do the explain of a dynamic sql statement?

635

What db2 400?

673

What is blu acceleration in db2?

603

What is a db2 collection?

603

Mention data types used in db2 ?

671

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

648