The following query lists the parameter settings of all profiles in the system with their parameter settings:
SELECT CAST(ProfileName AS CHAR(15)), CAST (DefaultDB AS CHAR(15)), CAST (DefaultAccount AS CHAR(15)), SpoolSpace, TempSpace FROM DBC.ProfileInfoV ORDER BY 1;
Result:
*** Query completed. 3 rows found. 5 columns returned. ProfileName DefaultDB DefaultAccount SpoolSpace TempSpace ----------- --------- -------------- ---------- ------------ kanji japan i18n 50000 50000 HResources personnel ? ? ? NTGroup NT ncrsandiego 50000 50000
If multiple accounts are specified for the ACCOUNT parameters, only the first account (the default account) in the list is reflected in the display. The remaining accounts in the list can be retrieved by performing a SELECT on the existing view DBC.AccountInfoV. Parameter settings for the profile assigned to the user may similarly be displayed by performing a SELECT on the system view DBC.ProfilesInfoVX.