Error when using CPYTOIMPF command

[pintusrm2010]

Hi all,

I am trying to move one logical file data int flat file using command CPYTOIMPF but i am getting error.

Any idea why this error is coming? I attached the error screen shot. Also whats the alternate way of downloading the data.

Regards,

Pintu

[pintusrm2010]

Re: Error when using CPYTOIMPF command


By error msg it says from file is incorrect but from file is logical file only and i can see the data using runqry command

[DAG0000]

Re: Error when using CPYTOIMPF command

You have to run that command over the physical file.

[tomliotta]

Re: Error when using CPYTOIMPF command

CPYTOIMPF can run over LFs, but there are restrictions. It might be necessary to see DSPFD or the DDS for the LF to figure out why this LF is a problem.

[pintusrm2010]

Re: Error when using CPYTOIMPF command

CPYTOIMPF can run over LFs, but there are restrictions. It might be necessary to see DSPFD or the DDS for the LF to figure out why this LF is a problem.

What kind of problem as per you? I checked and found that this logical file had 2 different record format as it was based on two different physical file.!!

[tomliotta]

Re: Error when using CPYTOIMPF command

...this logical file had 2 different record format as it was based on two different physical file.!!

In that case, it's not valid for CPYTOIMPF. You can't "import" (CPYFRMIMPF) or "export" (CPYTOIMPF) files with multiple record formats, even if the formats match.

You might try CPYF to create a temporary PF with the data you want. Then use CPYTOIMPF to export that temporary file.

That's essentially what the CPF2801 error message that you showed us says needs to be done.

[pintusrm2010]

Re: Error when using CPYTOIMPF command

Hi ,

Even i cant able to download using CPYF command.

Getting error like "RCDFMT(*ALL) not valid for file IMHIST02 in library AMFLIB. "

and if i am specifying a particular record format then data only related to one physical file is getting downloaded.

ANy idea what need to be done in order to download the logical file data which is based on multiple physical file. ??

In that case, it's not valid for CPYTOIMPF. You can't "import" (CPYFRMIMPF) or "export" (CPYTOIMPF) files with multiple record formats, even if the formats match.

You might try CPYF to create a temporary PF with the data you want. Then use CPYTOIMPF to export that temporary file.

That's essentially what the CPF2801 error message that you showed us says needs to be done.

[tomliotta]

Re: Error when using CPYTOIMPF command

That's right. You need to copy the physical files, not the invalid LF. If you want all PFs copied into the same "export" file, you can possibly use the CPYTOIMPF MBROPT(*ADD) option.

[pintusrm2010]

Re: Error when using CPYTOIMPF command

One more query... If a LF has two record format say A and B . A record format for PF A1 and B record format for B1 . There is no select and omit condition in LF. so if we run sql command on LF then this LF will show totat record as sum of record present in A1 and B1? So in case A1 has 50 record and B1 has 100 reocord ,so LF will show total 150 records?

Also any other idea how we can download multi record format LF?

That's right. You need to copy the physical files, not the invalid LF. If you want all PFs copied into the same "export" file, you can possibly use the CPYTOIMPF MBROPT(*ADD) option.

[tomliotta]

Re: Error when using CPYTOIMPF command

One more query... If a LF has two record format say A and B . A record format for PF A1 and B record format for B1 . There is no select and omit condition in LF. so if we run sql command on LF then this LF will show totat record as sum of record present in A1 and B1? So in case A1 has 50 record and B1 has 100 reocord ,so LF will show total 150 records?

It shouldn't. It should throw message SQL7003 "File ... has more than one format." The LF 'S'elect/'O'mit isn't relevant. The relevant part is that the LF file description lists two record formats.

Also any other idea how we can download multi record format LF?

Sure. Write programs to have the download work any way you choose with any file you want. It's not necessary to use system tools.

[pintusrm2010]

Re: Error when using CPYTOIMPF command

It shouldn't. It should throw message SQL7003 "File ... has more than one format." The LF 'S'elect/'O'mit isn't relevant. The relevant part is that the LF file description lists two record formats.



Sure. Write programs to have the download work any way you choose with any file you want. It's not necessary to use system tools.

One more query. I am not able to download one PF. I am getting error as "Column PBD52 contains replacement character +"

When i saw that column i saw data like :

PBD52
++++++++++
++++++++++
++++++++++
++++++++++
++++++++++
++++++++++
++++++++++
++++++++++
++++++++++


Any idea what it means and how to download this data.

[tomliotta]

Re: Error when using CPYTOIMPF command

Any idea what it means and how to download this data.

It essentially means that the value in the column is invalid for whatever you're trying to do. Some part of the process is unable to prepare the data to show it to you.

When you see it, what are you doing? Is that shown through a green-screen or on a PC? What tool are you using to "download"? What is the definition of the PBD52 column?

[pintusrm2010]

Re: Error when using CPYTOIMPF command

It essentially means that the value in the column is invalid for whatever you're trying to do. Some part of the process is unable to prepare the data to show it to you.

When you see it, what are you doing? Is that shown through a green-screen or on a PC? What tool are you using to "download"? What is the definition of the PBD52 column?

It is showing on green screen itself. I am moving the data in IFS folder in .csv format using CPYTOIMPF command but this file is not getting downloaded. This field contain finance related data like price.

[tomliotta]

Re: Error when using CPYTOIMPF command

And what is the definition of the PBD52 column?

[pintusrm2010]

Re: Error when using CPYTOIMPF command

And what is the definition of the PBD52 column?

Hi .. Please find the definition.




Is it suffice?

Regards,

Pintu