enter SRTSQL Satements AS400

5 pts.
Tags:
as400/DB2
Hi, I have done an index by "create index......" and when I am trying to do aquery with STRSQL on that index I receive the following error:

BKPPDAI1 in BKTEST not table, view, or physical file.

This is my Statement:

select *from bktest/BKPPDAI1

I am trying to fix the syntaxis but I can not make it work... please I need to know why ando how to fix this. THANKS.



Software/Hardware used:
AS400
ASKED: May 6, 2012  3:46 PM
UPDATED: May 7, 2012  12:52 PM

Answer Wiki

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

Discuss This Question: 3  Replies

 
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
  • philpl1jb
    SQL queries should always be writen on the Physical File The query engine decides when to use an index to speed processing.
    48,595 pointsBadges:
    report
  • TomLiotta
    ...writen on the Physical File Phil is right. You don't query the index; you query the table and DB2 decides when to use the index. All you need to do is create the index. It will be used when it is needed. Tom
    125,585 pointsBadges:
    report
  • CharlieBrowne
    If you do a WRKOBJ bktest/BKPPDAI1 Does this object exist?
    39,875 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