Originally posted by: SystemAdmin
Hi,
I am trying to trigger a map based on a DML operation on a table.
I did the following steps:
1)created a mdq file with a query as select * from dept & defined trigger for insert/update & delete for table dept.(I did give the relevant details in the database defn ie dbname,connect string,uname,passwd & adapter type)
2) I then created a t.tree from the query & subsequently a map with i/p source as d/b & command as -TR i dept
the o/p of map is just a flat file where we get all the rows of dept table.
3) i then created .msl & .msd files in IFD & also set the launcher settings as:
Time event switch-ON
I/p soucrce event-ON
o/p switch-ON
& other file details given.
4) I then deployed this map on the local server.
5) Now I did do a insert on the dept table to see if the map gets triggered. But it dosent.
6) my .dbl file gives some error reg:
<524-3392>: Error in: OCIStmtExecute
Message : ORA-06550: line 1, column 7:
PLS-00201: identifier 'MSP_REGISTER_SRVR' must be declared
I have also attached the .dbl file here.
Could somebody explain why the map dosent get triggered when iam doing a DML on table dept???
#IBM-Websphere-Transformation-Extender#DataExchange#IBMSterlingTransformationExtender