DS/390

jseclen · Post by **jseclen** » Fri Oct 10, 2003 10:56 am

Hello,

I'm developing job mainframes, the datatypes used are integer signed and unsigned, the problem is when define in DataStage the datatype as integer, but the default is signed, i need to define a integer unsigned..

Is there a problem when read a dataset using the incorrect datatype, in this case the integer signed when the data is signed???

Miguel Seclen
Lima - Peru

ray.wurlod · Post by **ray.wurlod** » Sat Oct 11, 2003 1:37 am

Did you import the table definition from a DCLGen file or from an FD file? If so, what does DataStage report?

You could probably tolerate signed integers, redefining them as unsigned if necessary in a WORKING STORAGE section. After all, the sign bit in an integer is always in the most significant bit position.
You might also like to edit the template for the stage type that you're using.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

ariear · Post by **ariear** » Sat Oct 11, 2003 7:51 am

Miguel,

What exactly do you mean ? Can you ask your question in cobol terms like PIC 9(3) comp-3 or pic S9(3) comp-3 which are not the same !

ArieAR

jseclen · Post by **jseclen** » Mon Oct 13, 2003 9:25 am

Arier,

In my job i see the next format

Field1 Pic S9(9) COMP

and must be

Field Pic 9(9) COMP

But my field is unsigned !! when the field format is signed is there a problem when try to read???

This is my question...

ariear · Post by **ariear** » Mon Oct 13, 2003 2:19 pm

Hi,
I know this problem (oops ! feature) fron DS 4. Unsigned packed decimal were not supported (It was documeneted !) for internal maipulations i.e. transformer/external routine API etc.
I'm not updated with this issue on newer versions. Check it out .
If you're only reading then DataStage will internally convert the field from pic 9(9) comp-3 to s9(9) comp-3

ray.wurlod · Post by **ray.wurlod** » Tue Oct 14, 2003 5:16 pm

... which, as being handled within DataStage, is simply a signed integer. These can readily be converted to unsigned numeric values within DataStage, for example for writing to text file. I outlined the technique earlier (for four-byte integers) - use a different constant for eight-byte integers.