I have a file that was created with SQL under V5R2 and used an SQL data
type called "ROWID". When I try to read it with my MI program I get a
CPF428A message ( 3 -- The format for file ORDERS contains one or more
user defined data
type fields and the open request did not indicate that user defined data
type fields could be processed by the user of the open.). Here is a
copy of the SQL statements: CREATE TABLE QGPL/ORDERS (ORDERNO ROWID
GENERATED ALWAYS, SHIPPED_TO VARCHAR (36), ORDER_DATE DATE). Add a
record with the following SQL statement: INSERT INTO QGPL/ORDERS
(ORDER_DATE, SHIPPED_TO) VALUES('11/04/2004', 'B') WITH NC. Can you
tell me what I would have to change to be able to open the file and read
the data.
Allen Hartley