SQL PL any SCA options?

Mayuresh Kathe

SQL PL any SCA options?

Oracle DBAs use TOAD: https://en.wikipedia.org/wiki/Toad_(software)

SQL Server DBAs use Visual Expert: https://en.wikipedia.org/wiki/Visual_Expert

Is there any built-in option in Db2 LUW to analyze SQL PL?

Bruce Williamson

RE: SQL PL any SCA options?
(in response to Mayuresh Kathe)

There sure is, it's called Data Studio

Cheers
Bruce

 


In Reply to Mayuresh Kathe:

Oracle DBAs use TOAD: https://en.wikipedia.org/wiki/Toad_(software)

SQL Server DBAs use Visual Expert: https://en.wikipedia.org/wiki/Visual_Expert

Is there any built-in option in Db2 LUW to analyze SQL PL?



P.S. Want to make a difference to DB2 but don't know how? Join the RFE Community?

P.P.S. While you're at it why not join the "All DB2 for z/OS" group and vote on community proposals

David Simpson

SQL PL any SCA options? [EXTERNAL]
(in response to Bruce Williamson)
You will need a free IDUG sign in but here’s an old(ish) article to get started.

https://www.idug.org/p/do/sd/sid=6416&isnew=1&type=0


From: Bruce Williamson [mailto:[login to unmask email]
Sent: Wednesday, May 13, 2020 12:05 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: SQL PL any SCA options? [EXTERNAL]


There sure is, it's called Data Studio

Cheers
Bruce



In Reply to Mayuresh Kathe:

Oracle DBAs use TOAD: https://en.wikipedia.org/wiki/Toad_(software) https://urldefense.proofpoint.com/v2/url?u=https-3A__en.wikipedia.org_wiki_Toad-5F-28software-29&d=DwMFaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=Y8--9p3KtP3W_WOLKmDxCze2yS3CfiZWXpb2oRAlREQ&m=2Atya3gEnb2AST3pwIz66sYG3zj4QVDe3ywzTWwl1KA&s=KHQm1OLd2sr5Oe5ABMEu2OjuFYqhgqq53kpNhJ8PcDM&e=

SQL Server DBAs use Visual Expert: https://en.wikipedia.org/wiki/Visual_Expert https://urldefense.proofpoint.com/v2/url?u=https-3A__en.wikipedia.org_wiki_Visual-5FExpert&d=DwMFaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=Y8--9p3KtP3W_WOLKmDxCze2yS3CfiZWXpb2oRAlREQ&m=2Atya3gEnb2AST3pwIz66sYG3zj4QVDe3ywzTWwl1KA&s=W4k3cBG2y30uxWe0OxCGofYgUuiPmFVdcsdoEZCnfR8&e=

Is there any built-in option in Db2 LUW to analyze SQL PL?



P.S. Want to make a difference to DB2 but don't know how? Join the RFE Community https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe&d=DwMFaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=Y8--9p3KtP3W_WOLKmDxCze2yS3CfiZWXpb2oRAlREQ&m=2Atya3gEnb2AST3pwIz66sYG3zj4QVDe3ywzTWwl1KA&s=y4vEbqCRyfS66vp9maEMtwBXSqaMd9KbutK3iOKnT5c&e= ?

P.P.S. While you're at it why not join the "All DB2 for z/OS" https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DgroupLanding-26GROUP-5FID-3D1283&d=DwMFaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=Y8--9p3KtP3W_WOLKmDxCze2yS3CfiZWXpb2oRAlREQ&m=2Atya3gEnb2AST3pwIz66sYG3zj4QVDe3ywzTWwl1KA&s=TyXZlmU5P55ug4cfc5gtLhLFZMvVPj5EnKztFMEDYmQ&e= group and vote on community proposals

-----End Original Message-----
________________________________
Please note: This message originated outside your organization. Please use caution when opening links or attachments.

Bruce Williamson

RE: SQL PL any SCA options?
(in response to David Simpson)

It might be time to publish it on https://en.wikipedia.org/wiki David :-)

Cheers
Bruce


In Reply to David Simpson:

You will need a free IDUG sign in but here’s an old(ish) article to get started.

https://www.idug.org/p/do/sd/sid=6416&isnew=1&type=0


From: Bruce Williamson [mailto:[login to unmask email]
Sent: Wednesday, May 13, 2020 12:05 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: SQL PL any SCA options? [EXTERNAL]


There sure is, it's called Data Studio

Cheers
Bruce



In Reply to Mayuresh Kathe:

Oracle DBAs use TOAD: https://en.wikipedia.org/wiki/Toad_(software) https://urldefense.proofpoint.com/v2/url?u=https-3A__en.wikipedia.org_wiki_Toad-5F-28software-29&d=DwMFaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=Y8--9p3KtP3W_WOLKmDxCze2yS3CfiZWXpb2oRAlREQ&m=2Atya3gEnb2AST3pwIz66sYG3zj4QVDe3ywzTWwl1KA&s=KHQm1OLd2sr5Oe5ABMEu2OjuFYqhgqq53kpNhJ8PcDM&e=

SQL Server DBAs use Visual Expert: https://en.wikipedia.org/wiki/Visual_Expert https://urldefense.proofpoint.com/v2/url?u=https-3A__en.wikipedia.org_wiki_Visual-5FExpert&d=DwMFaQ&c=9g4MJkl2VjLjS6R4ei18BA&r=Y8--9p3KtP3W_WOLKmDxCze2yS3CfiZWXpb2oRAlREQ&m=2Atya3gEnb2AST3pwIz66sYG3zj4QVDe3ywzTWwl1KA&s=W4k3cBG2y30uxWe0OxCGofYgUuiPmFVdcsdoEZCnfR8&e=

Is there any built-in option in Db2 LUW to analyze SQL PL?

-----End Original Message-----
________________________________