× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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=


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.