RUNSQLSTM and Excel

5 pts.
Tags:
Microsoft Excel
RUNSQLSTM
Can an Excel spreadsheet be created with the runsqlstm?

Answer Wiki

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

The RUNSQLSTM will execute SQL statements that are stored in a source member. There is no SQL statement that I am aware of the will select date and automatically put it in a format that Excel can use.

You could create a CL program that would do a RUNSQLSTM and then do a copy to get the data into a .csv file for Excel to use.

Discuss This Question: 2  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
  • philpl1jb

    If you are working on the AS/400 side of the world. 

    Then the copy would probably be CPYTOIMPF

    49,910 pointsBadges:
    report
  • TomLiotta

    No, RUNSQLSTM cannot create an Excel spreadsheet. However, it can create a file that Excel can read into a spreadsheet.

    By some creative manipulation of values, all data in a row can be concatenated with commas and quotes to create a single column. That column can be INSERTed into a single-column table that can be read by Excel as a .CSV.

    But it's far easier simply to run a CPYTOIMPF command instead.

    Tom

    125,585 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