×
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.
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
midrange.com
