Sample Script File

The following ODXAIM script was generated against the Orders sample database installed in Oracle.

-- OdxAIM Omnidex Automatic Indexing Manager

-- Date Generated: 10/16/01 13:01:51
-- Environment File: orders.env
-- Database Type: ORACLE
-- Omnidex Version: 3.7 Build 9D

drop table odxtrans;
create table odxtrans

(
request_sequence integer,
request char(32),
request_timestamp char(32),
tablename char(32),
native_rowid char(32),
new_native_rowid char(32),
transaction_data varchar2(4000)
);

commit;

drop sequence odxtrans_sequence;

create sequence odxtrans_sequence

increment by 1
start with 1
nomaxvalue
nocycle
cache 100;

commit;

ACTIVITY
create or replace trigger ACTIVITY_odx_ins_trg

after insert on ACTIVITY
for each row
declare
begin

insert into odxtrans
(request_sequence, request, request_timestamp, tablename,native_rowid,
new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,'INSERT',SYSDATE,'ACTIVITY',
RPAD(ROWIDTOCHAR(:new.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~CUSTOMER_NO, DATE_TICKLER, TICKLER, INITIALS, ACTION_INFO~' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.DATE_TICKLER || '^' ||
:new.TICKLER || '^' ||
:new.INITIALS || '^' ||
:new.ACTION_INFO || '^');

end;

/

create or replace trigger ACTIVITY_odx_upd_trg

after update on ACTIVITY
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'UPDATE',
SYSDATE,
'ACTIVITY',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~CUSTOMER_NO, DATE_TICKLER, TICKLER, INITIALS, ACTION_INFO~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.DATE_TICKLER || '^' ||
:old.TICKLER || '^' ||
:old.INITIALS || '^' ||
:old.ACTION_INFO || '^' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.DATE_TICKLER || '^' ||
:new.TICKLER || '^' ||
:new.INITIALS || '^' ||
:new.ACTION_INFO || '^');

end;

/

create or replace trigger ACTIVITY_odx_del_trg

after delete on ACTIVITY
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'DELETE',
SYSDATE,
'ACTIVITY',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:old.rowid),32),
'~CUSTOMER_NO, DATE_TICKLER, TICKLER, INITIALS, ACTION_INFO~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.DATE_TICKLER || '^' ||
:old.TICKLER || '^' ||
:old.INITIALS || '^' ||
:old.ACTION_INFO || '^');

end;

/

commit;

CUSTOMERS
create or replace trigger CUSTOMERS_odx_ins_trg

after insert on CUSTOMERS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'INSERT',
SYSDATE,
'CUSTOMERS',
'norowid',
'norowid',
'~CUSTOMER_NO, COMPANY, CONTACT, CITY, STATE, POSTAL_CODE, PHONE_NO,' ||
' AKA_COMPANY, COMMENTS~' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.COMPANY || '^' ||
:new.CONTACT || '^' ||
:new.CITY || '^' ||
:new.STATE || '^' ||
:new.POSTAL_CODE || '^' ||
:new.PHONE_NO || '^' ||
:new.AKA_COMPANY || '^' ||
:new.COMMENTS || '^');

end;

/

create or replace trigger CUSTOMERS_odx_upd_trg

after update on CUSTOMERS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'UPDATE',
SYSDATE,
'CUSTOMERS',
'norowid',
'norowid',
'~CUSTOMER_NO, COMPANY, CONTACT, CITY, STATE, POSTAL_CODE, PHONE_NO,' ||
' AKA_COMPANY, COMMENTS~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.COMPANY || '^' ||
:old.CONTACT || '^' ||
:old.CITY || '^' ||
:old.STATE || '^' ||
:old.POSTAL_CODE || '^' ||
:old.PHONE_NO || '^' ||
:old.AKA_COMPANY || '^' ||
:old.COMMENTS || '^' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.COMPANY || '^' ||
:new.CONTACT || '^' ||
:new.CITY || '^' ||
:new.STATE || '^' ||
:new.POSTAL_CODE || '^' ||
:new.PHONE_NO || '^' ||
:new.AKA_COMPANY || '^' ||
:new.COMMENTS || '^');

end;

/

create or replace trigger CUSTOMERS_odx_del_trg

after delete on CUSTOMERS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'DELETE',
SYSDATE,
'CUSTOMERS',
'norowid',
'norowid',
'~CUSTOMER_NO, COMPANY, CONTACT, CITY, STATE, POSTAL_CODE, PHONE_NO,' ||
' AKA_COMPANY, COMMENTS~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.COMPANY || '^' ||
:old.CONTACT || '^' ||
:old.CITY || '^' ||
:old.STATE || '^' ||
:old.POSTAL_CODE || '^' ||
:old.PHONE_NO || '^' ||
:old.AKA_COMPANY || '^' ||
:old.COMMENTS || '^');

