Originally posted by: SystemAdmin

I am trying to update a table using -UPDATE query in the output card with out using MDQ file. Map builds successfully but when i execute i get the message target not available.

Has any one come across this earlier?

Also, can we use -update without mdq?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer1

Have you put the trace option in it (-T)? The trace file for database connections can have a lot of good info in it. May want to check that before anything.

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Yes, I have put -T option also, But trace is not generated.

I am trying to update database table directly from Output card, without using the MDQ file.
Is that possible?
My adpater command is like this

-DBTYPE ORACLE -TRACE ID2.dbl -CONNECT MyDB -USER user1 -PW pwd -STMT "UPDATE EMPDTLS SET JOININGDATE =sysdate WHERE EMPID = 'ID#'"

So here instead of using the MDQ file I want to update as Database Adapter Command.

Have anybody done this? Or is it possible in WTX?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: KK_WTX

Hi,

Map is throwing "Target not available" it means in the output database connection is not established.It is unable to update the DB.I have one doubt here you are using any DB functions like DBLOOKUP/DBQUERY,If you are using these functions no need to mention the query in the command line.Here you have to mention the credentials only.

Thanks,
KK.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: KK_WTX

Hi

Before running map,just check DB connection is working (or) not. You have a option called "TEST Connection",If it gives successful means no issues otherwise you have to check all settings.Because the connection is not established again it will through the same error "Target not available".

Thanks,
Kiran.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange