× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Or read through your output file and use the %replace BIF to pull the
spaces out?

Mike E.





                    rob@dekko.com
                    Sent by:                To:     rpg400-l@midrange.com
                    rpg400-l-admin@mi       cc:
                    drange.com              Subject:     RE: Assign a Value


                    11/22/02 01:09 PM
                    Please respond to
                    rpg400-l






This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Convert all your fields to variable length fields?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Tracy Ball" <tball@totalresponse.com>
Sent by: rpg400-l-admin@midrange.com
11/22/2002 12:01 PM
Please respond to rpg400-l

        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: Assign a Value


I finally figured out how to do both, however, that extra spaces are not
eliminated.  Is there a way to get it to look like a true CSV format?

-Tracy
 Ext. 3107


-----Original Message-----
From: meovino@estes-express.com [mailto:meovino@estes-express.com]
Sent: Friday, November 22, 2002 9:05 AM
To: rpg400-l@midrange.com
Subject: RE: Assign a Value



Tracy,

Are you trying to create/fill a database file or a PC stream file?  If
it's
a database file, it doesn't have to be externally described.  Rob's method
is probably the easiest way to go.  But if your desired end result is a
CSV
file for a PC (which seems likely, but may not be the case), just go
straight for the stream file option and cut out a step.

Mike E.





                    rob@dekko.com
                    Sent by:                To:     rpg400-l@midrange.com
                    rpg400-l-admin@mi       cc:
                    drange.com              Subject:     RE: Assign a
Value


                    11/21/02 04:39 PM
                    Please respond to
                    rpg400-l






This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Existing externally defined file is bad.

I just did it with CRTPF ... RCDLEN(...) and no DDS.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Tracy Ball" <tball@totalresponse.com>
Sent by: rpg400-l-admin@midrange.com
11/21/2002 03:51 PM
Please respond to rpg400-l

        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: Assign a Value


I am just now learning of the CPYTOIMPF, and I have seen this command
referenced a few times so far.  However, in just trying to do the command
for a temporary file, I get an error saying my TOFILE is not the right
file type.   Doesn't this defeat the purpose of a temporary file, if the
file has to be an existing externally described file?

And yes, this may seem like a basic question, and no doubt I could become
an expert if I take more time to research this, however, I can think of
immediate uses for this, and I was wanting to test this right away!

-Tracy
 Ext. 3107


-----Original Message-----
From: Haas, Matt [mailto:Matt.Haas@thomsonlearning.com]
Sent: Thursday, November 21, 2002 2:23 PM
To: rpg400-l@midrange.com
Subject: RE: Assign a Value


Bill,

An easier way to get a file with comma separated values to create a
temporary file with the data and use the CPYTOIMPF command.

Matt

-----Original Message-----
From: bill totz [mailto:robsurge@hotmail.com]
Sent: Thursday, November 21, 2002 2:11 PM
To: RPG400-L@midrange.com
Subject: Assign a Value




Is there a way to assign a value to a field in DDS. For example I have a
client which requires us to seperate our fields by commas. I would like to
code this in the DDS rather than in my pgm-there are over 120 fields. I
would use the values keyword but I think this just allows certain
values-not
assign.


Thanks



_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus

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

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

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


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





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

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


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







As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.