Download from iSeries directly to an Excel xls file – no CSV

35 pts.
Tags:
CL Program
IBM iSeries
iSeries 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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’

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Sillyhp
    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.
    35 pointsBadges:
    report
  • Sillyhp
    It took a couple of days, but I figured it out!
    35 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Sillyhp
    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.
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following