Home » Developer & Programmer » Data Integration » Re: Oracle Pure Integrate in Oracle Warehouse Builder..!
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
----------------------------------------------------------------

----------------------------------------------------------------------
Previous Topic: Re: Connection problem with SQL database to C++
Next Topic: Re: Materialized View not refreshing
Goto Forum:
  


Current Time: Thu Oct 29 12:09:09 CDT 2020