Re: 'Convert' Library To Schema

Scott Johnson wrote:

I have an existing Libraries that I would like to 'convert' to an SQL
Schemas. Basically I am looking to have the Sys objects added to it instead of using the default qsys2 ones.

Is there a command to do this?
Are there any minuses to doing this?

What is the point in wanting /the objects/ that make up a SCHEMA?
http://archive.midrange.com/midrange-l/200803/msg01345.html

Regardless, the following script will effect the requested, for an existing library named MYLIB:

crtjrnrcv mylib/qsqjrn0001 threshold(as_required_and_reasonable)
crtjrn mylib/qsqjrn mylib/qsqjrn0001 mngrcv(*system) dltrcv(*yes)
call qsys2/qsqxrlf (CRT MYLIB)

If the goal is actually automatic journaling, research QDFTJRN data area. Note that the undocumented QSQXRLF API has almost surely still not been updated to recognize that data area; i.e. the token QSQJRN as name for a *JRN, is still required to exist to enable the API for an invocation with token CRT as the first parameter, in order to effect the creation of the SQL catalog VIEW objects in a user library.

Regards, Chuck