Home > IT Answers > AS/400 > Download from iSeries directly to an Excel xls file – no CSV
Sillyhp
35 pts.
 Download from iSeries directly to an Excel xls file – no CSV
CL Program, iSeries, iSeries programming commands, Microsoft Excel, XLS
I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

Software/Hardware used:
iSeries, Microsoft Excel
ASKED: May 19, 2010  11:56 AM
UPDATED: May 20, 2010  11:05 AM
RELATED QUESTIONS
Answer Wiki:
The error you have indicates that the program can not find one or more of the parms you entered into the command. Are you sure that the lib/file PJCLIB/AGE exist? Also, make sure that the stream file path 'Root/EF/StkSts/' exist. Just a thought, you may want to try putting a slash in front of Root. The path would now look like this: ’/Root/EF/StkSts/Age.xls’
Last Wiki Answer Submitted:  May 19, 2010  7:12 pm  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

CL is hardly an appropriate language for trying to put data into a format that is proprietary to an application that runs on a different platform under a different operating system. It can be done, and there are tools that can help such as CVTPFXLS.

If you’re going to use such tools and you have a problem, please show us the problem. Show the code that fails and show the message. Maybe we can help. Please also provide basic information such as i5/OS version/release.

Tom

TomLiotta
 108,205 pts.
 

Using V5R4M0 of operating system.

CL Command = CVTPFXLS FROMFILE(PJCLIB/AGE) TOSTMF(‘Root/EF/StkSts/Age.xls’) FLDHDR(*TEXT)

Get message: Pointer not set for location referenced.

Sillyhp
 35 pts.
 

It took a couple of days, but I figured it out!

Sillyhp
 35 pts.
 

I can point out a couple potential problems; but if you explained how you resolved it, those who come here later might be grateful for your help.

Tom

TomLiotta
 108,205 pts.
 

My path was using /Root in the IFS, but I needed only to begin with the actual folder /EF which is directly under Root. It’s funny how the simplest things are overlooked. I should also mention that the website to get the CVTPFXLS has moved from geocities to the following:

http://reocities.com/SiliconValley/pines/5581/tips.htm

It took me a couple of days to find it, but worth the trouble. They have a lot of good stuff on their site.

Sillyhp
 35 pts.