join error

[KBS_123]

Code: Select all

EXEC SQL                                    
    SELECT A.EMP_NUM,A.EMP_STATUS,A.LAST_NAME, B.DEPT_NUM,B.DEPT_NAME                  
      INTO :EMP-NUM, :EMP-STATUS, :LAST-NAME, :DEPT-REC.DEPT-NUM, :DEPT-NAME                      
      FROM EMPL1, DEPT1                        
      WHERE  A.EMP_NUM = :WS-EMP-NUM      
      AND    A.DEPT_NUM = B.DEPT_NUM  
END-EXEC

Error messages

Code: Select all

UNDEFINED OR UNUSABLE HOST VARIABLE "DEPT-REC"
UNDEFINED OR UNUSABLE HOST VARIABLE "DEPT-NUM"

[enrico-sorichetti]

it is not a join error,

Code: Select all

UNDEFINED OR UNUSABLE HOST VARIABLE "DEPT-NUM"

what does the message hint ?

[Raja190]

check for the for correct host variable names generated in the DCLGEN.

refer your DCLGEN copy book and updated the variable names. (there might be discrepancies in "-" "_" )