Re: QCMDEXE behavior modification -- RPG400-L

Sorry - of course - *server job* - you are absolutely right !

It happens to me all the time when i let QZDASOINIT job do the magick -
the server job used in SQL

And I was wondering why IBM is not able to do the trick under the covers to
return the spool name etc. so it is transparent for us as programmers so we
don't have to this about if the spool we created by a server job or just
directly - Maybe a candidate for a little RFE.

Have a nice weekend.

On Fri, Apr 24, 2020 at 3:13 PM Duane Scott <dscott@xxxxxxxxxxx> wrote:

Niels,

I don't think its because of using SQL... but I think wrong LOTS of times.

The link you suggest actually is the most logical cause, (not SQL) but a
Host Server Job.

And their solution is one way (or actually several suggestions as to how)
to get around the situation.

However, at this time I'm avoiding using APIs due to a long standing
dislike of programming using them. It's silly, but I use the excuse that
many of us long-time (aka - old) programmers use... "I did it once a long
time ago and didn't like it". I may get over that before I retire, or not.

I much prefer when someone does it for me and makes it easier.
Actually... that's not true. I do the difficult a lot... if I think it's
fun. Like this program. I did it to see if I could do what I thought was
a better job than what was available (without further cost). And it was
fun to do.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Niels
Liisberg
Sent: Friday, April 24, 2020 2:44 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: QCMDEXE behavior modification

It is because you are using SQL so the print is made from a server job.

Use the API in this link to retrieve the spool info

https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_pages_retrieving-2Dspooled-2Dfiles-2Dgenerated-2Dhost-2Dserver-2Djob&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=_Y9ilIeimM0IRMAn82SWySsbtQzAkn4B7EbK8_Ju2uI&e=

tor. 23. apr. 2020 kl. 17.35 skrev Duane Scott <dscott@xxxxxxxxxxx>:

I've made an assumption here based on observations, and I may be
incorrect (and most likely am), but I have no other explanation.
Hopefully, in as kind of a manner as is usually displayed in this
group, I can be corrected and put on the right path.

I've created an SQL based RPGLE program that I use to convert RPG IV
to RPG Free. In it, I utilize the SYSTEM() function to compile the
original source, copy the spooled file to a source file member, and
search for various information like c-spec created variables. The
problem is that when running the program using the RDI "user action",
the compile spool file job number is not the same as the job number of
the job that issued the "user action".

I don't know why, but it uses a job associated with my user id, but
not one of the current active jobs. Not sure what job that is and why
it uses it. Nor do I know how to discover what the spool file job

number is.

I believe that this is also an issue with other development
environments other that RDI, so I don't think it's an "RDI" problem,
but one associated with SYSTEM() and similar. I haven't tried QCMDEXE
to see if that is different. Maybe I should?

Any known answers?

Duane

CONFIDENTIALITY NOTICE: This electronic message transmission is
intended only for the person or entity to which it is addressed and
may contain information that is privileged, confidential or otherwise
protected from disclosure. If you have received this transmission, but
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or use of the contents of this
information is strictly prohibited. If you have received this e-mail
in error, please contact NALC Health Benefit Plan at 703-729-4677 and
delete and destroy the original message and all copies.

--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v
5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoT
mhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=ml--Hu9PzsOQx9qJTJ4KzR11HojuLp_
4V6hJXX9Kbzk&e= or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=Lov_hd8xDiUpf1s2JfAVPtj061JE5OlisiiHOY2U1Nw&e=
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support
https://urldefense.proofpoint.com/v2/url?u=http-3A__midrange.com&d=DwI
CAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEw
Oi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1b
s&s=j_jD_0hS_iAxT_WXVzrwpt915e9cch0Z8xEbrxs1LRg&e= by shopping at
https://urldefense.proofpoint.com/v2/url?u=http-3A__amazon.com&d=DwICA
g&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi
1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&
s=2_9tI0pHRn_TI1q-oSexuJYvnTGRS5eymw8EyGKwoJk&e= with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.c
om&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz
4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAn
UOBLYm1bs&s=yVyy4kFfyAdLdY_ClARZbnpQQOJG5b1WBIBAjWjATWU&e=

--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=ml--Hu9PzsOQx9qJTJ4KzR11HojuLp_4V6hJXX9Kbzk&e=
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=Lov_hd8xDiUpf1s2JfAVPtj061JE5OlisiiHOY2U1Nw&e=
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support
https://urldefense.proofpoint.com/v2/url?u=http-3A__midrange.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=j_jD_0hS_iAxT_WXVzrwpt915e9cch0Z8xEbrxs1LRg&e=
by shopping at
https://urldefense.proofpoint.com/v2/url?u=http-3A__amazon.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=2_9tI0pHRn_TI1q-oSexuJYvnTGRS5eymw8EyGKwoJk&e=
with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=LifWsbmXTz4aXbMMEwOi1aJ3sWD5nsP_QI4reJ8MbDM&m=MzV-IoTmhmkmh1AKErdEHleinU6IBP_GAnUOBLYm1bs&s=yVyy4kFfyAdLdY_ClARZbnpQQOJG5b1WBIBAjWjATWU&e=

--
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