AW: Search by Field name?

["BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>]

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