Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
www.cozTools.com/qryfile
Chicagoland
RUNSQLSTM TGTRLS(VxRyMz) Always Fails
has no ratings.
Published: 27 Feb 2013
Revised: 01 Mar 2013 - 4065 days ago
Last viewed on: 17 Apr 2024 (5746 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

RUNSQLSTM TGTRLS(VxRyMz) Always Fails Published by: Bob Cozzi on 27 Feb 2013 view comments(2)

Using RUNSQLSTM to create a UDF works great.

However, I wanted to port it to one of the V5R4M0 systems we have.

So I issued: RUNSQLSTM CVTDATE TGTRLS(V5R4M0)

It failed with classic amateur CL programming errors. Meaning who ever wrote the command was a bone head.

If I specify TGTRLS(V7R1M0) or TGTRLS(*CURRENT) it works, but anything else, fails.

There is a PTF to fix this issue, but we have that installed and still get that failure.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: Paulster
Premium member *
Sweden and The Netherlands
Comment on: RUNSQLSTM TGTRLS(VxRyMz) Always Fails
Posted: 11 years 1 months 18 days 16 hours 10 minutes ago

Lucky enough to have same versions on all boxes out here so I cannot test it for you. Looks like you'll have to check with the bone-head.   :o)

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: RUNSQLSTM TGTRLS(VxRyMz) Always Fails
Posted: 11 years 1 months 17 days 14 hours 39 minutes ago
Edited: Fri, 01 Mar, 2013 at 15:41:45 (4065 days ago)

Seem to have solved the issue. 

If I add the following to the SQL source:

SET OPTION  TGTRLS = V5R4M0

it compiles correctly.