|
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.
As an Amazon Associate we earn from qualifying purchases.
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.