IBM Mainframe Forum

In my SQL query there is one null indicator i know this value is always null.I want to store this null value into my output file with default value.i need to know how i can store default value without handling -305 sql code.
Is there any Sql QUERY to handle and store default value to output file?

Can anyone explain me detail about DBRM,PLAN, package and collection.
Following are what is understand in the above
DBRM: During pre-compilation time SQL code extarcted from cobol-db2 program and stored into DBRM.
Package: It contains the DBRM send it to bind plan check security access for authorization.
Plan: It contains executable path and check security access for authorization.
Collection:It contains region to say which DB2 region program is binded.

Please do the needfull.

[quote="nnina"]I my SQL query there is one null indicator i know this value is always null.I want to store this null value into my output file with default value.i need to know how i can store default value without handling -305 sql code.
Is there any Sql QUERY to handle and store default value to output file?

Can anyone explain me detail about DBRM,PLAN, package and collection.
Following are what is understand in the above
DBRM: During pre-compilation time SQL code extarcted from cobol-db2 program and stored into DBRM.
Package: It contains the DBRM send it to bind plan check security access for authorization.
Plan: It contains executable path and check security access for authorization.
Collection:It contains region to say which DB2 region program is binded.

Please do the needfull.

Hello,

i need to know how i can store default value without handling -305 sql code.

Read here about the specifics of the -305 sql code"
http://publibz.boulder.ibm.com/cgi-bin/ ... /2.1.6.113

Can anyone explain me detail about DBRM,PLAN, package and collection.

See if the attached info will clarify. . .

d