Originally posted by: malag

what is wrong with this rule?
dblookup("delete from emp","mdqfilename","databasename")
I am getting map successful message.But data is not getting deleted from the table.
i tried like this also
dbquery("delete from emp""-mdq xx.mdq -db yy -user jj -password ll -T")
eventhen result is same.why?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: richlee

Does anything show in the log file (mapname.DBL)?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: malag

.DBL is not getting created
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: paul.brett

The lack of a .DBL file indicates that there is a problem with the MDQ and/or adapter initialisation.

Can you change the 'delete from' to a 'select * from' to see if that works?

Post the content of the .MDQ file here for review.

Try a card based transaction, and activate auditing, or use a LASTERRORMSG() function after your DBLOOKUP() to get more information.

Paul.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: DianeC

The lack of a DBL can also happen if the audit isn't turned on or there isn't a trace on the database. Make sure that in your card for the database, you have -UPDATE on the "Command" line.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender