Re: CRTSQLRPGI parameter

Thanks for your input. I did a little detective work and found that if the
source file has a record length > 112, then the TOSRCFILE will be named
QSQLTxxxxx, (e.g. QSQLT00113 if the source record length is 113). Otherwise
TOSRCFILE retains the name of QSQLTEMP1. Interesting!

On 11 August 2016 at 19:01, CRPence <crpbottle@xxxxxxxxx> wrote:

On 11-Aug-2016 11:52 -0500, Brian Parkins wrote:

Just noticed the following change to the CRTSQLRPGI command at V7.1
The TOSRCFILE parameter defaults have been modified,

from: TOSRCFILE(QTEMP/QSQLTEMP1)

to: TOSRCFILE(QTEMP/*CALC)

Can anyone explain what *CALC means? The Help is - errr - no help at
all. I've checked the IBM Knowledge Centre and no help there either.

That there is consistency is actually a good sign :-) The source for
both is supposed to be derived from the same location.

I_did_ find a mention of what *CALC means for CRTSQLCI,

*CALC
The output source file name will be generated based on the
margins of the source file. The name will be QSQLTxxxxx,
where xxxxx is the width of the source file. If the source
file record length is less than or equal to 92, the name
will be QSQLTEMP.

I get the "gist" - but does this also apply to CRTSQLRPGI as well?

Seems for lack of the addition of a Source Margins (MARGINS) parameter
to that Create SQL ILE RPG Object (CRTSQLRPGI) command, that their change
to enable the new special-value of *CALC was premature; and reflected in
their failure to update the help text with the new special-value.

The effect for Enter pressed followed by F12=Cancel on each of those for
which 1=Select gets processed from the following command-line request to
SLTCMD CRTSQL* is revealing in that regard:

Select Command

Type options, press Enter.
1=Select

Opt Command Library Text
_ CRTSQLCBL QSYS Create SQL COBOL Program
_ CRTSQLCBLI QSYS Create SQL ILE COBOL Object
1 CRTSQLCI QSYS Create SQL ILE C object
1 CRTSQLCPPI QSYS Create SQL ILE C++ Object
_ CRTSQLPKG QSYS Create SQL Package
_ CRTSQLPLI QSYS Create SQL PL/I Program
_ CRTSQLRPG QSYS Create SQL RPG Program
1 CRTSQLRPGI QSYS Create SQL ILE RPG Object


Parameters or command
===> ??tosrcfile(*calc) ??margins(*n 112) obj(qtemp/"junk")


On the third prompted command, the CRTSQLRPGI, the error is msg CPD0043
"Keyword MARGINS not valid for this command."; and there is of course the
lack of an error msg CPD0078 "Value '*CALC ' for parameter TOSRCFILE
not a valid name." as would be seen if 1=Select with the same command-line
parameter specifications were performed for the CRTSQLCBLI.

I would presume and expect that, for the lack of any MARGINS capability,
the effect will remain unchanged from that of past releases, for the new
default of *CALC; meaning, the qualified name QTEMP/QSQLTEMP1, or the
customized\changed default. And if any version of the command is made
available with the MARGINS support, then anyone taking advantage, will
probably /learn/ the effect is similar to what is documented on those other
two commands; supposing, QSQLTEMP1 vs QSQLTEMP being the only difference in
the help text.?

--
Regards, Chuck

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.