Re: Where is WRKFCNUSG stored

Vern,

For my purposes, it will be just a straight SQL update changing a group name. We have almost all the Navigator functions locked down to one group, we just want to change to a different group without having to change each function one by one.

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]


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

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