View previous topic :: View next topic
|
Author |
Message |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
Code: |
EXEC SQL
SELECT YEAR(CURRENT TIMESTAMP)
INTO :WS-TIMESTAMP-YEAR
FROM SYSIBM.SYSDUMMY1
END-EXEC |
WS-TIMESTAMP-YEAR is definied as x(4).
Is it valid to use it in the application programming?
This works fine with SPUFI and other tools.
but in the application programming I am getting below error,
Code: |
====== NEW PAGE ========
ERROR ON SETTING TIMESTAMP
IGZ0020S A logic error occurred. Neither FILE STATUS nor a declarative was spe
AAABD002 at relative location X'8DEA'. The status code was 42.
CEE3250C The system or user abend U1020 R=00000000 was issued.
From compile unit CEEWUCHA at entry point CEEWUCHA at compile unit off
at address 209779F4. |
Resolution:
Code: |
Programmer Response: Check operation request for the file.
System Action: The application was terminated. |
Can anyone please suggest. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
The value returned for the YEAR function is a large integer! |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
Thanks Craq. |
|
Back to top |
|
|
|