UNUSABLE HOST VARIABLE

pshongal · New User Joined: 14 Jun 2012 Posts: 96 Location: India

Hi All,

I have the below query.

EXEC SQL
SELECT (DATE(:WS-DATE) - :WS-DAYS DAYS)
INTO :WS-TEMP-DATE
FROM SYSIBM.SYSDUMMY1
END-EXEC

I am getting pre compile error for the above as
UNDEFINED OR UNUSABLE HOST VARIABLE "WS-DAYS"

I have defined WS-DAYS in 01 level as 9(01).

Am I missing something?

pshongal · New User Joined: 14 Jun 2012 Posts: 96 Location: India

Got it... WS-DAYS should be X(01)

sureshpathi10 · Posted: Wed Jan 15, 2014 1:27 pm

Could you post your result if possible?

I was thinking all integer used in the SQL should be declared as PIC S9(9) USAGE COMP.

sureshpathi10 · Posted: Wed Jan 15, 2014 1:41 pm

if you just want to subtract some days from the date, you may use this code as your alternative.

pshongal · New User Joined: 14 Jun 2012 Posts: 96 Location: India

Thanks a lot Suresh...
Yes that's right. I had to change it back to S9(04) Comp.

Let me also try the code you have given.