AS/400: How to insert data from one table to another?

85 pts.
Tags:
AS/400
WRKQRY
How do I insert data from one table to another by using WRKQRY? Is it possible to use INSERT INTO condition in WRKQRY? or else is there any other possibility?

Software/Hardware used:
AS400

Answer Wiki

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

You cant insert/update data using WRKQRY.

Consider using SQL.

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.
  • ToddN2000
    I believe you can output the WRKQRY results to a table. As long as the format is the same, in the define database field output, set the data in file to a 5. This with the add the new data to the existing member.
    102,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.

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

Following

Share this item with your network: