need to refer the commerce schema

[p***@yahoo.com]

i created a custom table.
It has couple of foreign keys which refer to some commerce tables.
When I try to create that foreign key,it asks for target table.There i dont see any commerce populated nor i see in metainf folder.
How do i map to the commerce app schema and get reference to those table.

[m***@ca.ibm.com]

I posted a note to the developer. I will respond when I get an answer from him

[geo]

some first questions would be what database, what version of Commerce, RAD
or WSAD??

Post by p***@yahoo.com
i created a custom table.
It has couple of foreign keys which refer to some commerce tables.
When I try to create that foreign key,it asks for target table.There i
dont see any commerce populated nor i see in metainf folder.
How do i map to the commerce app schema and get reference to those table.

[p***@yahoo.com]

RAD 6.0
WCS 6.0
db is cloudscape.

I created a db connection to the cloudscape and loaded all the tables.
When I create the custom table(performing queries),all tables will be created in APP schema rite?
So while I create a table in RAD,can I create the table in the same schema i.e APP?
Or
Should I create a new schema and then while referring to the commecre table for foreign key constraints should I browse and go to the default APP schema and select the table?

Which one is adivisable?
plz clarify.

[p***@yahoo.com]

hi

I have also done similar thing in websphere commerce . For creating a reference as foreign key i am attaching an example sql

ALTER TABLE ORDERS_TEST ADD
CONSTRAINT TEST
FOREIGN KEY (SOURCEID)
REFERENCES ORDERS (ADDRESS_ID) ENABLE
VALIDATE


where orders_test is my customozed table and it refers to address_id column in orders table which is a commerce table

thanks
pravar