Re: Where is WRKFCNUSG stored

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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