Re: ACS and CL commands in SQL scripts

I don't believe you can imbed
CL: mycommand;
within a create procedure
Put your command into CALL QCMDEXC as per
https://www.ibm.com/support/pages/node/1136806

On Mon, Apr 29, 2024 at 12:06 PM Dave <dfx1@xxxxxxxxxxxxxx> wrote:

I had a CL command directly following a Fetch statement in the procedure :
fetch etc, ;
cl: DSPFD etc ;

The message highlights the cl in red and says the keyword isn't allowed.

-
* Subject*: RE: ACS and CL commands in SQL scripts
- *From*: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
- *Date*: Wed, 24 Apr 2024 11:37:56 +0200

------------------------------
Without seeing your SQL Script it is hard to recommend something!
1. How do you call your CL command? By using the QCMDEXC stored

procedure?

2. Did you check the naming convention you use? May be before you used
System Naming, where the library list is searched and Library and Object
can
be separated by a / and now you are using SQL naming conventions (where
only
a current schema is searched for unqualified specified files and a path

for

sql routines and Library and Object must be separated by a period.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.