Re: Strange SQL behavior

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

----- Original Message -----
From: "Amitava Banerjee" <Amitava.Banerjee@trin.net>
To: <rpg400-l@midrange.com>
Sent: Friday, February 08, 2002 4:22 PM
Subject: Strange SQL behavior


I found that if I don't do the OVRDBF, then SQL gives message that "IIC in
QTEMP type *FILE not found", which is normal. But after doing OVRDBF it is
happening. I did these from command line, though I think it does not matter
whether you do it from command line or by a CL program and then run
interactive SQL. Does any body have any idea why it is happening?


[bruce] Quite frankly, you told it to.
In the override, you spec a file name and basically tell the system to
ignore the library and point to the override library. So SQL, with *SYS
naming follows the override and not your request for atemp or any other
library for that file.

In other words, the library qualification is superfluous after the override.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Suppose you were an idiot...
  And suppose you were a member of Congress...
  But I repeat myself."
    - Mark Twain