That helped. I put a new CHAR(10) parameter onto the RUNSQLSCR command named PGM and (in RDi) I pass the &FNR replacement value for IFS stream files, and it displays the error list when compiled interactively. If I compile a sql source member instead, without passing anything into the PGM parameter then that still works.
I couldn't get the &FNR variable to work when I added PGM(&FNR) as a comment to the end of the compile command, but I am satisfied that just adding the PGM parameter to the command itself allows it to work without having to shift everything to "compile in batch".
Thanks Eric.
I would think the docs should be nice and up to date, but don't sacrifice a nice new feature just to update docs!
-Paul.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Eric Simpson
Sent: 21 April 2016 14:08
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Custom compile from IFS
Paul,
For IFS non-batch commands, it will look for PGM or MODULE parameters in the command string to determine the name of the generated events file.
These can even be in comments on the command string if your actual command does not have them.
I can open an internal defect to have our docs updated but if you want to ensure the docs are updated, you can open a PMR to have a doc APAR created.
http://www.ibm.com/support/knowledgecenter/SSAE4W_9.5.0/com.ibm.etools.iseries.rse.doc/topics/tworkcmplcmds.html?lang=en
Thanks,
Eric
Eric Simpson
Rational Developer for i - Rational Developer for
AIX and Linux - Rational Developer for Power
IBM Software Group - Canada Lab
Phone: 905-413-3226 (T/L: 313-3226)
esimpson@xxxxxxxxxx
From: Paul Bailey <PaulBailey@xxxxxxxxxx>
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Date: 04/21/2016 08:45 AM
Subject: Re: [WDSCI-L] Custom compile from IFS
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>
Hi Eric,
For source members, the following command is used:
RUNSQLSCR SRCFILE(&L/&F) SRCMBR(&N) SCHEMA(*NONE) OPTION(*EVENTF)
And for IFS source files, the following command is used:
RUNSQLSCR SRCSTMF('&FCP/&N') SCHEMA(*NONE) EVENTFL(*SCHEMA) OPTION
(*EVENTF)
I always compile interactively, but (just for a laugh) I switched the default to compile in batch, and compiling the IFS source file with my command above *did* display the error list from the EVENTF file. Very interesting!
Compiling source members with my RUNSQLSCR command displays the error list both interactively and in batch. Compiling IFS source files with my RUNSQLSCR command displays the error list only when compiled in batch.
Should I create a PMR for this? Or an RFE instead? I can't imagine either would get results as it is just my tool that is suffering.
Can I cause only some compiles to run in batch instead of interactively?
Can anyone think of good reasons to always compile in batch instead of interactively?
-Paul.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Eric Simpson
Sent: 21 April 2016 11:54
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Custom compile from IFS
Paul,
Can you give an example of the actual command string that is issued? Does it have a SRCSTMF parameter?
Have you tried this submitted as batch and as normal? (event file processing is slightly different between the two)
Thanks,
Eric
Eric Simpson
Rational Developer for i - Rational Developer for AIX and Linux - Rational Developer for Power IBM Software Group - Canada Lab
Phone: 905-413-3226 (T/L: 313-3226)
esimpson@xxxxxxxxxx
From: Paul Bailey <PaulBailey@xxxxxxxxxx>
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Date: 04/21/2016 05:08 AM
Subject: Re: [WDSCI-L] Custom compile from IFS
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>
Thanks Thomas.
That is the link I used to create the EVFEVENT file as well, and that part of my tool for both source members and stream files works well. And the LDA is setup when the process finishes as the article describes. I think RDi might have a problem if the original source was an IFS source file instead of from a source member, but I am just guessing.
Your STRPREPRC tool has interested me in the past, but the problem I have with it is I need to add the instructions in comments at the top of source, and I cannot guarantee that those instructions will be maintained by my colleagues when needed. I wrote my tool purely to replace the RUNSQLSTM user actions that everybody has had to setup in their RDi sessions with a compile command.
-Paul.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Thomas Raddatz
Sent: 21 April 2016 09:33
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Custom compile from IFS
Paul,
The following article helped me to solve that problem for my STRPREPRC
command:
"Create Your Own Compile Commands in WDSC"
http://www.itjungle.com/fhg/fhg080404-story01.html
I basically added parameters SRCFILE(...) and OPTION(*EVENTF) and I updated the first 20 bytes (LIBRARY, OBJECT) of the *LDA with the name of the object that was created by STRPREPRC command. I assume that you need to update the local data area with the name of the library of the source file and the source member name.
Feel free to check module STRPREPRC4 for details. The STRPREPRC command is included in the iSphere library or you can download it from my Freeware page at
http://tools400.de/English/Freeware/Utilities/utilities.html.
Thomas.
-----Ursprüngliche Nachricht-----
Von: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im Auftrag von Paul Bailey
Gesendet: Mittwoch, 20. April 2016 17:21
An: wdsci-l
Betreff: [WDSCI-L] Custom compile from IFS
Hi,
I wrote a program to help me "compile" SQL scripts in RDi. It is just a wrapper around the RUNSQLSTM command, and it parses the output from the RUNSQLSTM command to produce an EVENTF file for RDi to display in the error list view. It works perfectly for SQL scripts stored in source members.
I've been trying to get it to work from the IFS as well. RUNSQLSTM works happily using a stream file, producing near identical output. However, RDi is not displaying the error log window at all even though I am 100% certain that the EVENTF member is correct and in the right place (noted by positions 1-20 of the *LDA).
Does anyone have any idea why RDi is able to show the error log for source members but not IFS stream source files? I do have an OPTION(*EVENTF) in the command for both source members and stream files, and in both cases the right EVENTF member exists after the "compile".
-Paul.
---------------------------------------------------------------------------------------
Important This email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way.
If you have received this email in error, please notify the sender and delete the email from your system. We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Group Limited or its subsidiary companies by email.
Registered Office: BHSF Group Limited, Gamgee House, 2 Darnley Road, Birmingham B16 8TE. Registered in England number 04767689. BHSF is authorised and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
This email has been scanned for email related threats and delivered safely by Mimecast. For more information please visit
https://www.mimecast.com
---------------------------------------------------------------------------------------
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
IMPORTANT NOTICE:
This email is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and email confirmation to the sender.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
---------------------------------------------------------------------------------------
Important This email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way.
If you have received this email in error, please notify the sender and delete the email from your system. We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Group Limited or its subsidiary companies by email.
Registered Office: BHSF Group Limited, Gamgee House, 2 Darnley Road, Birmingham B16 8TE. Registered in England number 04767689. BHSF is authorised and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
This email has been scanned for email related threats and delivered safely by Mimecast. For more information please visit
https://www.mimecast.com
---------------------------------------------------------------------------------------
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
---------------------------------------------------------------------------------------
Important This email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way.
If you have received this email in error, please notify the sender and delete the email from your system. We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Group Limited or its subsidiary companies by email.
Registered Office: BHSF Group Limited, Gamgee House, 2 Darnley Road, Birmingham B16 8TE. Registered in England number 04767689. BHSF is authorised and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
This email has been scanned for email related threats and delivered safely by Mimecast. For more information please visit
https://www.mimecast.com
---------------------------------------------------------------------------------------
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
---------------------------------------------------------------------------------------
Important This email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way.
If you have received this email in error, please notify the sender and delete the email from your system. We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Group Limited or its subsidiary companies by email.
Registered Office: BHSF Group Limited, Gamgee House, 2 Darnley Road, Birmingham B16 8TE. Registered in England number 04767689. BHSF is authorised and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
This email has been scanned for email related threats and delivered safely by Mimecast. For more information please visit
https://www.mimecast.com
---------------------------------------------------------------------------------------
midrange.com
