Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Null indicator definition

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
Hcarthik

New User


Joined: 19 Aug 2008
Posts: 5
Location: Cochin

PostPosted: Tue Dec 09, 2008 11:37 am    Post subject: Null indicator definition
Reply with quote

Hi,

What s picture clause to be used in defining a null indicator for a z/os DB2 icon_question.gif
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2238
Location: @my desk

PostPosted: Tue Dec 09, 2008 11:50 am    Post subject:
Reply with quote

Hcarthik,

This link might be of some help

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNAPK10/2.4.3.10?SHELF=&DT=20070123230158
Back to top
View user's profile Send private message
Hcarthik

New User


Joined: 19 Aug 2008
Posts: 5
Location: Cochin

PostPosted: Tue Dec 09, 2008 12:15 pm    Post subject: Null indicator definition
Reply with quote

Thanks arcvns,

But there are some other places telling to use comp and comp-5. Which one would be the apt definition?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 09, 2008 12:48 pm    Post subject:
Reply with quote

Hello,

The field needs to be a 2-byte binary field. Both comp and comp-5 are binary fields. . .
Back to top
View user's profile Send private message
Rajesh Midde99

New User


Joined: 04 Dec 2008
Posts: 11
Location: Bangalore,India

PostPosted: Wed Dec 17, 2008 2:44 pm    Post subject: Reply to: Null indicator definition
Reply with quote

Hi

Hope, S9(4) comp will work. Give a try and let us know the answer.

Regards
Rajesh
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Thu Dec 18, 2008 12:30 am    Post subject:
Reply with quote

While you're at it, read up on COMP-5. You might want to start using that usage for numbers that can exceed 9999 for a 2-byte binary field or 999999999 for a 4-byte binary field.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
No new posts Compare 2 files & write Indicator... nagendrapgupta SYNCSORT 5 Sun May 15, 2016 10:42 am
No new posts GetObjectArrayElement returns NULL Majid Hussain Java & MQSeries 2 Wed Mar 30, 2016 2:59 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us