Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
IDS 9.21.UC4 on Solaris 2.6
Look at this code:-
select pnr_locator
from ftravel_tr4@ifmx_flx:pnr_info
where pnr_locator not in
(select pnr from rpt_table where dep_date > TODAY-331)
and pnr_locator not in
(select pnr_locator from pnr_status where pnrstat = 'A')
^^^^^^^^^^^
this is a typo. There is no such field pnr_locator in the table
pnr_status. The correct column name is pnr.
But the query runs fine without returing any rows. It took me
hours to find it out. Once I corrected the column name, the
query started running fine.
The above was tested in dbaccess.
Is this a bug. Sounds too lame. This is basic sql parsing which is
failing.
ravi
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.