sql what is TOSTMF

15 pts.
Tags:
IBM iSeries
SQL
TOSTMF
In SQL what is TOSTMF for an output file, and how do I use it?

Software/Hardware used:
i Series

Answer Wiki

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

TOSTMF would be used to output to the IFS.

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
    As near as I can tell, TOSTMF is unrelated to SQL. Where are you seeing it? Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Perhaps this is iexcel -- as Charlie Brown said this parameter represents the path including file name on the i-series IFS.
    51,355 pointsBadges:
    report
  • CharlieBrowne
    MY guess is you may have a home grown SQL command that converts the output to the IFS
    41,380 pointsBadges:
    report
  • TomLiotta
    My first guesses would be either CPYTOSTMF or CPYTOIMPF. However, a 'home grown' or 3rd-party SQL-based function is reasonable. Perhaps a downloaded utility like SQL2STMF. CharlieBrowne's answer was on the mark, so no need to modify it. But there might be oddities that discussion could uncover. I've seen a couple issues in recent years. Someone who wouldn't know the meaning of "TOSTMF" might not know "IFS" either. But discussion with OPs seems kind of rare here. Tom
    125,585 pointsBadges:
    report
  • GlendaBennett
    Thanks everyone. What I didn't know was I was using an EXECUTE command that is part of ESend Software. TOSTMF is Copy to Stream File and is part of the Execute command. This is my CL that is working now: EXECUTE SQL('SELECT * from gbennett/ivpc1639 ') + PCFMT(*XLS) + RECIPIENT(GBENNETT@BAKERDIST.COM) + MSG(*NO) TEXT('GBTEST ')
    15 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