Re: System name via SQL -- MIDRANGE-L

× 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.

Be Nice, i'm just starting to understand what SQL can do.

not optimum as it requires a CL service program

<clle>
PGM parm(&i )
DCL VAR(&i) TYPE(*char) LEN(8)
RTVNETA SYSNAME(&i)
ENDPGM

"CRTCLMOD" then "CRTSRVPGM export(*ALL)"

<sql>
Create or replace Function
getsysname()
Returns character(8)
Language CL
Specific getsysname
Deterministic
No SQL
Returns Null on Null Input
No External Action
Not Fenced
External Name 'QGPL/GETSYSNAME(GETSYSNAME)'
Parameter Style SQL;

<finially>
values qgpl.getsysname() ;

would love to use RTVNETA right in the SQL.

Steve Pitcher wrote on 8/2/2018 8:28 PM:

Developer gurus: a challenge! How would you get the system name of a partition via an SQL statement? Not the host name or domain name. The system name from DSPNETA.

Steven Pitcher
IBM i and Power Systems Expert

iTech Solutions Group<https://www.itechsol.com/>
39 Parkview Drive, New Glasgow, NS B2H0E6
Mobile: (902) 301-0810
Email: spitcher@xxxxxxxxxxxx<mailto:spitcher@xxxxxxxxxxxx>
[ibm-champion-rgb-175px (1)]

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.