Is it really storing the SQL Script in the QTEMP?! I was under the
impression it is stored in the
Anyway
The easiest way is to do a reverse engineering after you have created the
stored procedure, i.e. just position on the database object right click and
GENERATE_SQL. Here you can specify where to store the SQL Script, i.e. you
can output it to a PC-file, an IFS file and even into a source physical file
member.
You also can call the GENERATE_SQL stored procedure directly.
... and the third way (my favorite) is generate the SQL Script (click on
SHOW SQL) out of the Wizard before you create the SQL Routine. Then run the
script ... and if it works correctly save it where ever you want.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"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)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Javier
Sanchez
Sent: Donnerstag, 3. Februar 2022 23:29
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: SQL SPROC source code destination other than QTEMP
Hello everyone,
Most of us always running huh? I would quickly like to get from you guys a
very simple answer:
If I use the ACS sql script panel to create the most simple SPROC, how do I
tell it that I want the intermediary SQL and also the "C" code source stored
in a specific source file at a specific library other than QTEMP?
Thanks in advance.
Javier Sanchez
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
