Mar 3, 2004 #1 marcholmes Programmer Joined Mar 3, 2004 Messages 9 Location 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.
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.
Mar 4, 2004 #2 tdatgod Programmer Joined Jul 21, 2001 Messages 601 Location US 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 Upvote 0 Downvote
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
Mar 4, 2004 Thread starter #3 marcholmes Programmer Joined Mar 3, 2004 Messages 9 Location GB 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. Upvote 0 Downvote
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.