I created a test user, DUMMY.
crtlib dummy
CRTJOBD JOBD(DUMMY/DUMMY) INLLIBL(ERPLXF)
CRTUSRPRF USRPRF(DUMMY) CURLIB(ERPLXF) JOBD(DUMMY/DUMMY)
I connect using the old iNav.
My list of schemas only shows QGPL.
I execute the old Run SQL Scripts
values current schema
returns DUMMY
It did this on my first attempt also. BEFORE I created the library DUMMY,
the job description and set the user profile to that job description.
CRTUSRPRF USRPRF(DUMMY) CURLIB(ERPLXF)
Documentation says: The initial value of CURRENT SCHEMA is the
authorization ID of the current session user. You've got to be freaking
kidding me!
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzcursch.htm?lang=en
So, to get an initial default schema of ERPLXF I have to name the user
ERPLXF?
I just want to default people's initial ODBC connection and not have to do
a SET SCHEMA.
Would this break anything of y'all if I submit a DCR to get IBM to change
this to the user profiles Current library?
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.