Date insertion returns -180

Raghu navaikulam · Posted: Mon Jul 29, 2019 5:12 pm

Hi all,

I am getting -180 while inserting a row in a DB2 table using CICS map.
The variable is defined with 10 bytes long in map and in DB2 table it is DATE datatype. The value I am trying to put is ISO format(YYYY-MM-DD). The value is within the range of ISO and correct in all ways. But I am getting -180. Is there any way to know the actual reason? My system is using DB2 version 9.1. When starting SPUFI, the system is giving a message that "TERMINAL CCSID: 37 and SPUFI CCSID : 1047 " . At BIND time I am using a parameter ENCODING(EBCDIC).

Any suggestion to this is very greatfull.

Thanks
Raghunathan

Rohit Umarjikar · Posted: Tue Jul 30, 2019 9:41 am

You need to review your MAP variables after receive map and before insert as to what values do you have at that point. I suspect they are spaces.

To prove this , try moving the hard coding value of DATE and if that works means you are having a problem getting value from screen to your mapi variables.