|On Tue, 24 Feb 1998 02:27:37 GMT, Ken ([log in to unmask]) wrote:
|
|>Does IMAGE-SQL properly handle datasets that have fields with an
|>OCCURS description.  Actually they are PIC X(120) fields that MUST be
|>broken into twelve PIC X(10) fields.
|
|Well, if what you mean is "Does Image/SQL successfully handle Image
|repeating fields" the answer is "yes".  But the fields must be defined
|as (in your example) 12X10 in the Image schema.  If you have a field
|that is defined as X120 in the schema, then Image/SQL cannot be made
|to define (or redefine) this field into discrete fields (AFAIK).  If
|I am mistaken in this belief, I'm sure someone will correct me. :-)

IMAGESQL.PUB.SYS automatically splits up repeating fields into
separate fields when you attach a database to a DBE. This won't help
you with your PIC X(120) field. But no problem, you can split the field
manually using the following split command in the IMAGESQL utility:

>>set dbe YOURDBE
>>set base YOURBASE
>>sp dataset.field120 into field1:x10,field2:x10,...,field12:x10

Type "help split" in IMAGESQL for more details. Hope this helps.

Best regards...

Andreas Baronick