ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

qry/400 doubt

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • qry/400 doubt

    Hi All,
    Appreciate your time efforts spent to answer me!

    In the wrkqry I did following
    1)Specify file selections
    T01.file and T02.xlfile are there
    2)Type of join is 1 (Matched records)

    3)Specify how to join files
    T01.optcod = T02.ioptcod
    T01.client = T02.iclient
    T01.futur = T02.ifutur

    do I have any option to replace T01.optcod with T02.NOPTCOD (something like
    EVAL T01.OPTCOD =T02.NOPTCOD) under the above conditions....

    My final file is FILE and I cant take any fields from T02.


    JoeP

  • #2
    Re: qry/400 doubt

    Hey Joe ...

    Unless things have changed dramatically... there is no vechicle for modifying the table (do an eval) of either table. You can however export your solutions into a 3rd table and create that.

    Is there any reason why you don't do a SQL job? Or RunSqlSTMT?

    At that point, you could do an "Update Where and change the value of T01.OPTCOD to T02.NOPTCOD.

    Just a thought.

    -Rick

    Comment

    Working...
    X