CPYTOIMPF
CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF(‘C:/Documents and Settings/user/exc.xls’) MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created a Excel book with name exc.xls , my requirement is to copy all the records from my physical file (sarkns/enqp003) to the desired excel book. when i run this command I am getting message zero records are copied . Could u suggest me [...]

Answer Question   |  July 10, 2009  6:58 AM
Copy To Import File, CPYTOIMPF, Microsoft Excel import/export, Physical File

AS/400 data mapping with CPYFRMIMPF
We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old [...]

Answer Question   |  May 7, 2009  2:10 AM
AS/400 data mapping, Copy From Import File, Copy To Import File, CPYTOIMPF, DB2, DB2/400

CPYTOIMPF
When i enter this command i find this error. CPYFRMIMPF FROMSTMF(‘/new_recon_conv.csv’) TOFILE(NAVNEET/TT4 TT4) MBROPT( *REPLACE) RCDDLM(*CRLF) STRDLM(‘”‘) FLDDLM(‘|’) DATFMT(*USA) RPLNULLVAL(*F LDDFT) The copy did not complete for reason code 7 what shud i do?

Answer Question   |  March 20, 2009  8:01 AM
AS/400 administration, Copy To Import File, CPYTOIMPF

CPYTOIMPF – PC .TXT file displaying as ‘garbage’
Hi, We are using a simple CPYTOIMPF command to move a Physical file to the IFS in a .TXT format. CPYTOIMPF FROMFILE(S4CMREP) TOSTMF(&TOIMPTF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + STRDLM(*NONE) FLDDLM(*TAB) Where &TOIMPTF is a IFS Folder & file name. This was working correctly until we recently applied operating PTF’s to the AS400. Now when we try [...]

Answer Question   |  February 7, 2011  10:52 AM
AS/400 administration, Copy To Import File, CPYTOIMPF, IFS, Physical File

Command to copy database file to folder in AS/400?
AS400

Answer Question   |  March 4, 2010  7:34 AM
AS/400 administration, Copy To Import File, Copy To PC Document, CPYTOIMPF, CPYTOPCD

CL – Copy To Import File
I am using the CPYTOIMPF fromfile(PF) to STMF(‘diracp&txtfile’) where &txtfile is &curdt *tcat &curtm.(system date and time) The stream file is created as acp&txtfile and what i want is acp120108100150.

Answer Question   |  December 1, 2008  10:13 AM
CL, CL/400, Copy To Import File, CPYTOIMPF

TXT file naming using CL
Hi I hve created a txt file from a pf using cpytoimpf.The name of the txt file should have ccyymmddhhmmss in its name.I can retreive the date and time parameters from qdate and qtime.How do i name the txt file using a CL.

Answer Question   |  November 26, 2008  11:16 AM
CL, CL/400, Copy To Import File, CPYTOIMPF