db2 precomp+comp+iewl error



IBM's flagship relational database management system

db2 precomp+comp+iewl error

Postby KBS_123 » Thu Mar 03, 2016 2:55 pm

plz help me with dis error
You do not have the required permissions to view the files attached to this post.
KBS_123
 
Posts: 4
Joined: Thu Mar 03, 2016 12:54 pm
Has thanked: 4 times
Been thanked: 0 time

Re: db2 precomp+comp+iewl error

 

Re: db2 precomp+comp+iewl error

Postby enrico-sorichetti » Thu Mar 03, 2016 3:02 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort

These users thanked the author enrico-sorichetti for the post:
KBS_123 (Thu Mar 03, 2016 4:00 pm)
enrico-sorichetti
Global moderator
 
Posts: 2554
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 121 times

db2 precomp+comp+iewl error

Postby KBS_123 » Thu Mar 03, 2016 3:43 pm

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
KBS_123
 
Posts: 4
Joined: Thu Mar 03, 2016 12:54 pm
Has thanked: 4 times
Been thanked: 0 time

Re: db2 precomp+comp+iewl error

Postby NicC » Thu Mar 03, 2016 4:27 pm

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'?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2602
Joined: Sun Jul 04, 2010 12:13 am
Location: Not where I would like to be
Has thanked: 4 times
Been thanked: 92 times

Re: db2 precomp+comp+iewl error

Postby NicC » Thu Mar 03, 2016 4:37 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2602
Joined: Sun Jul 04, 2010 12:13 am
Location: Not where I would like to be
Has thanked: 4 times
Been thanked: 92 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post