cpytoimpf

[mlcoolj]

Hi guys,

I wanto to export a PF to Excel as comma delimited, but I want to headers of the PF exported also. How do I do this? I'm using the command cpytoimpf to copy the PF into a flat file as comma delimited. Any help on how to get the headers of the PF also exported?

[jamief]

Re: cpytoimpf

there is no really simple way to do this with CL.

Guess you could use QSHELL write the ifs file first with the headings
then use cpytoimpf making sure that you are adding not replacing

Replace or add records . . . . . MBROPT         *ADD

or you could use rpg and write directly to the IFS.
Replace or add records . . . . . MBROPT *ADD

http://www.code400.com/forum/showthread.php?t=990

[rckass]

Re: cpytoimpf

You might copy the PF to another PF writing out the header constants as the first record. I have an account that has folks unable or unwilling to learn Excel and I generate csv files with headers, spacing records and total records...

[Mercury]

Re: cpytoimpf

Any help on how to get the headers of the PF also exported?

Convert the data into XML would be my option with the Guiseppe Perotti's tool named DB2XTOOL. This tool gives you a simple command that you can insert into your CL to convert your data w/ headers to the IFS as xml.
You can find this tool free to d/l however after registration here.

[littlepd]

Re: cpytoimpf

Use VBA and OLE DB from within the Excel spreadsheet to connect to the server and execute a "Select" SQL statement to retrieve the data. Here's an example.

[GLS400]

Re: cpytoimpf

Hey Littlepd:

Nice.....Very Very Nice....

I put that little baby to work already

Thanks
GLS

[jamief]

Re: cpytoimpf

yes very nice...If I could bake I'd send you a cake

jamie

[littlepd]

Re: cpytoimpf

Thanks! Just bump my Rep Power and we'll call it even!

[GLS400]

Re: cpytoimpf

Already done...

GLS

[littlepd]

Re: cpytoimpf

Thanks!

(Just between you and me, I'm shootin' for the highest Rep-to-Posts ratio! but don't tell anybody!)

[ReachKrishna]

Re: cpytoimpf

Hi guys,

I wanto to export a PF to Excel as comma delimited, but I want to headers of the PF exported also. How do I do this? I'm using the command cpytoimpf to copy the PF into a flat file as comma delimited. Any help on how to get the headers of the PF also exported?

I usually call an RPG program from my CL to write the header and then i do the CPYTOIMPF. Do not if its efficient but it surely is simple and it works.

[arrow483]

Re: cpytoimpf

A program we found easy to use is CVTPFXLS. It has options to include headings, text, etc. Available at <http://www.geocities.com/SiliconValley/Pines/5581/tips.htm>

[Pete]

Re: cpytoimpf

We have used CRTCSVF from: http://homepage1.nifty.com/uzaemon/

Good stuff there.

Pete

[itp]

Re: cpytoimpf

...here is example of using RPG and XML to generate Excel files:

http://tinyurl.com/q7v9h