CPYTOIMPF
I am coping a PF from the iSeries (V5R3M0) using Cpytoimpf, within the file is an alpha field with leading zeros. when the file is opened in excel it drops the leading zeros, assuming it is a numberic field, anyway to retain leading zeros?
Answer Question
| May 16 2008 12:58 AM GMT
| asked by
AmandaC
Data mining/analysis, CPYTOIMPF, V5R3
CPYTOIMPF - Physical file to IFS, get imbedded blanks
I have a physical file with the following fields.(field - attribute - sample content)FILL01 - 1A - blankKEY - 8A - AAPCTINVLENGTH - 2S 0 - 60TEXT - 60 A - 8028038When looking at the file using DSPPFM, the info = AAPCTINV608028038 Note, it has 1 space at the beginingUsing the followingCPYTOIMPF...
View Answer
| May 7 2008 5:04 PM GMT
| asked by
Klw
CPYTOIMPF, DDS, IFS
Where does the time of IFS stored files come from ?
Since we have shifted to summer time, and adapted the Qtime value of the ISeries (V5R4 Model 525), the files created by ISeries native applications and moved by this applications to IFS automaticaly using CPYTOIMPF present a bad creation/modification time. The time is one hour later.I don't find...
View Answer
| Apr 11 2008 7:25 AM GMT
| asked by
TSCHMITZ
AS/400, IFS, Summer Time
Copy DDS defined file to .txt file
I am trying to copy a large, 1.4 mil records, 535 byte records, from an old DDS defined file on the iSeries to a .txt file. I have used FTP and CPYTOIMPF using every combination of setting I can think of. Every time it translates the packed numeric fields correctly but creates garbage for the alpha...
View Answer
| Mar 27 2008 8:55 PM GMT
| asked by
Oldtonew
iSeries, IFS, CPYTOIMPF
creating a .csv from iseries file
I've asked this question before and was told to change the parm in CPYTOIMPF to STMFCODPAG(819). The date in the .csv file is garble. CPYTOIMPF FROMFILE(qtemp/&FILE_NAME) + TOSTMF('/ILS/payops/*tcat &file_name *tcat '.csv') (*REPLACE) + STMFCODPAG(819)...
View Answer
| Dec 18 2007 3:28 PM GMT
| asked by
Shelties
CPYTOIMPF, iSeries
Bad date.
I'm using the "CPYTOIMPF" to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here's what it looks like.ñññòð÷
View Answer
| Dec 14 2007 3:20 PM GMT
| asked by
Shelties
CPYTOIMPF, CSV, iSeries database
AS/400 Journaling download to PC - unreadable data
We are journaling some files on the AS/400 and need to download the journal entries to a pc based file. We are using the DSPJRN command to copy the journal entries to a db file and then using the CPYTOIMPF command to convert it to a text file. This issue is that some of the data is unreadable. ...
View Answer
| Oct 11 2007 6:14 PM GMT
| asked by
Diann
AS/400, Journaling, CPYTOIMPF
