FTP from Unix to AS400 to EDI Server

as400

    Sponsored Links

    Next

  • 1. cblle
    Hi how to debug cobol Ile programs..
  • 2. Overhead of (Java) prototypes in RPG?
    Hello all, I was wondering if anyone could comment on the overhead incurred when defining/COPYing prototypes for Java classes and methods in an RPG-ILE program? Is there a significant detrimental side effect to including prototypes for classes and methods which will not be used? Memory... performance? I ask because I was surprised to find that there is no pre-defined "include file" for /COPYing prototypes for commonly used classes and methods from the Java core. I began thinking of creating my own so that I could simply include (/COPY) one prototype definition into my programs and then have some useful Java core libraries immediately at hand, but I don't know enough about how prototypes, /COPY, et al. work behind the scenes (or of profiling RPG-ILE applications) to determine whether this is a good idea or not. Any thoughts or insights are appreciated.
  • 3. DDM Files
    I have a client running 4.4 on a Model 170 because they still want to use OfficeVision. They also want to do pretty printing, but do not have a licence to PSF/400 and noe seem to be about at 4.4. If I connect up say a Model 150 - because the necessary software is in the BasePak - I can get on to it using TELNET and I can use DSPPFM to view a DDM file pointing at the production machine, but is there any way DDM files can be used in programs, or do they need to be copied via the DDM file to a physical file on the second machine? Unless there is a better way of course! Many thanks Peter Kinsman
  • 4. Why is it building access paths
    Consider the following SQL: SELECT count(*) FROM VTVERV35 LEFT OUTER JOIN RTRITTP ON VTDPCODE60 = RTDPCODE AND VTRTNUMM60 = RTRTNUMM WHERE VTVTSTLO BETWEEN 10 AND 50 RTRITTP is a PF and the key of RTRITTP consists of two fields: RTDPCODE RTRTNUMM in this order. On our own system RTRITTP is being used as it should. On the system of our client RTRITTP is being rejected because of reason code 6. Translated from dutch it says something like key of access path does not match those for join operation. Then it builds a new access path where the message says it is being build with key fields *MAP ascend RTRTNUMM ascend *MAP being explained as expression or derived field. Can anyone explain why it would do that ? And how to correct this ?
  • 5. FTP ANSI-formatted file from PC to AS400
    I get a file from a German partner four times a year, it's a PC-file, when I load it into Excel it looks nice using the Windows (ANSI) selection. I need it transferred to the AS400. I cannot use Client Access, since the file contains TAB-characters. THe AS400 is set up with Danish language, QCCSID=65535, QCHRID Character ID is 697 and Code Page is 277. I got the advice some years ago, to use FTP and give the command "quote type c 819" before putting, and that works, except that ? (lower case U umlaut) becomes ~, which does not look nice. I have tried the following alternatives to CCSID 819, but with no succes: 858, 273, 367, 870, 923, 850, 1250, 1004. Any suggestions? Would it ease things to load it via QDLS? I do that with some files I get from Danish partners... Any help is most appreciated! //Mikael Kristiansen

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
effects.

Ex:
bin
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).

Scott

Re: FTP from Unix to AS400 to EDI Server

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

Scott,
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.

Scott

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
STRUCT F
in FTP before PUTting the file (treats as stream instead of records)
also
SITE TRIM 2
or
QUOT SITE TRIM 2
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:

DSPPFM FILE(KWMLIB/TESTFILE) MBR(TESTMBR)

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
form
3) The next line shows the second hexadecimal character of the data in hex
form

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?
Thanks.

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. 

Thanks, 
Alona

3.export library to unix server by as400 box

Hi,

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.

Royy

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
AS400/iSeries.
Any suggestions would be greatly appreciated.

We are running on:
9406-820
V5R2

Thank you in advance.
Gary


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 72 guest