Error: UNDEFINED or UNUSABLE Host Variable

sandeep_yadav_in · Posted: Mon Sep 03, 2007 12:34 pm

Hi Guys,

Can anyone please tell me how to resolve this error? "UNDEFINED or UNUSABLE Host Variable"

DSNH312I E DSNHSMUD LINE 41 COL 21 UNDEFINED OR UNUSABLE HOST VARIABLE "HEMPID"
INSERT INTO EMPLOYEE(EMPID,EMPNAME)VALUES(: HEMPID,: EMPNAME)

I've declared these two variables
WORKING-STORAGE SECTION.
01 HEMPID PIC 9(5).
01 HEMPNAME PIC X(20).

This is the procedure division.
A00-MAIN-PARA.
MOVE '11111' TO HEMPID.
MOVE 'SHYAM' TO HEMPNAME.
EXEC SQL
INSERT INTO EMPLOYEE(EMPID,EMPNAME)
VALUES (:HEMPID,:HEMPNAME)
END-EXEC.

Thanks in advance..

guptae · Posted: Mon Sep 03, 2007 12:47 pm

Hi Sandy,

U have declared HEMPID as numeric but u rmoving string into that

sandeep_yadav_in · Posted: Mon Sep 03, 2007 1:21 pm

Thanks Ekta........

William Thompson · Posted: Mon Sep 03, 2007 3:16 pm

sandy,

Did that work or is EMPID actually declared as a string?

sandeep_yadav_in · Posted: Wed Sep 05, 2007 12:37 pm

Hi William,

Yeah it worked......

i also changed the pic clause to
PIC 9(5) USAGE IS COMP-3