: MIDRANGE dot COM Mailing List Archive

User defined data type fields


AddThis Feed Button


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







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2010 by MIDRANGE dot 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 here. If you have questions about this, please contact