Re: Updating records in a file

Rick,

What version of the OS are you running? Newer versions of the OS have a
command called RUNSQL. With that command you can easily run
UPDATE MYFILE SET THATDATE=THATDATE + 1 YEAR
If its a numeric or character pretending to be a date field then there's a
few more considerations that you have to handle manually, like adding a
year to 20120229.

If you have an older version of the OS and do not have this command it's
not too hard to find a 'roll your own' version on the internet. The
appearance of this command is not dependent on having 57##ST1 loaded.

There is a command called STRSQL. It does require that you have 57##ST1
loaded. If you have that command and aren't using it, well, you're about
to embark on a fun new path and you're not in Kansas anymore.

I know that some people look at graphical user interfaces like they're the
tool of the devil but there is something called "System i Navigator".
Buried within it is something called "Run SQL Scripts" and you can easily
run that sql command from within that. This doesn't matter if you have
57##ST1 loaded or not.

You can also bury that command into a source member and use the command
RUNSQLSTM.

For a tutorial on SQL I used "SQL/400 Developer's Guide" by Paul Conte and
Mike Cravitz. It's rather dated but still a good training start.


Rob Berendt