![ibm i access client solutions navigator no starting ibm i access client solutions navigator no starting](https://www.ibm.com/support/pages/system/files/inline-images/image-20200122100339-2.png)
The SQL Default Library is changed by entering a single library name into the SQL Default Library text box as shown in Figure 4. See your system administrator or System i security officer for more detailed information regarding the sign-on options. If the object naming convention is SQL, the SQL Default Library is the library with the same name as the user profile that the SCRIPT Center is running under, which is determined by the System i Navigator sign-on option selected when the connection to the System i server was created. If the Script Center object naming convention is System (*SYS) and there is no entry for the SQL Default Library, the default library becomes *LIBL (the library list for the Script Center). You can think of it as the equivalent of the current library in your library list. The SQL Default Library is the library or schema name (schema is the SQL term for library) that will be used to locate unqualified object names referenced in SQL statements or CL commands. At the top left you should see a text entry box for SQL Default Library, and immediately below that one for Library List as shown in Figure 3. Next click on the Server Tab (should be the default tab) on the left side of the resulting JDBC Setup window. To change either, click on Connection in the toolbar at the top of the Run SQL Scripts window, then click on JDBC Setup as shown if Figure 1. The Scripts Center allows you to change or customize its current library and/or library list. Once you have the job ID, use the WRKACTJOB command in the green screen interface or the Work Management function (if available to you) in System i Navigator to determine the default library list. The job ID can be found just underneath the toolbar on the top left side of the Job Log window. This can be found by clicking on View on the left side of the toolbar at the top of the Run SQL Scripts window, and then Job Log in the resulting drop down. If you want to determine the default Script Center library list, you need to know the Script Center job ID. The default library list (and current library) for the Scripts Center is determined by the user profile that the Script Center is running under, which is determined by the System i Navigator sign-on option selected when the connection to the System i server was created. Then select System (*SYS) from the Naming Convention drop-down at the top for the Format Tab window, click OK as shown in Figure 2, and you’re done. Next click on the Format Tab on the right side of the resulting JDBC Setup window. To change the object naming convention, first click on Connection in the toolbar at the top of the Run SQL Scripts window, then click on JDBC Setup as shown in Figure 1. If you’re comfortable using SQL naming, you don’t have to make this change.
![ibm i access client solutions navigator no starting ibm i access client solutions navigator no starting](https://venturebeat.com/wp-content/uploads/2018/07/null-1.png)
The default Script Center naming convention is SQL, which means that object names are qualified in the format “library.object,” and System object naming convention uses the more familiar format of “library/object.” Most likely you will want to change from SQL to System, which is relatively easy and takes just a couple of steps.
![ibm i access client solutions navigator no starting ibm i access client solutions navigator no starting](https://www.bluechip.co.uk/wp-content/uploads/2019/09/ibm-access-client-solutions.jpg)
The Script center supports the two standard methods of System i object naming convention or object qualification: SQL and System. Exactly how the object name is qualified depends on the object naming convention that is being used by the Script Center. One option is to qualify the object name with the library name in your SQL statement or CL command, and the other option is to use a library list to find or access the desired object. There are two options for finding or accessing your tables, views, and other database objects from the Script Center. One of the most frequently asked questions I get is: How do I access or find my tables and views using the Script Center? the SQL Script Center or Script Center–is an easy-to-use option in System i Navigator that allows you to interactively create and execute one or more SQL statements and/or batch CL commands. Changing the Library List for Run SQL Scripts