Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fastload a file from MVS with a S9999 field

Status
Not open for further replies.

marcholmes

Programmer
Mar 3, 2004
9
GB
How do I fastload a file from MVS which contains a field which you would define in COBOL as S9999?

It's not decimal, or integer.
 

s9999 is signed integer. Why can't you load that into a normal INT field in Teradata?

what is the error you are getting?

the +/- sign doesn't mean it is Character data, it just means it is a SIGNED value.

768 == +0768 == +768
-768 == -0768


 
Sorry, should have read S99999, i.e. 12345B (looks like
FFFFFC
123452
in hex)

Does that make a difference?

What do I put in the DEFINE statement?

INTEGER would expect 4 bytes in binary.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top