RE: creating an ascii text file

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Angela,

Run a Query e.g. STRSQL and (select * from yourfile) but do a PF13 to change
the values ...
(dont forget to change them back)

                          Interactive SQL Session Services



 Select one of the following:



      1. Change session attributes

      2. Print current session

      3. Remove all entries from current session

      4. Save session in source file



 Selection  1  <===== Pick this

then.........
                          Change Session Attributes



Type choices, press Enter.



  Statement processing . . . . .   *RUN           *RUN, *VLD, *SYN

  SELECT output  . . . . . . . .   3              1=Display, 2=Printer

                                                  3=File

  Output file:

    File . . . . . . . . . . . .   YOURFILO       Name

      Library  . . . . . . . . .     YOURLIB      Name

    Member . . . . . . . . . . .   *FILE          Name, *FILE, *FIRST

    Option . . . . . . . . . . .   1              1=Create file

                                                  2=Replace file

                                                  3=Create member

                                                  4=Replace member

                                                  5=Add to member

    Authority  . . . . . . . . .   *LIBCRTAUT     Authorization list name

                                                  *LIBCRTAUT, *CHANGE, *ALL

                                                  *EXCLUDE, *USE

    Text . . . . . . . . . . . .   What ever the file is




More...
F3=Exit   F4=Prompt   F5=Refresh   F12=Cancel

After the query the selected data will be in a native 400 file which can be
ftp'd to you workstation as ascii.
But it seems you already have the file so just use ftp setting ascii by
typing ascii at the ftp prompt.

 F3=Exit     F12=Cancel


-----Original Message-----
From: Angela Wawrzaszek [mailto:awawrzaszek@nucorauburn.com]
Sent: Friday, November 30, 2001 1:48 PM
To: Midrange Mail List (E-mail)
Subject: creating an ascii text file


    I am trying to create an ascii text file from an as/400 file.   I have
tried using CA file transfer,  cpytoimpf,  and excel.   I need the file to
either have eachfield separated with a comma and text fields with single
quotes   OR   field delimiter is an * and no quotes on text fields.   The
cpytoimpf doesn't like the *   or the single quote as the string delimeter.
I would like to automate this process.  I am using the newly created file on
a Dunn & Brad Ram product.

Any help???

Thanks!

Angela Wawrzaszek
Nucor Steel Auburn INC.
Programmer/Analyst
(315) 258 4205
wawrzaszek@nucorauburn.com

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