IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

when null indicator value will be -2?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vinod007in
Currently Banned

New User


Joined: 05 Sep 2006
Posts: 3
Location: chennai

PostPosted: Thu Oct 05, 2006 12:14 am
Reply with quote

hi guys.
please anyone help me ,when null indicator value will be -2?
reply asap
urs
vinod
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Thu Oct 05, 2006 1:06 am
Reply with quote

A -2 null indicator indicates a conversion error populating the host-variable.

Check the link below. Look at the 'INTO' paragraph.

SELECT INTO

Dave
Back to top
View user's profile Send private message
vinod007in
Currently Banned

New User


Joined: 05 Sep 2006
Posts: 3
Location: chennai

PostPosted: Fri Oct 06, 2006 11:23 pm
Reply with quote

thank u dave
Back to top
View user's profile Send private message
raviprasath_kp
Warnings : 1

New User


Joined: 20 Feb 2005
Posts: 65
Location: chennai

PostPosted: Tue Oct 10, 2006 11:17 am
Reply with quote

that value will be truncated,please verify
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Adding 'ODD' and 'EVEN' indicator at ... DFSORT/ICETOOL 6
No new posts Cobol prog to put an indicator on the... JCL & VSAM 1
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
No new posts Uploading from desktop, a CSV file, s... DB2 2
Search our Forums:

Back to Top