How to get a list of all users with profile records in CA 7 r12 Datacom Database
Article ID: 74933
Updated On:
Products
CA Workload Automation CA 7 Edition
CA-7 JOB MGMT
CA 7 Workload Automation
Issue/Introduction
How can I get a list of users that have a profile record defined to CA 7 r12 Datacom database?
Environment
Release: SEVDT.99000-12.0-Workload Automation-CA 7 Edition
Component:
Component:
Resolution
Use the following sample SQL JCL to extract the user profiles from the CA 7 r12 database:
jobcard...
//STEP1 EXEC PGM=DBSQLPR
//STEPLIB DD DISP=SHR,DSN=your.CUSLIB
// DD DISP=SHR,DSN=your.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//STDOUT DD SYSOUT=*
//OPTIONS DD *
PRTWIDTH=255
INPUTWIDTH=70
ROWLIMIT=5000
AUTHID=MFWA
NOTYPE
//SYSIN DD *
SELECT USERID FROM CA7_USER_PROFILE
WHERE DB = 'logical database name' ; >>>change to your logical db
jobcard...
//STEP1 EXEC PGM=DBSQLPR
//STEPLIB DD DISP=SHR,DSN=your.CUSLIB
// DD DISP=SHR,DSN=your.CAAXLOAD
//SYSPRINT DD SYSOUT=*
//STDOUT DD SYSOUT=*
//OPTIONS DD *
PRTWIDTH=255
INPUTWIDTH=70
ROWLIMIT=5000
AUTHID=MFWA
NOTYPE
//SYSIN DD *
SELECT USERID FROM CA7_USER_PROFILE
WHERE DB = 'logical database name' ; >>>change to your logical db
Feedback
Yes
No
Powered by
