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
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Rick Mason <rmason62@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/05/2014 12:42 PM
Subject: Re: Updating records in a file
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



All i know at this point is that it appears to be a date field...wrong
year
in about 15,000 records.
Thanks
On Nov 5, 2014 12:33 PM, "Rick Mason" <rmason62@xxxxxxxxx> wrote:

Hi all,
I just found out a tax file will need be updated to correct an incorrect
date field.
I have not used DFU that much..i know i can change specific records in a
file via the record number but how can DFU change a date field in 15,000
records uni this file.
Thanks

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.