end;

/

commit;

CUST_NOTES
create or replace trigger CUST_NOTES_odx_ins_trg

after insert on CUST_NOTES
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'INSERT',
SYSDATE,
'CUST_NOTES',
RPAD(ROWIDTOCHAR(:new.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~CUSTOMER_NO, DATE_ENTERED, DESC_LINES1, DESC_LINES2, DESC_LINES3,' ||
' DESC_LINES4, DESC_LINES5~' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.DATE_ENTERED || '^' ||
:new.DESC_LINES1 || '^' ||
:new.DESC_LINES2 || '^' ||
:new.DESC_LINES3 || '^' ||
:new.DESC_LINES4 || '^' ||
:new.DESC_LINES5 || '^');

end;

/

create or replace trigger CUST_NOTES_odx_upd_trg

after update on CUST_NOTES
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'UPDATE',
SYSDATE,
'CUST_NOTES',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~CUSTOMER_NO, DATE_ENTERED, DESC_LINES1, DESC_LINES2, DESC_LINES3,' ||
' DESC_LINES4, DESC_LINES5~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.DATE_ENTERED || '^' ||
:old.DESC_LINES1 || '^' ||
:old.DESC_LINES2 || '^' ||
:old.DESC_LINES3 || '^' ||
:old.DESC_LINES4 || '^' ||
:old.DESC_LINES5 || '^' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.DATE_ENTERED || '^' ||
:new.DESC_LINES1 || '^' ||
:new.DESC_LINES2 || '^' ||
:new.DESC_LINES3 || '^' ||
:new.DESC_LINES4 || '^' ||
:new.DESC_LINES5 || '^');

end;

/

create or replace trigger CUST_NOTES_odx_del_trg

after delete on CUST_NOTES
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'DELETE',
SYSDATE,
'CUST_NOTES',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:old.rowid),32),
'~CUSTOMER_NO, DATE_ENTERED, DESC_LINES1, DESC_LINES2, DESC_LINES3,' ||
' DESC_LINES4, DESC_LINES5~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.DATE_ENTERED || '^' ||
:old.DESC_LINES1 || '^' ||
:old.DESC_LINES2 || '^' ||
:old.DESC_LINES3 || '^' ||
:old.DESC_LINES4 || '^' ||
:old.DESC_LINES5 || '^');

end;

/

commit;

INVENTORY
create or replace trigger INVENTORY_odx_ins_trg

after insert on INVENTORY
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'INSERT',
SYSDATE,
'INVENTORY',
RPAD(ROWIDTOCHAR(:new.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~PRODUCT_NO, INV_DATE, INV_QTY, INV_COST, INV_LOC~' ||
:new.PRODUCT_NO || '^' ||
:new.INV_DATE || '^' ||
TO_CHAR(:new.INV_QTY) || '^' ||
TO_CHAR(:new.INV_COST) || '^' ||
:new.INV_LOC || '^');

end;

/

create or replace trigger INVENTORY_odx_upd_trg

after update on INVENTORY
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'UPDATE',
SYSDATE,
'INVENTORY',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~PRODUCT_NO, INV_DATE, INV_QTY, INV_COST, INV_LOC~' ||
:old.PRODUCT_NO || '^' ||
:old.INV_DATE || '^' ||
TO_CHAR(:old.INV_QTY) || '^' ||
TO_CHAR(:old.INV_COST) || '^' ||
:old.INV_LOC || '^' ||
:new.PRODUCT_NO || '^' ||
:new.INV_DATE || '^' ||
TO_CHAR(:new.INV_QTY) || '^' ||
TO_CHAR(:new.INV_COST) || '^' ||
:new.INV_LOC || '^');

end;

/

create or replace trigger INVENTORY_odx_del_trg

after delete on INVENTORY
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'DELETE',
SYSDATE,
'INVENTORY',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:old.rowid),32),
'~PRODUCT_NO, INV_DATE, INV_QTY, INV_COST, INV_LOC~' ||
:old.PRODUCT_NO || '^' ||
:old.INV_DATE || '^' ||
TO_CHAR(:old.INV_QTY) || '^' ||
TO_CHAR(:old.INV_COST) || '^' ||
:old.INV_LOC || '^');

end;

/

commit;

ORDERS
create or replace trigger ORDERS_odx_ins_trg

