Originally posted by: SystemAdmin

Trying to create an update, receive error "could not retrieve database information", when I try to build the map. MDQ query is "SELECT DOC_STATUS FROM DB2OCAP.TBOC46B WHERE WARRANT_ISS_DATE = '1900-01-01'." Table tree has Key column = WARRANT_ISS_DATE and Columns to update has DOC_STATUS. Map output card for DOC_STATUS column has rule =DBQUERY("UPDATE DB2OCAP.TBOC46B SET DOC-STATUS = 'SENT TO TOC' WHERE WARRANT_ISS_DATE = '1900-01-01'", '..\DB\DWOCAPS\TBOC46B_UPDATE.MDQ", "DB2OCAP")

Thanks in advance for your suggestions.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Not sure if this is it, but;

Either you may want the entire MDQ path, instead of
'..\DB\DWOCAPS\TBOC46B_UPDATE.MDQ"
ie. c:\folder\DB\DWOCAPS\TBOC46B_UPDATE.MDQ"

but also,

if that is your rule that you cut and pasted, there's a single quote before the path to the MDQ and a double quote after the path. I would change those and try again. If in the MDQ you can double click any table and not get a connection error, you can connect to the DB. If it still doesn't work, create the a trace file -T.

Message was edited by: rep
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

That was a typo for that single quote on my part, when I typed it in to my message. I changed the path for the mdq and that did not fix the problem. I have no problem connecting to the database when I generate the tree in the DID. The trace does not function when I am trying to do the build, which is where I am receiving this error(M1013). If I try to do the run without the build, it indicates that it mapped successfully, but it does not update any records.

I have attached the map for observation purposes and can also attach the MDQ and TTE if that will help any.

Thanks
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange