Re: Where is WRKFCNUSG stored

Nice find - these are views - the first over QSYS2.QSYFINFO - found the definition of the first view in SYSVIEWS.

The usage one is also a view over that same table plus a UDTF whose definition I didn't go after - but it's probably in SYSFUNCS.

I suspect that the approach here for mass update is to write something that gathers the change or changes you want, then walk through users and use the APIs to make the change. Such a program COULD also be made into a user-defined function, maybe by simply calling it in SQL, which automatically turns programs into callable functions, right? Look it up, my details might be fuzzy.

Cheers
Vern

On 2/4/2020 9:25 AM, Bryan Dietz wrote:

so one more search turns up:

http://archive.ibmsystemsmag.com/blogs/i-can/march-2016/ibm-i-services-for-function-usage-information/

SELECT * FROM QSYS2.FUNCTION_INFO ;
SELECT * FROM QSYS2.FUNCTION_USAGE ;


is this what you are looking for?

Bryan


DRIVER Adam ResgGtsMktSrv wrote on 2/2/2020 5:49 PM:

Hi,

Does anyone know where WRKFCNUSG is stored? Is it possible to make a mass update with a SQL statement?

Thanks

               Adam DRIVER
               AME - RESG/GTS/MFR/AS400
               425 S. Financial Pl, 24th Floor
               Chicago, IL 60605
               Tel.: +1 312.762.1194
               Cell: +1 224.250.9049
               Team: +1 312.762.1125
               Email: adam.driver@xxxxxxxxxx<mailto:adam.driver@xxxxxxxxxx>

               www.sgcib.com<http://www.sgcib.com/>
                   Primary CI: AS400
              Assignment Group: gts-wwi-ssb-app-as400
              Team Email: amer-gts-mkt-ssb-as400-team
              Tel (24 hrs): 312 762 1125

Any new support request should be sent to the first level at helpdesk@xxxxxxxxxxxxxxxxxxx<mailto:helpdesk@xxxxxxxxxxxxxxxxxxx>
[http://insite.fr.world.socgen/ecard/images/logo_legal_l.gif][http://insite.fr.world.socgen/ecard/images/logo_legal_r.gif]



*************************************************************************
This message and any attachments (the "message") are confidential, intended
solely for the addressee(s), and may contain legally privileged information.
Any unauthorized use or dissemination is prohibited. E-mails are susceptible
to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or
affiliates shall be liable for the message if altered, changed or falsified.
Please visit http://sgasdisclosure.com for important information regarding
SG Americas Securities, LLC ("SGAS"). Please visit http://swapdisclosure.sgcib.com
for important information regarding swap transactions with SOCIETE GENERALE.
*************************************************************************