after insert on ORDERS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'INSERT',
SYSDATE,
'ORDERS',
RPAD(ROWIDTOCHAR(:new.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~CUSTOMER_NO, PRODUCT_NO, ORDER_DATE, STATUS, QUANTITY, AMOUNT~' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.PRODUCT_NO || '^' ||
:new.ORDER_DATE || '^' ||
:new.STATUS || '^' ||
TO_CHAR(:new.QUANTITY) || '^' ||
TO_CHAR(:new.AMOUNT) || '^');

end;

/

create or replace trigger ORDERS_odx_upd_trg

after update on ORDERS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'UPDATE',
SYSDATE,
'ORDERS',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:new.rowid),32),
'~CUSTOMER_NO, PRODUCT_NO, ORDER_DATE, STATUS, QUANTITY, AMOUNT~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.PRODUCT_NO || '^' ||
:old.ORDER_DATE || '^' ||
:old.STATUS || '^' ||
TO_CHAR(:old.QUANTITY) || '^' ||
TO_CHAR(:old.AMOUNT) || '^' ||
TO_CHAR(:new.CUSTOMER_NO) || '^' ||
:new.PRODUCT_NO || '^' ||
:new.ORDER_DATE || '^' ||
:new.STATUS || '^' ||
TO_CHAR(:new.QUANTITY) || '^' ||
TO_CHAR(:new.AMOUNT) || '^');

end;

/

create or replace trigger ORDERS_odx_del_trg

after delete on ORDERS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'DELETE',
SYSDATE,
'ORDERS',
RPAD(ROWIDTOCHAR(:old.rowid),32),
RPAD(ROWIDTOCHAR(:old.rowid),32),
'~CUSTOMER_NO, PRODUCT_NO, ORDER_DATE, STATUS, QUANTITY, AMOUNT~' ||
TO_CHAR(:old.CUSTOMER_NO) || '^' ||
:old.PRODUCT_NO || '^' ||
:old.ORDER_DATE || '^' ||
:old.STATUS || '^' ||
TO_CHAR(:old.QUANTITY) || '^' ||
TO_CHAR(:old.AMOUNT) || '^');

end;

/

commit;

PRODUCTS
create or replace trigger PRODUCTS_odx_ins_trg

after insert on PRODUCTS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'INSERT',
SYSDATE,
'PRODUCTS',
'norowid',
'norowid',
'~PRODUCT_NO, PRODUCT_CLASS, PRODUCT_NAME, SALES_PRICE, PRODUCT_COST~' ||
:new.PRODUCT_NO || '^' ||
:new.PRODUCT_CLASS || '^' ||
:new.PRODUCT_NAME || '^' ||
TO_CHAR(:new.SALES_PRICE) || '^' ||
TO_CHAR(:new.PRODUCT_COST) || '^');

end;

/

create or replace trigger PRODUCTS_odx_upd_trg

after update on PRODUCTS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'UPDATE',
SYSDATE,
'PRODUCTS',
'norowid',
'norowid',
'~PRODUCT_NO, PRODUCT_CLASS, PRODUCT_NAME, SALES_PRICE, PRODUCT_COST~' ||
:old.PRODUCT_NO || '^' ||
:old.PRODUCT_CLASS || '^' ||
:old.PRODUCT_NAME || '^' ||
TO_CHAR(:old.SALES_PRICE) || '^' ||
TO_CHAR(:old.PRODUCT_COST) || '^' ||
:new.PRODUCT_NO || '^' ||
:new.PRODUCT_CLASS || '^' ||
:new.PRODUCT_NAME || '^' ||
TO_CHAR(:new.SALES_PRICE) || '^' ||
TO_CHAR(:new.PRODUCT_COST) || '^');

end;

/

create or replace trigger PRODUCTS_odx_del_trg

after delete on PRODUCTS
for each row
declare
begin

insert into odxtrans

(request_sequence, request, request_timestamp, tablename,
native_rowid, new_native_rowid, transaction_data)
values
(odxtrans_sequence.nextval,
'DELETE',
SYSDATE,
'PRODUCTS',
'norowid',
'norowid',
'~PRODUCT_NO, PRODUCT_CLASS, PRODUCT_NAME, SALES_PRICE, PRODUCT_COST~' ||
:old.PRODUCT_NO || '^' ||
:old.PRODUCT_CLASS || '^' ||
:old.PRODUCT_NAME || '^' ||
TO_CHAR(:old.SALES_PRICE) || '^' ||
TO_CHAR(:old.PRODUCT_COST) || '^');

end;

/

commit;

Top