Re: Mapping object to tables

["Luther Ananda Miller" <luther.miller@xxxxxxxxxx>]

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