FTP from Unix to AS400 to EDI Server


    Sponsored Links


  • 1. STRPCCMD question
    We need to execute .bat file that is on a network folder from an option on an AS400 menu. The folder names contain spaces and the pc that the option is running from does not necessarily have that folder mapped as a drive. Manually typing STRPCCMD ('SUBST O: \\servername\foldername') will map a network drive. However, when I do this in a CL program the mapping does not seem to be done. If I try to run: STRPCCMD ('\\servername\foldername\batchfile.bat') I get an error - STRPCCMD does not like the use of the full network path. I haven't used STRPCCMD for so long - it's obsolete anyhow... Is there an easier way to execute this command from an AS400 menu? Thanks in advance...
  • 2. Outputting Job Logs and messages to a file.
    I have a CL program that runs every night and copies one file to another. Users need to verify that the copy completed successfully, among other things. When I DSPJOBLOG to a file, I do not see the completion message for the copy, i.e. 3 records copied to mylib/ myfile. I would like to output the jobjog and the message file to a log file that the user could display every morning. Any info is always appreciated. Thad Rizzi
  • 3. SQL trigger question
    I have the following trigger: CREATE TRIGGER LIB.TPSSEQG BEFORE INSERT ON LIB.TPS_PTY_ADR REFERENCING NEW AS NEW_ROW FOR EACH ROW MODE DB2ROW SET OPTION DBGVIEW=* -- WHEN ( NEW_ROW . SEQ IS NULL OR NEW_ROW . SEQ = 0 ) BEGIN ATOMIC SET NEW_ROW . SEQ = NEXT VALUE FOR LIB . TPSPTYADRQ ; END ; Anytime a New row is inserted, it will assign a sequence value from TPSPTYADRQ. SEQ is part of the primary key. I had to comment out the WHEN statement, because I was getting "Attempt to write a duplicate record..." error. I figured I may come up w/a reason why I would need to assign a sequence (by passing the trigger logic), hence adding the WHEN statement. It appears there is some funky under the covers stuff happening w/SQL since I'm getting this dup rec error, but w/o the WHEN the Row is inserted as expected and SEQ is assigned the next sequence value. Suggestions what I may be doing wrong? TX Chris
  • 4. Installed Iseries Access and lost internet connection
    Brand new pc running XP. Brand new Iseries.(525) Had fired up internet connection using current DSL line. That worked fine. Installed Iseries Access (latest version) w/service pack. Manually entered IP address in Network connections on pc. Click start on emulation and get a sign on screen. All connections to Iseries work fine including Navigator. Attempted to go back to the web.... No current connection. I'm sure this is a tcp/ip addressing problem but I am not sure what to change. The problem is almost certainly on the PC.
  • 5. Sessions count?
    Is there a way to find out how many sessions were open (or users were connected) at a specific time, for example, 2pm? Thanks Karl

FTP from Unix to AS400 to EDI Server

Postby k_morland » Wed, 17 Dec 2003 02:01:19 GMT

I have been working on an FTP issue that is driving me nuts.  And of
course it is one that is out of the ordinary.

A client sends us a file to the ISeries that is in a Data Stream which
uses the IFS.  I then send it down to our EDI server where they are
supposed to edit it.  (I just work here).  They then send me the
results which I forward back to the client.  The problem is that when
I send it binary, it adds low values to the end of the file which both
Aetna and our EDI group can't handle.  If I send it ASCII then  I have
a limit of 32,766 bytes.  I've tried using the TRIM command with no

namefmt 1
put /qsys.lib/kwmlib.lib/testfile.file/testmbr.mbr testfile

This example gives me the low values are spaces at the end.  Any help
would be appreciated.

Re: FTP from Unix to AS400 to EDI Server

Postby sclind » Wed, 17 Dec 2003 07:00:09 GMT

If the file starts in the IFS, then why do you bring it back into the
library file system?  Files in the library file system have fixed
lengths, and that is probably the source of your problem.

(BTW, a similar questions/answer was posted earlier).


Re: FTP from Unix to AS400 to EDI Server

Postby k_morland » Wed, 17 Dec 2003 21:56:55 GMT

Actually, I am not bringing it back into the library file system.  On
this command I am trying to FTP the file from the IFS on the AS400
down to our server.


Re: FTP from Unix to AS400 to EDI Server

Postby sclind » Thu, 18 Dec 2003 06:47:18 GMT

This is the part that confuses me:

put /qsys.lib/kwmlib.lib/testfile.file/testmbr.mbr testfile

This is not a file in the IFS, this is a file in the 'traditional'
library file system.  It would have a fixed record length.


Re: FTP from Unix to AS400 to EDI Server

Postby Drew Dekreon » Thu, 18 Dec 2003 10:37:25 GMT

you could try issuing a
in FTP before PUTting the file (treats as stream instead of records)
might help (always trims tailing blanks from records)

Re: FTP from Unix to AS400 to EDI Server

Postby Steve Landess » Thu, 18 Dec 2003 14:41:54 GMT

Technically, You're NOT ftp'ing the file from the IFS...

The file /qsys.lib/kwmlib.lib/testfile.file/testmbr.mbr on your iSeries
system is the file named TESTFILE that has a member named TESTMBR in library
KWMLIB.  The long name is simply the way to access this file in the library
file system via the IFS file system.

As Scott pointed out, this file should have fixed length records.

You can view the raw data in TESTFILE from a green screen (5250 emulation
session) using the command:


Once you are viewing the data on the "Display Physical File Member" screen,
press F10, then F11.

This will show the data in the file on three lines:
1) The first line shows the data in character (text) representation
2) The next line shows the first hexadecimal character of the data in hex
3) The next line shows the second hexadecimal character of the data in hex

Steve Landess
Austin, Texas
(512) 423-0935

Similar Threads:

1.AS400 FTP to FTP Server Write problem

I have an FTP site on our W2K server (SP4) that I FTP files to from our
AS400. To do this I need write authority, which is OK, but users
accessing this site from a browser can upload/create anything on this
folder. Is there a way in Internet Information Services, or the folder
itself to stop users from writing to this folder yet still give me
rights to write to it? Permissions on the folder, or on IIS doesn't
seem to check the write privilages.
Anyone know how I can accomplish this?

2.FTP from UNIX to AS400

Hello All,

We receive the following message when we  transfer a flat text file in
ASCII from UNIX to AS400 ftp server :

Error [426-Records written to file FILE1 in library QGPL have been
truncated. Data in file may not be valid.
426 Data transfer ended.]"

Can someone explain the message and suggest how to transfer a file
without data corruption and without error messages. 


3.export library to unix server by as400 box


I wanted to know how to export(exportfs) a library by nfs to unix
server.Also please clear me what is mounting and exporting. why we use
nfs server for this.
Please reply.


4.Securely Connect AS400 to Unix Web Server

Good morning,

We are building a new website and need to securely send/receive data
to/from Unix web server.  I do not know anything about Unix/Linix
boxes and the guy whom I am working with does not know anything about
Any suggestions would be greatly appreciated.

We are running on:

Thank you in advance.

5.VB.NET - Issues with VB.NET FTP Class to UNIX FTP Server

6. "My Network Places" + FTP + Unix FTP Server == no symlinks or dotfiles displayed

7. FTP Problem from AS400 to Windows server 2003 IIS 6.0

8. AS400 FTP, can you launch a bat file on W2K3 server

Return to as400


Who is online

Users browsing this forum: No registered users and 56 guest