Page 1 of 1

db2 precomp+comp+iewl error

PostPosted: Thu Mar 03, 2016 2:55 pm
by KBS_123
plz help me with dis error

Re: db2 precomp+comp+iewl error

PostPosted: Thu Mar 03, 2016 3:02 pm
by enrico-sorichetti
do not post attachments, not everybody can see them
a plain text cut and paste from Your 3270 emulator window is more than enough.

most probably(*) DEPT-NUM is defined multiple times and the preprocessor can not choose

(*) not probably... certainly,
the EMPLOYEE table has the department where the employee works
the DEPARTMENT table has the department details

db2 precomp+comp+iewl error

PostPosted: Thu Mar 03, 2016 3:43 pm
by KBS_123
DSNHSMUD LINE 92 COL 34  REFERENCE TO HOST VARIABLE DEPT-NUM IS AMBIGUOUS
DECLARE CUR1 CURSOR FOR
SELECT EMP_NUM,EMP_STATUS,LAST_NAME,DEPT_NUM FROM EMPL1
WHERE DEPT_NUM = : DEPT-NUM

Re: db2 precomp+comp+iewl error

PostPosted: Thu Mar 03, 2016 4:27 pm
by NicC
Not at all obvious what you are wanting to tell us - you say precompiler, compiler, linker error but you only show one error. From the pre-compiler? And that states clearly what the error is. You understand the meaning of the word 'ambiguous'?

Re: db2 precomp+comp+iewl error

PostPosted: Thu Mar 03, 2016 4:37 pm
by NicC
Pleases do not use 'kiddy-speak'. 'plz' is wrong - write 'please'; 'dis' is wrong write 'this'. You are supposed to be a professional so try and present yourself as one.