DSXchange

Hi Experts, After the discussion with IBM support team, we are planning to connect to i-series AS/400 thorugh odbc connection. :roll: As per the IBM documents DB2EE and DB2-API stage are Deprecated stages. We can't connect to i-series from db2 connector stage. So only option is odbc connection(where...

Thanks for the help.

Where can we add/find the Catalog TCPIP Node,Catalog Database ?
Appreciate all your help!

Thanks!!

We have addd the entries in .odbc.ini file and issue is resolved.

Thanks for the help!!

Thanks for the help.

There are multiple entries in odbc.ini files. There is also entry in odbc.ini for SQLServerTest.

Thanks again!!!

Hi Experts, We are trying to connect to AS/400 through DB2 stage.But when we trying to test the connections;its giving below error. Unable to connect to server DEV_AS400. We have open the ticket with IBM support and as per them we have to use ODBC to connect Datastage to DB2 on our AS/400. Is this t...

Below is the detail in our odbc.ini file:- [ODBC Data Sources] SQLSERVER_TEST=Microsoft SQL Server Driver [SQLSERVER_TEST] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss25.so Description=Microsoft SQL Server Driver Database=tempdb Address=MSSQL_SERVER and my uvodbc.config <SQLSERVE...

Hi Experts, We just installed the Datastage 8.7 in our Linux box. Right now we are trying to connect to SQL Server 2008 R2 through ODBC stage. I have added SQL Server database and server name in odbc.ini and uvodbc.config. When I am testing the connection from linux through DS_CONNECT, it unable to ...

Finally we are able to connect to Infosphere server. :D

The issue was linux server was not configured to allow http connection.

Thanks all for the help!!!

Thanks for the help.

I tried the linked which you mentioned... but it is giving same error message..

Do we have to again uninstall and install complete infosphere package?

Thanks again for all the help.

Thanks for the reply. Yes, I have re- started ASB Node Agent and Loggin Agent. But still the same error. :cry: ./NodeAgents.sh restart When I am accessing "http://<hostname>:9080" url on the server, its giving me SRVE0255E error ... SRVE0255E: A Webgroup/Virtual Host to handle/has not been...

Hi Experts, We have installed 8.7 Infosphere package in our linux box. But when I am trying to login to Infosphere Information Servre console from the client box its erroring out saying "Server not responding". :x I have checked all the 3 servers, infact I have stopped and again restarted ...

Thanks Sura for the clarification. So for capturing change data (immediately/directly) from the source database we need to purchase InfoSphere CDC, which will capture the changes as they happen and delivers them to target databases. Datastage CDC stage won't be helpful for this. :shock: Thanks again...

Experts- I have question regarding CDC. From last couple of years I am working in Informatica; so right now I am bit confused about the CDC. Apologies if my question is silly. Do we have to get different package(add on) for change data capture (CDC) in Datastage ? I know there is CDC transformation ...

You will get the answer in the below link:

viewtopic.php?t=117541&highlight=Interview

Why are you posting same question in new post??

Hi,

For the decimal data type you have to use "DecimalToString" function and target datatype will be LongVarchar.
Following is code which I have used:
Hope this will help you

Thanks!