RFE FOR QSYS2.GENERATE_SQL to generate the system name for SQL global variable -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: RFE FOR QSYS2.GENERATE_SQL to generate the system name for SQL global variable
From: Arco Simonse <arco400@xxxxxxxxx>
Date: Tue, 26 Jun 2018 14:33:42 +0200
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Hi,

IBM answered that generating the SYSTEM NAME is currently only
supported for indexes, tables and views. Not for global variables.

So I opened an RFE to ask for this functionality.

http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=121739

Please vote if you see the usability of this.

Thanks,
-Arco

2018-06-25 19:38 GMT+02:00 Arco Simonse <arco400@xxxxxxxxx>:

We do have that one applied a week ago.
I'll open a PMR.

Thanks,
-Arco

2018-06-25 19:03 GMT+02:00 Rob Berendt <rob@xxxxxxxxx>:

Then, yes, I would open a ticket.

Far as I can tell this is the latest generate_sql ptf
http://www-01.ibm.com/support/docview.wss?uid=nas3SI67374
It may not be directly related but maybe one of the ones is superseded is.

It's not on a cume:
Cum Level........NONE
It is on SF99703 730 DB2 for IBM i - level 10.

This mailing list archive is Copyright 1997-2026 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.