| Re: Oracle Pure Integrate in Oracle Warehouse Builder..! [message #92883] |
Fri, 04 January 2002 06:52 |
Carla García
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
My problem is I have a table with an id column, and the last value of this column is 936, I need to insert more records in this table and put its own id starting in 937 number so I was trying to build a custom rule like this:
define s as LAST(select CU_ID_CUENTA from ODBU_D_CUENTA);
s+1
Where ODBU_D_CUENTA is my table name and CU_ID_CUENTA is the name of the column and show me the followin error:
Application Generation
Module: CODE_GENERATION File Name: Gengen.cpp Line Number: 219
Date and Time Stamp: Fri Jan 04 10:48:12 2002
Number of Causals: 1
----------------------------------------------------------------
Reference table:Dimensions(Schema), ODBU_D_CUENTA(Entity) (load ON_DEMAND)
is referenced in Custom rule: Dimensions(Schema), ODBU_D_CUENTA(Entity), CU_ID_CUENTA(Attribute), CU_ID_CUENTAMergeRule1(Merge Rule)(OQL).
The OQL WHERE clause is nonexistent or too complex to generate a where clause when querying the physical database.
The entire table will be searched in the physical database each time this rule is executed.
Module: OQL_PARSER File Name: GenCpp_Intermid.cpp Line Number: 139
Date and Time Stamp: Fri Jan 04 10:48:12 2002
----------------------------------------------------------------
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
