DSXchange

I tried using the "SELECT COLUMN_NAME.NEXTVAL FROM dual" it doesn't work. Enabled the trace .Here is what i see in dbl file ************************************************************* <4184-3696>: Validating the adapter command... <4184-3696>: Database type is Oracle <4184-3340>: Partici...

Just out of curiosity.why do you want to do that ? .can you provide more details?

Thanks for the reply.Iam very to new to the product.where do i set the Trace [-T] option.

Thanks for the reply guys.Issue was with the Database permissions.
Accidently my Database permission were changed ,which gives read only[SELECT] access to DB,which i did not pay attention.
After changing the permissions to read/write everything works fine.

Hi, I was trying to access SEQUENCE.NEXTVAL using DBQUERY function. My Target is Oracle Database.I tried following syntax ,For some reason none of them seems to work. TEXTTONUMBER(DBQUERY("SELECT TEST_SEQ.NEXTVAL FROM DUAL","-MDQ C:/test.mdq -DBNAME test" )) TEXTTONUMBER(DBQUERY(...

Hi , I created a Map with one Input Card and one Output Card.Source for InputCard is File and Target for Output Card is Database.It worked fine until i changed my DB password.Since then Map does not run any more,it gives me error "Target Not Avaialble" .I was using MDQ file to connect to t...

I was able to generate the type tree atlast ,when i switched Database Connectivity from ODBC to Oracle Adaptor.But I see bunch of warnings "Warning 34 reference 5: Overwrote existing type (and possible subtree). Warning 34 reference 34: Overwrote existing type (and possible subtree). Warning 34...

Reason for using ODBC is iam having problems making the Oracle Adaptor to work in DBInterfaceDesigner.I'm getting "ORA-12154:TNS:Could not resolve service name" Here are my Oracle settings DatabaseName : testDB Adaptor : Oracle Paltform : *** Iam not sure whether this is client platform or...

Hi, I created a map with one input and one output card.Source for input card is File and target for Output card is Database.I already created xx.mdq file to generate type tree for my target table.when i tried to build the map iam getting following error "M1013 ERROR: Could not retrieve database...

For some reason i was having problem connecting to Oracle using the Adaptor.So I was using ODBC to connect to my remote oracle database.Iam not sure whether ODBC is causing CLOB handling issues.

Thanks for the reply.Can you tell me how can i generate a type tree for table skipping a specific column.If there is document, if you can point me to that would be ideal .Iam looking at database interface designer guide ,but i dont see any such option.


Thanks
Jack

I did tested the database connection.I was able to create type trees for tables with no "CLOB" .
BTW which Database did you used to created the type trees for "CLOB" ?

Hi , Iam new to Tx .Here is the scenario i was trying accomplish.My Target is Database.I was using Database Interface Designer to generate type tree from Table.One of the Tables has "CLOB" as datatype .Database Interface Designer is complaning "Definition Table XXXX could not be acces...