Hi Paul,
The DDLCAT area is actually the SQL catalog, which is used for both SQL table definitions and for physical database definitions, so you can use SQL directly to query it. There is no need to define an SQL schema for NONSQL, you just use the SYSTEM schema. The FILE-1039 record is actually defined as the SYSTEM.FILE table, even when SQL is not "installed".
So, unless I'm missing something, you should be able to do something this:
OCF 19.0 IDMS NO ERRORS 1/19 SYSQA10
SELECT SEGMENT, NAME FROM SYSTEM.FILE;
*+
*+ SEGMENT NAME
*+ ------- ----
*+ DBCRSQL ACCTSQL
*+ DBCRSQL BRCHSQL
*+ SYSCAT CATF1
*+ SYSCAT CATF2
*+ SYSCAT CATF3
*+ SQLDEMO EMPLDEMO
*+ SQLDEMO INDXDEMO
*+ SQLDEMO INFODEMO
*+ PROJSEG PROJDEMO
*+ USERDB USERDB4
*+ USERDB USERDB5
*+ USERDB USERDB8
*+ USERDB USERDB9
*+
*+ 13 rows processed
You can see the definition using:
OCF 19.0 IDMS NO ERRORS 1/37 SYSQA10
DISPLAY TABLE SYSTEM.FILE;
*+ Status = 0 SQLSTATE = 00000
*+ CREATE TABLE SYSTEM.FILE
*+ DATE CREATED 1990-01-01-00.00.00.000000 BY DOWDA01
*+ DATE LAST UPDATED 2013-01-10-12.52.59.681822 BY DOWDA01
*+ ( SEGMENT CHARACTER(8) NOT NULL,
*+ NAME CHARACTER(18) NOT NULL,
*+ CTIME TIMESTAMP NOT NULL,
*+ UTIME TIMESTAMP NOT NULL,
*+ CRITTIME TIMESTAMP NOT NULL,
*+ CUSER CHARACTER(18) NOT NULL,
*+ UUSER CHARACTER(18) NOT NULL,
*+ NUMFILEMAPS SMALLINT NOT NULL,
*+ BLOCKSIZE INTEGER NOT NULL,
*+ DDNAME CHARACTER(8) NOT NULL,
*+ ACCESSMETHOD CHARACTER(8) NOT NULL,
*+ VMUSERID CHARACTER(8) NOT NULL,
*+ VMVIRTADDR CHARACTER(4) NOT NULL,
*+ FLAG BINARY(1) NOT NULL,
*+ NVSAMSET CHARACTER(18) NOT NULL,
*+ DSNAME CHARACTER(54) NOT NULL,
*+ DISP CHARACTER(4) NOT NULL,
*+ FILLER BINARY(39) NOT NULL
*+ )
*+ IN SYSCAT.DDLCAT
*+ TABLE ID 1039
*+ NO DEFAULT INDEX
*+ TABLE ID 1039
*+ IX-FILE UNIQUE INDEX ON ( NAME, SEGMENT )
*+ SEGMENT-FILE CONSTRAINT FOREIGN KEY ( SEGMENT )
*+ REFERENCES SYSTEM.SEGMENT ( NAME )
*+ REFERENCED BY SYSTEM.DMCLFILE IN CONSTRAINT FILE-DMCLFILE
*+ REFERENCED BY SYSTEM.FILEMAP IN CONSTRAINT FILE-FILEMAP
*+ USED IN VIEWS:
*+ SYSVSYST5.DMCL_FILE
*+ SYSVSYST5.VFILE_CACHE_BUF_1
*+ ;
I hope this helps.
Dave