on 12-06-2006 6:00 PM
Dear All,
We want to export a table data from our sap system to local file. Can anyone tell us the command to execute the same for AS400 server. we are using IBM iseries machine.
Thanks,
Sailesh K
Hi Sailesh,
you could use CPYTOIMPF in CLP for this table )
Then it e.g. looks like a spreadsheet. if you prefer ABAP, there are function modules that help in this area.
Regards
Volker Gueldenpfennig, consolut.gmbh
http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a sample syntax of the command:
CPYTOIMPF FROMFILE(R3D01DATA/ZSTSRNO) TOSTMF('\the directory path of IFS ..') MBROPT(ADD) RCDDLM('choose one') DTAFMT(DLM) STRDLM('"') FLDDLM(',')
You have a liberty to choose many formats for record delimiter , string delimiter, filed delimietr and so on.
To get a full help information of how to use this command, type CPYTOIMPF at OS/400 command line and press F1.
Satid S.
IBM Thailand
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.