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.
Register Hereor login if you are already a member
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...?
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
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.
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!