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



if you happen to be on V7.4 i thought this was fun :-)

RUNSQL SQL('CALL QSYS2.CREATE_USER_SPACE(
USER_SPACE => ''USRSPC1'',
USER_SPACE_LIBRARY => ''QGPL'',
SIZE => 10,
PUBLIC_AUTHORITY => ''*USE'')')
COMMIT(*NONE)

RUNSQL SQL('CALL QSYS2.CHANGE_USER_SPACE(
USER_SPACE => ''USRSPC1'',
USER_SPACE_LIBRARY => ''QGPL'',
DATA => (SELECT COUNT(*)
FROM QSYS2.ASP_INFO),
START_POSITION => 1)')
COMMIT(*NONE)

simple verification from commandline
dspf '/qsys.lib/qgpl.lib/usrspc1.usrspc'

https://www.ibm.com/docs/en/i/7.4?topic=as-change-user-space-change-user-space-binary-procedures
https://www.ibm.com/docs/en/i/7.4?topic=services-create-user-space-procedure

--
Bryan

Steve McKay wrote on 6/3/2022 4:31 PM:
SELECT COUNT(*) FROM QSYS2.ASP_INFO

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.