Re: Process a network text file(s) from RPG. -- RPG400-L

http://www.scottklement.com/

All will be answered.
We owe Scott pots and pots of thanks, he's shown us the way to do these things.

John Rusling wrote:

I haven't mad much luck searching so far ---

I'd like to take 1 or more text/csv file(s), on one of our network
drives,
and append them into a single file on the same network drive. Ie,
file1's last record is followed by file2's first record, etc. I want to
do this
using a straight up RPG program.

I know I could do this using (embedded?) qshell if the files were
on the IFS. (or reading and writing using the IFS apis for that matter)

Is this possible to accomplish in RPG for network drive files?
Can anyone help with some direction, or, better keywords to search on
<g> ?

Thanks,

John B.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
rpg400-l-request@xxxxxxxxxxxx
Sent: Friday, May 02, 2008 12:00 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RPG400-L Digest, Vol 7, Issue 372

Send RPG400-L mailing list submissions to
rpg400-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
rpg400-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
rpg400-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of RPG400-L digest..."

*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. RE: Processing a 2D barcode... (Robert Rogerson)
2. RE: Processing a 2D barcode... (Phil Kestenbaum)
3. RE: Processing a 2D barcode... (Robert Rogerson)
4. Re: Relaying a (not) passed parm to another proc (James Lampert)

----------------------------------------------------------------------

message: 1
date: Fri, 2 May 2008 09:00:44 -0400 from: Robert Rogerson <robertrogerson@xxxxxxxxxx>
subject: RE: Processing a 2D barcode...

Is it possible to have the scanner write the data to a data queue?

Rob R.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Armbruster, Tom
Sent: May 1, 2008 10:58 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Processing a 2D barcode...

Mike is right about this process, so long as there are no commas in the
individual bar codes. That would be bad.
The first question to ask yourself is the format of the barcodes in
question. The comma delimitation is obviously a product of the scanning
software or program. That delimiter may be customizable. If so, change
the
delimiter to an ASCII or EBCDIC character that would never be part of
the
individual barcode. That will allow you to trap the end of the record
without interference.
If the delimiter can not be customized, the next step would be minimum
length. If you know, for example, that your end delimiter may be
repeated
in the actual barcode, set a minimum length for the first occurrence to
scan
for the "real" end of the input substring. In other words, if the
barcode
will never less than 10 characters, don't scan for the delimiter within
the
first 10 characters of the substring.
Tom Armbruster

________________________________

From: rpg400-l-bounces@xxxxxxxxxxxx on behalf of Mike Krebs
Sent: Thu 5/1/2008 7:00 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Processing a 2D barcode...

Off the top of my head, you are going to have to read the data to a long
text field and write a parsing routine to move them to the subfile. I
don't
know of any support for parsing the barcodes directly into a subfile.
Can
the scanners translate the commas into some other character (like a
field
exit)?
Mike Krebs

----- Original Message ----
From: Robert Rogerson <robertrogerson@xxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, May 1, 2008 1:51:33 PM
Subject: Processing a 2D barcode...

Please let me know if this is posted to the wrong list.

I am looking at how to process a scanned 2D bar code in RPG and populate
a
subfile.

I have no problem when scanning a single barcode but the 2D barcode may
contain 80 individual barcodes which are comma separated.

I am checking the Web for any information but so far have found none.

Is there anyone with experience who can point me in the right direction.
At
this point any help would be appreciated.

Thanks in advance,

Rob R.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

________________________________________________________________________
____
________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

------------------------------

message: 2
date: Fri, 2 May 2008 09:30:59 -0400
from: "Phil Kestenbaum" <pkestenbaum@xxxxxxxxxxx>
subject: RE: Processing a 2D barcode...

Is the problem here the subfile part? I am certain you can scan to a display field and write it.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Robert Rogerson
Sent: Friday, May 02, 2008 9:01 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Processing a 2D barcode...

Is it possible to have the scanner write the data to a data queue?

Rob R.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Armbruster, Tom
Sent: May 1, 2008 10:58 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Processing a 2D barcode...

Mike is right about this process, so long as there are no commas in the
individual bar codes. That would be bad.
The first question to ask yourself is the format of the barcodes in
question. The comma delimitation is obviously a product of the scanning
software or program. That delimiter may be customizable. If so, change
the
delimiter to an ASCII or EBCDIC character that would never be part of
the
individual barcode. That will allow you to trap the end of the record
without interference.
If the delimiter can not be customized, the next step would be minimum
length. If you know, for example, that your end delimiter may be
repeated
in the actual barcode, set a minimum length for the first occurrence to
scan
for the "real" end of the input substring. In other words, if the
barcode
will never less than 10 characters, don't scan for the delimiter within
the
first 10 characters of the substring.
Tom Armbruster

________________________________

From: rpg400-l-bounces@xxxxxxxxxxxx on behalf of Mike Krebs
Sent: Thu 5/1/2008 7:00 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Processing a 2D barcode...

Off the top of my head, you are going to have to read the data to a long
text field and write a parsing routine to move them to the subfile. I
don't
know of any support for parsing the barcodes directly into a subfile.
Can
the scanners translate the commas into some other character (like a
field
exit)?
Mike Krebs

----- Original Message ----
From: Robert Rogerson <robertrogerson@xxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, May 1, 2008 1:51:33 PM
Subject: Processing a 2D barcode...

Please let me know if this is posted to the wrong list.

I am looking at how to process a scanned 2D bar code in RPG and populate
a
subfile.

I have no problem when scanning a single barcode but the 2D barcode may
contain 80 individual barcodes which are comma separated.

I am checking the Web for any information but so far have found none.

Is there anyone with experience who can point me in the right direction.
At
this point any help would be appreciated.

Thanks in advance,

Rob R.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

________________________________________________________________________
____
________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.