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 - 3927 days ago
Last viewed on: 30 Nov 2023 (5627 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: 10 years 9 months 2 days 21 hours 18 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: 10 years 9 months 1 days 19 hours 47 minutes ago
Edited: Fri, 01 Mar, 2013 at 15:41:45 (3927 days ago)

Seem to have solved the issue. 

If I add the following to the SQL source:

SET OPTION  TGTRLS = V5R4M0

it compiles correctly.