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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.