Problem with delimiter in CPYTOIMPF
I have used pipe symbol | as the delimiter to seperate fields.I used this in a DS and moved it to a flat file.From the flat file CPYTOIMPF was used to created a text file and ftpd.The problem is that the | symbol is read as ! in another system.Wat could be the reason
I have used pipe symbol | as the delimiter to seperate fields.I used this in a DS and moved it to a flat file.From the flat file CPYTOIMPF was used to created a text file and ftpd.The problem is that the | symbol is read as ! in another system.Wat could be the reason
840 pts.
CPYTOIMPF and EXCEL defaults
I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...
I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...
cl
DCL &TEXTFILENM *CHAR 40 dcl &curdt *char 6 dcl &curtm *char 6 /* build your CL file name as */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&CURDT) RTVSYSVAL SYSVAL(QTime) RTNVAR(&CURTM) ChgVar &TextFileNm (QDATE *TCAT QTIME *TCAT ‘.TXT’ CPYTOIMPF … To stream file . . . . . . . . . TOSTMF &TextFileNm ...
DCL &TEXTFILENM *CHAR 40 dcl &curdt *char 6 dcl &curtm *char 6 /* build your CL file name as */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&CURDT) RTVSYSVAL SYSVAL(QTime) RTNVAR(&CURTM) ChgVar &TextFileNm (QDATE *TCAT QTIME *TCAT ‘.TXT’ CPYTOIMPF … To stream file . . . . . . . . . TOSTMF &TextFileNm ...
Error code 10: Function sequence error using CPYTOIMPF on AS/400
I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. ...
I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. ...
CPYTOIMPF - SQL ERROR
I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...
I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...
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.
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.
Copying an externally-described file to the IFS
Hello, I need to copy several externally-described files to the IFS. What is the best way to copy an externally-described file on the iseries to the IFS on the same iseries? I am wanting the file on the IFS to be in either EBCDIC, ASCII, BINARY, or Comma Separated Variable format. I thought...
Hello, I need to copy several externally-described files to the IFS. What is the best way to copy an externally-described file on the iseries to the IFS on the same iseries? I am wanting the file on the IFS to be in either EBCDIC, ASCII, BINARY, or Comma Separated Variable format. I thought...
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.
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.
CPYTOIMPF performance problem
Since moving from V5R4M0 to V6R1M0 our program that copies from a PF to an import file on the IFS using the CPYTOIMPF command has had major performance issues. What used to take 30 minutes to copy now takes as much as 24 hours.
Since moving from V5R4M0 to V6R1M0 our program that copies from a PF to an import file on the IFS using the CPYTOIMPF command has had major performance issues. What used to take 30 minutes to copy now takes as much as 24 hours.
last field needs a terminator character
adding FLDDLM character between fields but I need terminator at end of last field, how can I do It ??
adding FLDDLM character between fields but I need terminator at end of last field, how can I do It ??
CPYTOIMPF 'To File' problem
The following command: ===> CPYTOIMPF FROMFILE(LTCLIB/WPELG01P) TOFILE(LTCLIB/WPELGCSV) MBROPT(*REPLACE) STRDLM(*NONE) produces error To-file WPELGCSV in LTCLIB not allowed. The explanation says the To file must be an externally defined PF, which it is. I need to remove the double quote...
The following command: ===> CPYTOIMPF FROMFILE(LTCLIB/WPELG01P) TOFILE(LTCLIB/WPELGCSV) MBROPT(*REPLACE) STRDLM(*NONE) produces error To-file WPELGCSV in LTCLIB not allowed. The explanation says the To file must be an externally defined PF, which it is. I need to remove the double quote...
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?
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?
CPYTOIMPF - Physical file to IFS, get imbedded blanks
I have a physical file with the following fields. (field - attribute - sample content) FILL01 - 1A - blank KEY - 8A - AAPCTINV LENGTH - 2S 0 - 60 TEXT - 60 A - 8028038 When looking at the file using DSPPFM, the info = AAPCTINV608028038 Note, it has 1 space at the begining Using the...
I have a physical file with the following fields. (field - attribute - sample content) FILL01 - 1A - blank KEY - 8A - AAPCTINV LENGTH - 2S 0 - 60 TEXT - 60 A - 8028038 When looking at the file using DSPPFM, the info = AAPCTINV608028038 Note, it has 1 space at the begining Using the...
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...
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...
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...
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...
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) + ...
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) + ...
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.ñññòð÷
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.ñññòð÷
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. ...
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. ...
