A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly portrays a business situation. Unfortunately, it requires extra coding for an application program to handle this situation.

arijit.seth

• Sep 29th, 2007

A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a c...

burelamanohar

• Feb 6th, 2007

A NULL value indicates the absence of a column value in a row.A NULL value is not the same as ZERO or all BLANKS.

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You keep track of changes you have done to the row later on update back to your orginal data.Col1------0Update tbl1 set col1 = 1where key1 = 111Col1-----1Update tbl1set col1 = 0where key1 = 111Col1If you have update many rows then you need to load the table again.-----
0

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You will declare the Cursor with "WITH HOLD " Option when you?want the cursor to be pointing to the next row even after the fetch from the db2 table and you exit from the program until expilicit commit is performed to updated to Db2 and Close cursor command is executed.

subbu

• Feb 20th, 2006

 hi,We use cursor only when we updating existing records or Inserting Some Records to the Table.When you Using commit, in DB2 every single row will be commited after the process. If abend oc...

Answer Question  Select Best Answer

A lock is the mechanism that controls access to data pages and tablespaces.

Raghunathan Asari

• Jul 23rd, 2007

Lock is a DB2 mechanism by which DB2 can provide Concurrency and Consistency at  the same time(not exactly).  Based on the SQL statement DB2 provides diffe...

Sukanya Srinivas

• Apr 20th, 2007

Lock is one of the component of DB2. IRLM(IMS-DBe Resource lock Manager) used for data locking and unlocking. Lock is of two types. 1) Share lock 2) Exclusive?Lock?????? A) Share lock...

Answer Question  Select Best Answer

A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities when the code is migrated. The synonym is linked to the AUTHID that created it.

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Also, a Synonym is specific to the DB2 subsystem.  Synonym can only access the table or view in the subsystem in which it is defined.   A synonym is dropped when the table is dropped.An...

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

During precompilation of a COBOL program with SQL queries, the SQL statements and COBOL codes are separated. The timestamp during precompilation helps in identifying the corresponding versions of thes...

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

Search for the table name in the DB2 table SYSIBM.SYSINDEXESSELECT * FROM SYSIBM.SYSINDEXES WHERE NAME = 'tablename'  OR CREATOR = 'creator name' ;

Answer Question  Select Best Answer

It is a DB2 facility for static SQL statements - it replaces these statements with calls to the DB2 language interface module.

Raghuram

• Jul 17th, 2007

During Pre-compilation : 1. The embedded SQL statements are stripped out.  In the source code they are commented out and instead CALL statements are inserted.2. Based on the DECLARE TABLE st...

Sukanya Srinivas

• Apr 20th, 2007

Precompiler: 1) Checks for SQL syntax in application prgram 2) Copies all the?SQL statements into a sepearte member known as DBRM(DataBase Request Module) 3) Comment all the SQL statements 4)...

Answer Question  Select Best Answer

Raghuram

• Jul 17th, 2007

In the process of DB2 program preparation, it is necessary to have the DB2 subsystem up during Bind process.It is during Bind, that the Stripped out SQL statements are checked for any errors and ...

javid

• Mar 21st, 2006

DB2 mustbeup at  Bind Stage.

Answer Question  Select Best Answer

These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.

neha

• Jul 6th, 2007

Foreign Keys are keys used in a table as an attribute and are primary keys of some other table

Answer Question  Select Best Answer

kckinney

 Profile Answers by kckinney Questions by kckinney

• Jun 8th, 2007

Could you provide some more information? Your question assumes we know what you've asked previously.

Answer Question  Select Best Answer

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

DB2 supports index with the help of leaf pages, non-leaf pages, and root pages.Leaf pages - Contains indexed values followed by Record Identifiers (RIDs).Non-leaf pages- Contains the upper range val...

Answer Question  Select Best Answer

AR

• Mar 16th, 2007

Its not a tool. Its REPAIR utility.

kp

• Jun 8th, 2006

By using tool called REPAIR.

Answer Question  Select Best Answer

No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.

rayadurgamsudha

 Profile Answers by rayadurgamsudha Questions by rayadurgamsudha

• Mar 11th, 2007

No the view need not be redone. the changes done in base table will be seen in the view too this is the feature of a view. any manipulations, adding , deleting is done to the base table the changes are seen in the view without being redone.

Answer Question  Select Best Answer

sita

• Feb 26th, 2007

Yes, We can see the Comp-3 Data by pressing Hex On In the File-AID

Bibhu

• Mar 31st, 2006

What I think we cannot see the comp-3 value by USAGE verbwe have to type HEX ON in the command prompt of that particular file to see the numberExample:        &...

Answer Question  Select Best Answer

rupesh

• Feb 22nd, 2007

Select constrint_name,constraint_type,search_condition from user_constraintswhere table_name='name of table in upper case';

hemant

• Apr 18th, 2006

SELECT * FROM SYSIBM.SYSCOLUMNS WHERETBNAME=table-name AND TBCREATOR=' creator-name';orto see column names, types and lengthsSELECT NAME,COLTYPE,LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME=table-name AND TBCREATOR=' creator-name';  the above queries can be used 

Answer Question  Select Best Answer

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.

burelamanohar

 Profile Answers by burelamanohar Questions by burelamanohar

• Feb 7th, 2007

Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index

Amol

• Sep 2nd, 2006

Partitioned table is clustered by clustering index

Answer Question  Select Best Answer

The FREE command can be used to delete plans and/or packages no longer needed.

burelamanohar

• Feb 6th, 2007

PCTFREE : It allows for insertion of new records and for expansion of variable length fields.

FREEPAGE : The number of pages to be loaded between each page left free. It is useful for finding a near page for inserting a new record.

JAVID

• Mar 27th, 2006

Free Command is meant for the deletion of plans. A single free command can delete max. of 12 packages.welcome for feed back

Answer Question  Select Best Answer

A thread is the connection between DB2 and some other subsystem, such as CICS or IMS/DC.

burelamanohar

• Feb 6th, 2007

A thread is a control structure used by DB2 to communicate with an application programme. Every programme must communicate with DB2 by means of Thread.

Answer Question  Select Best Answer

This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile the transaction completes or a syncpoint is issued. For transactions using 'cursor stability' the page lock releases are issued as the cursor 'moves', i.e. as the transaction releases addressability to the...

burelamanohar

• Feb 6th, 2007

Isolation level means the extent to which the transaction isolates the data is accessed

Answer Question  Select Best Answer