I used the ISQL LOAD command a few times. If I remember well, it does
support only ASCII representation of data. So, first you should convert your
datafile in one that contains only ascii values of your data, in a fixed
length format (each column should have a fixed length) and then load that
file into ALLBASE file the LOAD command. A simple COBOL program should
easily do the job, or if like us you have SUPRTOOL from Robelle, it'll be
easier.

A simple way to set a file format LOAD would understand is doing a UNLOAD of
the table you want to load. It'll produce a datafile AND a file containing
the specification that you could use for the load.

HTH

Michel Gauthier
Donohue Inc.

john edwards <[log in to unmask]> wrote in message
news:F4B1826B1A21D211AEC5006008207AF40302DA35@dogbert.csillc.com...
> Hi All
> I want to load a flat file into ALLBASE. The ISQL/LOAD
> utility would seem to be the right way to go. There
> are some COMP-3 fields in the file and the
> documentation for ISQL/LOAD does not tell me how to
> define these.
> Can some one point me in the right direction please?
> Is there a good web site for ALLBASE info?
> Thanks
> John
> __________________________________________________
> Do You Yahoo!?
> Thousands of Stores.  Millions of Products.  All in one place.
> Yahoo! Shopping: http://shopping.yahoo.com
>