MVSFORUMS.com

prabhutp · Beginner Joined: 02 Feb 2005 Posts: 20 Topics: 11

Hi

I need to convert numeric to integer or smallint in cobol.This will be used in the loading of a table. Can anybody please help me out!!!!Apart from the length check Its the conversion from numeric to small int or integer which is troubling me!!!!!!
_________________
tp

kolusu · Posted: Mon Mar 28, 2005 11:40 am Post subject:

prabhutp,

A smallint in db2 is equivalent to s9(04) comp in cobol and an INTEGER in DB2 is equivalent to S9(09) comp in cobol. Define your variables accordingly and move your numeric values into them.

Check this link which explains the equivalent SQL and COBOL data types

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/2.4.3.7?SHELF=&DT=20010710165542&CASE=

Hope this helps..

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

prabhutp · Beginner Joined: 02 Feb 2005 Posts: 20 Topics: 11

Hi

Thanks for the instant reply...I need to load my external file into a DB2 Table.This file is declared as X(1000)..So What I was looking at is converting my numeric field to Small Int or Integer Format and then straightly place it in the output file and load the table.Is it possible?Kindly explain
_________________
tp