How to handle the null indiactor

[mithunthakre]

HI,

I am getting the SQLCODE as -305. how i can handle the sqlcode -305
please help me

Thanks & Regrads,
Mit's

[Krishna]

Hi,

If you get -305 sqlcode which means you got null values into the host variables.


Solution -
Use NULL INDICATOR VARIABLES to stop getting -305.

Example
-----------

,: FIRST-NAME :WS-FIRST-NAME-NULL-IND
,: INIT-NAME :WS-MID-NAME-NULL-IND

FROM EMPLOYEE ........


Define Null Indicator variables as follows
05 WS-FIRST-NAME-NULL-IND PIC S9(04) COMP.


Use following logic When SQLCODE = 0.

IF WS-FIRST-NAME-NULL-IND >= 0
... Means Field populated with proper value
ELSE
... Means Field populated with null value
END-IF


In sum cases, I would suggest handle -305 instead of using
null indicator variables. If you are feching only one field, in that
case better go and handle -305, if query hit -305 move space/zero's
into host variable.



Thanks,
Krishna

[mithunthakre]

Thanks Krishna