Top N query using DB2

347780 pts.
Tags:
AS/400
IBM DB2
I need to perform a
Select top N * from as400table
query against an AS/400 using DB2. Any thoughts?

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: 2  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

    Select * from myfile

    Where fld1 = 'XYZ'

    fetch first 50 row only

     

     

    50,205 pointsBadges:
    report
  • TomLiotta
    A more specific case would be to use the SQL standard way, assuming that the question is asking about an ordered set. If so, then the SQL RANK() function would be appropriate. The use of TOP N is non-standard. The version of DB2 is needed for the question since RANK() became native in V5R4. -- Tom
    125,585 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