Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
RUNSQLSTM TGTRLS(VxRyMz) Always Fails
has no ratings.
Published: 27 Feb 2013
Revised: 01 Mar 2013 - 1942 days ago
Last viewed on: 25 Jun 2018 (4032 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