DYNSLT Omit

560 pts.
Tags:
DYNSLT
OMIT
Hi, How do I do the SQL clause 'Where x.a = y.a and x.b = y.b and x.c = y.c' in a Omit DYNSLT of a logical file?

Software/Hardware used:
IBMi V7R1

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: 5  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
  • TomLiotta
    First, you need to have all six of those fields defined in the record format, so three of them will have to be renamed. Second, your WHERE clause is designed for 'select', so its logic will have to be reversed to give an 'omit' result. Assuming that you RENAME the three fields from file Y to YA, YB and YC, the logical form would be "Omit records with A COMP(NE YA) or with B COMP(NE YB) or with C COMP(NE YC). Select ALL other records."   Does that sound like the logic that you need? What is the actual difficulty you are having?   You would probably be better off using SQL to do the work.   Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    Note that it's not clear exactly which records you want to process. By showing a WHERE clause and then asking about 'Omit', it's not clear if you want to process or skip the records from the WHERE clause.   Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    These look very much like the join fields.  If these are the join fields, they shoud be used in the join section of the logical not the select/omit section.Phil 
    50,415 pointsBadges:
    report
  • bogeybetsy
    Hi,Thanks for the answers.  I did it byA  S     X.A     COMP(NE  Y.A)A         X.B      COMP(NE  Y.B)A         X.C      COMP(NE  Y.C)The dot notation is just to inform you that the field comes from a different file.  This is for a JLF...using one instead of an MQT...to be used by a subfile scroll program.  With the MQT, users would have to wait, 40 seconds to 2 minutes waiting for it to "refresh".  The JLF, although slower, performs better because each page only has to show 13 records - and retrieving 13 records from the JLF is much faster than a "refresh" of the MQT which will show data that is not "real-time".
    560 pointsBadges:
    report
  • TomLiotta
    This is for a JLF…using one instead of an MQT…   How did a MQT get involved in this? Why would you want a MQT? Why not a simple view (supported by appropriate indexes)? 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