Error: 'REFERENCE TO HOST VARIABLE IS AMBIGUOUS'

MUTHUSMCA · New User Joined: 14 May 2005 Posts: 2 Location: Chennai

hi,

i am geetting the error like
---REFERENCE TO HOST VARIABLE HV-EMPNO IS AMBIGUOUS
---REFERENCE TO HOST VARIABLE HV-NAME IS AMBIGUOUS

i have included DCLGEN member in my program

guptae · Posted: Sat Sep 09, 2006 9:34 pm Post subject:

Could u please provide ur sql

priyesh.agrawal

MUTHUSMCA · New User Joined: 14 May 2005 Posts: 2 Location: Chennai

INSERT INTO DEMO
VALUES(:HV-EMPNO,:HV-NAME)

----- this is my sql guptae !!

--have a note on this....

guptae · Posted: Mon Sep 11, 2006 10:29 am Post subject:

Hi MUTHUSMCA,

Ur host variable might be declare like that

01 WS-VAR.
10 HV-EMPNO PIC X(10).
10 HV-NAME PIC X(30).

Then try to use it like

INSERT INTO DEMO
VALUES (:WS-VAR.HV-EMPNO, :WS-VAR.HV-NAME)

Hope it will helpful

kgumraj

Ambiguous is a condition where the variable used is used two times check for it. If you are using just once then.

You check for expanded program in the spool, so that it occurs, I feel your can solve it by using PARM=SOURCE, when you precompile the program in the JCL

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 279 Location: India

Hi,

seems like you have declared your host variable at more than one places. One in the DCLGEN member and the other in the working-storage/linkage section.