The outline is a major timesaver - especially when dealing with someone else's code - and adding the missing SQL details would make it even better. However, in DB2 you can also have system names for fields, record formats and files in addition to the normal SQL names, and in any SQL you can reference the same file more than once in the same query and have sub-queries and common table expressions all in the same single statement, so I imagine cross-referencing all that information isn't going to be an easy step. Glad I don't have to do it!
- Paul.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
Sent: 14 January 2016 20:39
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] RDi 9.5.0.2 SQL in outline view, does not exist...
On 1/14/2016 2:11 PM, paultherrien wrote:
I know I don't truly understand, but can you not scan the source code
for your file name?
I started in Ye Olde Dayes, and many years ago developed the habit to search or filter when looking for a file name. I never really adapted to the Outline View. This is a bit of almost-real code, and a perfect example of why a search is not optimal:
* Get county
county chain rcounty
* county not found
if not %found(county)
clear rcounty;
countynm = 'NOT FOUND';
Now since this witty block of code uses file-specifications, Outline View picks up on it and I can easily pop along to just the I/O - CHAIN, SETLL, etc - without stumbling through the comments and fields.
If I re-wrote that a bit:
select countynm
into :countyname
from county
where...;
then the Outline View doesn't show the reference to the COUNTY table.
Which is sort of unhelpful, since the general push is toward SQL. So having a tool that meshes with our future would be a Good Thing.
I myself still avoid the Outline View because I find several places where it misses things vs the cross reference generated by the compiler.
Having said that, I personally consider the Outline View to be a work in progress, and the 9.5 version is much more comprehensive than in earlier versions. I voted for the RFE.
--
--buck
Visit wiki.midrange.com and register for an account. Edit a page that helps you, and because it's public, you'll help someone else, too!
--
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
