Ken Sletten writes:

<snip for brevity>

> LENGTH:
>
>   510  bytes for maximum subitem length
>   4096 bytes for maximum item length

Just a couple of months ago, I tried creating a data base with a 
data set with fields of X256 and DBSCHEMA refused to build the 
root file.  I ended up using two fields of X128 and using them as
"chunks" of data.  This was on "the latest" version of Image/SQL, 
or at least the version that supports ODBC.   Here is what happens:

:RUN DBSCHEMA.PUB.SYS;PARM=3

PAGE 1      HEWLETT-PACKARD 30391C.07.04  TurboIMAGE/3000: DBSCHEMA
        FRI, AUG 14, 1998, 11:01 PM  (C) HEWLETT-PACKARD CO. 1987
 
 
<< IMAGE/SQL DRDB.PUB.CUSTOM              FRI, JAN 16, 1998,  3:23 PM >>
 
<<   Schema by Adager (The Adapter/Manager for IMAGE/SQL Databases)   >>
 
$CONTROL BlockMax = 768
<< The actual Root BufferLength is 731 >> 
 
 
Begin data base DRDB; 
 
 
Passwords: 
 
 
                         << Since passwords may have unprintable    >> 
                         << characters, Adager lists the ASCII      >> 
                         << codes in octal for your convenience.    >> 
 
            10 DBREADER; << %104 %102 %122 %105 %101 %104 %105 %122 >> 
            20 DBWRITER; << %104 %102 %127 %122 %111 %124 %105 %122 >> 
 
 
 
 
Items: 
 
PLANT-CODE      ,   X2  ; 
LINE-ID         ,   X4  ; 
SCHED-NO        ,   X8  ; 
SCHED-SEQ-NO    ,   X4  ; 
DATASET-NAME    ,   X16 ; 
ACTION-TYPE     ,   X2  ; 
DATA-BLOCK-1    ,   X256; 
 
***** ERROR *****  BAD SUBITEM LENGTH OR TERMINATOR
 
 
 
 
Sets: 
 
 
PAGE 2      DRDB            Dataset number 1                     *** DRL


Name: DRLOG           , Detail   (10,20/20); 
 
Entry: 
 
  PLANT-CODE       ,                                       << X2      >>
  LINE-ID          ,                                       << X4      >>
  SCHED-NO         ,                                       << X8      >>
  SCHED-SEQ-NO     ,                                       << X4      >>
  DATASET-NAME     ,                                       << X16     >>
  ACTION-TYPE      ,                                       << X2      >>
  DATA-BLOCK-1     ;                                       << X256    >>
 
Cap: 100000 (5);<<DRLOG, BlockFactor=5>> 
 
 
PAGE 3      DRDB            *** Global DBSCHEMA statistics ***


end. << Schema by Adager, The Adapter/Manager for IMAGE/SQL Databases >>
 
 
NUMBER OF ERROR MESSAGES: 1     
ITEM NAME COUNT: 7       DATA SET COUNT: 1     
 
PRECEDING ERRORS -- NO ROOT FILE CREATED.

SCHEMA PROCESSING TERMINATED.

Program terminated in an error state. (CIERR 976)


So, what gives?

Jim Phillips                            Manager of Information Systems
Voice: (330) 527-2124                   Therm-O-Link, Inc.
  Fax: (330) 527-2123                   PO Box 285; 10513 Freedom St.
Email: [log in to unmask]       Garrettsville, Ohio  44231