Re: Mapping object to tables -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Title: Mapping object to tables

Hi,

I have run into this before. It seems when you create a table with DDS and use the K identifier to define the key, the ODBC (and JDBC it seems like) drivers don't pick it up because it doesn't get stored in the SQL data of the databse. If you create the table with SQL CREATE TABLE and set the key with SQL as well, then it works fine. We have app that reads table definitions and builds code etc.; if it can't find the key fields in this manner then it does a query similar to this:

SELECT DBKFLD FROM QSYS.QADBKFLD

I have used the object builder in vaj, but it probably cannot be programmed to do this (?).

Luther

----- Original Message -----

From: DUCRET Gilles (GVA)

To: 'JAVA400-L@midrange.com'

Sent: Monday, 31 January 2000 16:22

Subject: RE: Mapping object to tables

Sorry for this, i found the answer by myself.

VAJ can recognize a key field only on files with primary key constraints.

If your file has no primary key constraint an error message appear.

What you have to do is to edit your table in your shema and say what column is the

primary key.

You can then do your mapping

Gilles

This mailing list archive is Copyright 1997-2024 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.