Updating using AS/400 Sequel Viewpoint

30 pts.
Tags:
AS/400
I can find and display files on AS/400, how can I edit data, rather a field? is that possible?
1

Answer Wiki

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

Sequel Viewpoint can do most of the same functions that DB2 SQL can do. The syntax is just a little different,

So you can just do an UPDATE statement.

Discuss This Question: 6  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.
  • ToddN2000
    How do you plan on finding the data to be updated? You need some way to identify the record/row to be updated. This is possible as long as there are no restrictions on the command. For some companies that are ISO certified, you cannot use STRDFU and others for changing data. You may also run into issues if they audit your data and things are done outside the normal processing.
    135,295 pointsBadges:
    report
  • Bigdogg

    Sorry, I specified file Z. (a JDE file), then using 'where' field A = value.  And so now,  field X value, needs to be set to 0.  it contained a wrong value, 1234.

    Theres an 'update' statement in Sequel...?

    30 pointsBadges:
    report
  • CharlieBrowne

    Yes, and you can even do it from a Command line:

    SEQUEL/EXECUTE SQL('Update yourfile set field1 = 'XXX' when field1 = 'bbb')

    That's a sample. You can prompt on SEQUEL/EXECUTE 

    62,385 pointsBadges:
    report
  • IanSimmons
    I didn't know you could do an UPDATE using SEQUEL. However why you would use SEQUEL instead of standard DB2 SQL? I am not sure if SEQUEL fully takes advantage of the SQE query engine and I thought its main advantages were in output formatting and emailing.
    185 pointsBadges:
    report
  • CharlieBrowne

    The one advantage as a developer is that you can run a SEQUEL statement and have it email your selection as a report or .csv.

    From a user POV, the interface is friendly.

    The place I am at now has had it for many years and have many programs using it. Lots of views created by users.

    I rarely use it.


    62,385 pointsBadges:
    report
  • Bigdogg

    I utilize Sequel Viewpoint, because our place has JDE and I use it for quick references into their files, among other small programming. That and I do not know SQL very well. I only asked because as robust as Sequel is(?), I never could, "update" a field before? I've searched the manual I have, never found the way to do that procedure.

    Anyways, thanks guys for helping me out tho!

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