error in DB2/400

5 pts.
Tags:
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...
ASKED: September 1, 2008  2:26 PM
UPDATED: September 2, 2008  3:24 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tpinky
    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.
    4,165 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following