Re: Urgent- Query regarding DDMF -- MIDRANGE-L

Are you alone at your site, or are there other iSeries people there? What platforms are you familiar with? Then we can better focus our replies.

The easiest way I can think of follows some questions--

Can you get the .xls to your machine?

Do you have Client Access?

Do you have the Client Access Data Transfer addins for Excel installed?

If you say "yes" to all of the above, then you can transfer the data directly from Excel to the 400. You might need to use the Excel Addins Manager to get the Transfer addins installed, but when you do, you get a button on your toolbar that starts a wizard, and it's very easy.

Use the help text in Windows - it gives you all you need to know.

If you don't have those, let us know further, saying more about what platforms you know.

As far as detailed steps go, Steve has given you most of what will get you started - NetServer, IFS, FTP - none of really has time to go into all those - you can get information at <www.iseries.ibm.com/infocenter>.

If you use FTP or NetServer, then you need the CPYFRMIMPF command - prompt it (if you don't know what that means, there are bigger problems to solve - I hope you have someone there familiar with the 400 - if not, let us know the reality of your situation) and it will guide you in what to do. Look at the help text - always.

Regards

Vern

At 06:11 PM 7/23/2003 +0530, you wrote:

Respected Sir,

            First of all a Very good afternoon and thanks a lot to all of
you.

My Question is:

****************************************************************************
**************
 I am facing a problem. My task is to Copy a file from a Web
 Server to an AS400 Server. I think it can be done using DDMF concept.
 Suppose I have a file Test.xls in the Web Server whose IP address
 is:192.168.240.250 and port is 8080. I need to copy to the native AS400
 server.  I have created a DDMF file as follows:

 CRTDDMF FILE(ANITEST) RMTFILE(*NONSTD 'test.xls')
 RMTLOCNAME('192.168.240.250' *IP) PORT(8080)

 Is it OK? Could you suggest all the steps for this purpose. My As400
 machine is V5R2.

****************************************************************************
**************

My assumptions after your replies:

I am writing down the informations I got:

1.first I have to save the file Test.xls which is in Web Server as a
comma,tab-separated, or text file.
2.copy this intermediate representation of the file to the AS/400.
3.use CPYFRMIMPF to copy the data within the document to an AS/400 file

Pleas elaborate all the steps I need to do for points 2 and 3 in AS400.

Thanks for your help,
Have a nice day,

Thanks & Best regards,

Aniruddha Dasgupta
RS Software (India) Ltd.
* +91-33-2357-1812(O). Ext - 4210
* aniruddhad@xxxxxxxxxxxxxxxx


____________________________________________________________________________
________________________
This E-Mail message (and attachments) may contain information that is
confidential to RS Software and/or the intended recipient. If you are not
the intended recipient you cannot use, distribute or copy the  message or
attachments. In such a case, please notify the sender by return E-Mail
immediately and erase all copies of the message and attachments.  Opinions,
conclusions and other information in this message and attachments   that do
not relate to the official business of RS Software  are neither given nor
endorsed by it.

> Aniruddha -
>
> The short answer to your question is no.
>
> AFAIK, DDM files are primarily for use between AS/400, iSeries, System/36,
> System/38, and IBM Mainframes.  There used to be an implementation of DDM
> that IBM sold for PC's, but the last time I used it was in the 1980's or
> early 90's.
>
> I'm making an assumption here, but in this case it looks like what you are
> transferring is an Excel document (test.xls).
>
> An Excel document is a PC file in ASCII representation that cannot be
> loaded
> directly into a DB2/400 file.  The only place you will be able to store
> this
> document on the AS/400 is in a folder in the IFS (Integrated File System).
> I'm not sure what you plan to do with this document once you get it loaded
> on the AS/400, unless you have a web server or FTP server running on the
> AS/400 to serve up web pages and/or files for downloading.
>
> Since this is a PC document in ASCII format, there is not much you can do
> with it natively on the AS/400, unless you first save it as a comma,
> tab-separated, or text file, then copy this intermediate representation of
> the file to the AS/400, then use CPYFRMIMPF to copy the data within the
> document to an AS/400 file.
>
>
> To load this file into a folder in the IFS, several options exist.  Here
> are
> a few:
>
> 1) If you have NetServer running on the AS/400 and have designated any IFS
> folders as shared, you can map a network drive from your PC to a shared
> folder in the IFS and copy the file using Windows Explorer.
>
> 2) If you have the iSeries Navigator (Operations Navigator) client
> software
> available, you can also copy files from/to the IFS (This is part of Client
> Access Express, and I think this also requires Netserver to be running on
> the AS/400).
>
> 3) If you have the FTP server running on the AS/400{STRTCPSVR SERVER
> (*FTP)},
> you can start an FTP session from the Web Server to the AS/400, and PUT
> the
> file into an IFS folder via FTP.
>
> 4) If you have an FTP service running on the Web Server, you can start an
> FTP session from the AS/400 to the Web Server and GET the file into a
> folder
> in the IFS via FTP.
>
> 5) If you have Scott Klements' FTPAPI software loaded on your AS/400, you
> can do this from within an HLL program on the AS/400 as long as the file
> resides on a machine that is an FTP server.  For more information about
> the
> FTPAPI tool, see:  http://klement.dstorm.net/ftpapi/
>
>
> If I have missed something or misinformed you about something (and I'm
> sure
> I have done one or both), there are plenty of other participants on this
> list that will throw in their two cents worth.
>
> <grin>
>
> Regards,
>
> Steve Landess
> Austin, Texas
> (512) 423-0935
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.