db2 to handle and store default value to output file



db2 to handle and store default value to output file

Postby nnina » Mon Oct 12, 2009 10:51 am

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.
nnina
 
Posts: 3
Joined: Mon Oct 12, 2009 9:43 am
Has thanked: 0 time
Been thanked: 0 time

Re: db2

Postby nnina » Mon Oct 12, 2009 10:53 am

[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.
nnina
 
Posts: 3
Joined: Mon Oct 12, 2009 9:43 am
Has thanked: 0 time
Been thanked: 0 time

Re: db2

Postby dick scherrer » Tue Oct 13, 2009 1:08 am

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
You do not have the required permissions to view the files attached to this post.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to FAQ

 


  • Related topics
    Replies
    Views
    Last post