If you need to convert a stream file to a 132 byte file, you can user the copy from stream file command (CPYFRMSTMF).
Ron Katz ENTRACK Inc. 401-334-2463 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] _____ From: Brian Carbone [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 10:31 AM To: Ron Katz Subject: RE: [EDI-L] FTP'ing Outbound EDI -> AS/400 Hi Ron, Thanks for the response! The file coming in is a regular X12 file whose segment terminator is a ~. So since it's on one line, it's a steam file. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Katz Sent: Wednesday, January 09, 2008 1:28 PM To: 'sbsrfr'; [email protected] Subject: RE: [EDI-L] FTP'ing Outbound EDI -> AS/400 To ??? Yes I am sure there is a more straight forward way of doing this. When your first FTP session specifies "namefmt 0", it is putting the data within the QSYS library system so the filers are native AS/400. Your 2nd FTP session uses "Namefmt 1" which puts the data in a folder on the AS/400 IFS. You said you want to convert the file you FTPd to a 132 length file. How is the file coming in as that you want to convert? (Wrapped, unwrapped, stream file, record length) Ron Katz ENTRACK Inc. 401-334-2463 <mailto:[EMAIL PROTECTED] <mailto:ron.katz%40entrack.com> com> [EMAIL PROTECTED] <mailto:ron.katz%40entrack.com> com _____ From: [EMAIL PROTECTED] <mailto:EDI-L%40yahoogroups.com> com [mailto:[EMAIL PROTECTED] <mailto:EDI-L%40yahoogroups.com> com] On Behalf Of sbsrfr Sent: Tuesday, January 08, 2008 5:29 PM To: [EMAIL PROTECTED] <mailto:EDI-L%40yahoogroups.com> com Subject: [EDI-L] FTP'ing Outbound EDI -> AS/400 Greetings Everyone, First, let me give you a background on our current setup. 1) Our EDI translator is Trusted Link Enterprise and is on the AS/400. 2) Currently our inbound process is utilizing BizManager for the AS/400. The goal is to move off of BizManager and move it to Tibco BW/BC. --- Current AS/400 Process: 1) Do an FTP pull from the VAN and retrieve the EDI data. 2) Convert the EDI to 132 character blocks (necessary for Trusted Link), and integrate the data into a table in its native format. 3) All the conversions and routing are done through BizManager currently. --- Tibco Process: Currently there is a Tibco process setup that can be duplicated to accomplish this. My Tibco admin has noted that Tibco does not have the ability to convert the EDI into 132 character chunks and that's where the issue comes in. --- Workaround to get the 132 Character Block Formatting: 1) Tibco takes the inbound EDI and pushes it to the AS/400 in ASCII format. 2) The data is then FTP'd to another folder on the AS/400 from a script. The only special parameters I'm seeing are "namefmt 0" and "BINARY mode." 3) Next the data is pulled back in where Trusted Link listens for it from a script. The only special parameters I'm seeing "namefmt 1" and "BINARY mode." When steps 2 & 3 are combined, the EDI file gets converted to 132 character blocks. I don't really understand why and the person who wrote the process can't explain it to me either. --- End Goal: 1) Eliminate this "football" FTP process we have setup and get the data in its 132 characters blocks in a single upload. Again, this football process was invented and magically worked because Tibco can't do the 132 character conversions. 2) Understand how those two FTP steps "magically" convert the data into 132 character blocks. Can anyone explain this? Any ideas or insight would be appreciated, thanks. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
