Re: System name via SQL

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)]