Move S9(4) to S9(5) v usage comp-3

Val · New User Joined: 25 Sep 2005 Posts: 1 Location: USA

Hi All:
01 Field1 9(4)
02 Field2 S9(5)v usage comp-3

I am trying to move move file1 to filed2 and comparing with Column of DB2 Table COL1

COL1 declared as S9(5)v usage comp-3 in DCLGEN.

I am getting Sql Code 301

I displayed filed2 after move but ot not moving properly.

I need help on how it works when we move field1 to field2

Thank you

sridevi2005 · New User Joined: 15 Sep 2005 Posts: 42

Hi,

Moving from field1 to field2 is correct.

It's working fine.

I think problem with DB2 Data type.

01 FIELD1 PIC 9(4) VALUE 1234.
01 FIELD2 PIC S9(5)V USAGE COMP-3.

MOVE FIELD1 TO FIELD2.
DISPLAY "FIELD1 = " FIELD1
DISPLAY "FIELD2 = " FIELD2

I have used the above code for moving.

It's working fine.

If i'm wrong please let me know.

Thanks,
Sridevi