Delete and Update in Query Magager

5 pts.
Tags:
iSeries
OS/400
Query Manager
How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment.

Please help, a production project in pending for this.



Software/Hardware used:
OS/400 on IBM iSeries Servers

Answer Wiki

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

I do not believe QM supports updates.
You should switch to use the RUNSQLSTM.

=======================================================

Run STRQM and take option 10 (Work with Query Manager profiles). Position to the user profile running the QM queries; select option 2=Change.

Scroll to the end of the Change Query Manager Profile display and set ‘Select allowed Query Manager SQL statements’ to ‘Y’=Yes. Press <enter>.

The list that appears allows you to customize the allowed SQL statements for that user profile when QM queries are executed.

Tom

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
  • ASWDEVELOPER
    if you're going to use a big hammer like SQL to delete things, you might want to make a copy of anything you delete ... and keep your resume current ...
    405 pointsBadges:
    report
  • TomLiotta
    Before executing SQL DELETE, I run the same statement with SELECT * as the verb. This provides a clear list of what will happen when I replace the verb. Far easier than attempting to do the same by coding a program and far safer. Not that it's particularly dangerous either way since I'll have journaling enabled. And it'll all be done with a test subset in the beginning anyway. 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