AW: Search by Field name?

Hi,

Just FYI, all information about the database and its objects is stored in
the physical files/tables QADB*.
But these tables are not accessible for everbody and should never be!
That's why IBM provided a couple of catalog views stored in the library
QSYS2.
This are views built over the QADB* fiels and are accessible for everybody.
When creating a schema/library with SQL catalog views will be created in the
new schema. These views will only contain information about the database
objects stored in this schema.

To find information about field/column names and the definition of these
fields, just use the view SYSCOLUMNS.
I this view you'll also find information about short (system) names and long
(SQL) names.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"



-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Steve Landess
Gesendet: Thursday, August 09, 2007 01:12
An: Midrange Systems Technical Discussion
Betreff: Re: Search by Field name?

Bill Blalock wrote:
Would that include files created by SQL? If so I presume the 10
character generated name would be in this file, right?

Bill - does this answer your question?

1 )

===> CHKOBJ OBJ(SJL001/TEMPFILE) OBJTYPE(*FILE)
Object TEMPFILE in library SJL001 not found.

2)

SELECT * FROM qadbifld WHERE DBILIB = 'SJL001' and DBIFIL = 'TEMPFILE'

LIBRARY FILE FORMAT FIELD FILE RELATIONAL LONG
NAME NAME NAME NAME ATTR FILE FILE
NAME

******** End of data ********

No data selected for output.

3)

CREATE TABLE
SJL001/TEMPFILE
(
FIELD1 CHAR ( 10) NOT NULL WITH DEFAULT
, FIELD2 CHAR ( 30) NOT NULL WITH DEFAULT
, FIELD3 CHAR ( 30) NOT NULL WITH DEFAULT
, LONGFIELDNAME CHAR ( 30) NOT NULL WITH DEFAULT
)

Table TEMPFILE in SJL001 created but could not be journaled.

4)

SELECT * FROM qadbifld WHERE DBILIB = 'SJL001' and DBIFIL = 'TEMPFILE'

LIBRARY FILE FORMAT FIELD FILE RELATIONAL LONG
NAME NAME NAME NAME ATTR FILE FILE
NAME
SJL001 TEMPFILE TEMPFILE FIELD1 TB Y TEMPFILE
SJL001 TEMPFILE TEMPFILE FIELD2 TB Y TEMPFILE
SJL001 TEMPFILE TEMPFILE FIELD3 TB Y TEMPFILE
SJL001 TEMPFILE TEMPFILE LONGF00001 TB Y TEMPFILE

******** End of data ********

Regards,
Steve Landess
Austin, Texas