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



This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].