Copy To Import File

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

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 file to the new...

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

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

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

AS400

CL - Copy To Import File

I am using the CPYTOIMPF fromfile(PF) to STMF('dir\acp&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.

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.