×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Jim Essinger wrote:
Can I make SQL to look in the library list for files while using the
SQL naming convention with STRSQL and/or RUNSQLSTM?
Jim:
The question is kind of self-contradictory. From the SQL Programming
manual:
"
SQL naming (*SQL)
In the SQL naming convention, tables and other SQL objects in an SQL
statement are qualified by the schema name in the form:
schema.table
"
Some generalized comments --
That is, SQL has no 'library' nor 'library list' concept. It
operates over 'schemas' or 'collections'. You use the *SQL
convention when you want to code to schema-style specs. And when you
do that, there is practically no such thing as a 'library list'.
There are explicitly specified schemas (e.g., "schema.table") and
default collections for schemas of unqualified names (e.g.,
RUNSQLSTM DFTRDBCOL(coll_name)).
If you want to step a little into the i5/OS way of doing things, you
choose *SYS and reference 'libraries' rather than 'schemas'. And
'library list' then has significant meaning.
In effect in this case, by choosing *SQL, you're telling DB2 _not_
to use your library list.
Tom Liotta
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.
midrange.com
