Home > IT Answers > AS/400 > error in DB2/400
Nayak
5 pts.
 error in DB2/400
AS/400 errors, DB2/400
Hi, i created a physical file(named 'PHF1') and created a logical file(named 'LF1') in Source file(named 'MYSRC')..i complied those files and inserted data.. i wrote a query by STRSQL,that query is "SELECT * FROM LF1"...But i getting a error as "LF1 in *LIBL type *FILE not found" NOTE: I'm using Mocha TN5250 trial version Please anybody reply soon...

Software/Hardware used:
ASKED: September 1, 2008  2:26 PM
UPDATED: September 2, 2008  3:24 PM
RELATED QUESTIONS
Answer Wiki:
Nayak.... You didn't indicate if the library where PHF1 and LF1 are is in your library list when you issued the STRSQL command. If it is in the library list then try naming the library on the select command: Select * from specific_library/LF1 You can also issue the STRDBG command without any other parameters. Then issue STRSQL, run your select statement and then review the job log for your job. Doing this will generate a trace of what SQL is up to and it might help pinpoint the problem. Hope this helps... Phil
Last Wiki Answer Submitted:  September 2, 2008  1:50 pm  by  djac   900 pts.
All Answer Wiki Contributors:  djac   900 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hello,

Unless you have the library in your library list or the library list of the program you are in, you do have to qualify the library name.

Tpinky
 4,165 pts.