|
View previous topic :: View next topic
|
| Author |
Message |
Hcarthik
New User
Joined: 19 Aug 2008
Posts: 5
Location: Cochin
|
|
|
|
Hi,
What s picture clause to be used in defining a null indicator for a z/os DB2  |
|
| Back to top |
|
 |
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
| Back to top |
|
|
Hcarthik
New User
Joined: 19 Aug 2008
Posts: 5
Location: Cochin
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
The field needs to be a 2-byte binary field. Both comp and comp-5 are binary fields. . . |
|
| Back to top |
|
|
Rajesh Midde99
New User
.jpg)
Joined: 04 Dec 2008
Posts: 11
Location: Bangalore,India
|
|
|
|
Hi
Hope, S9(4) comp will work. Give a try and let us know the answer.
Regards
Rajesh |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| 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 |
|
|
|
|
