DSXchange

Hi All , I have finally managed to connect using the hive connector . I managed to locate the jar file for Hive which was the ISHive.jar file under the ASBNode/lib directory in datastage. The contents of the config file is as follows :- -bash-4.2$ cat isjdbc.config CLASSPATH=/opt/IBM/InformationServ...

Hi All, We have recently connected to the Hive database from DataStage using the ODBC Connector Stage. However we are having issues when we are trying to use the Hive Connector stage. I am not exactly sure as to how to set up the isjdbc.config file . I have read the documentation however I am still ...

Thanks for your suggestion. Our DBA has helped us in creating new database instance and he is populating required tables using a stored proc from orignal database having "dot" in its name.

So this resolves it..a workaround though

Hi All, We are on datastage v9.1 and trying to pull data from SQL Server. Connectivity has been established successfully via .odbc.ini and uvconfig. Target SQL server is hosting five different databases on it out of which 4 has "dot" in their name while one has "underscore". We a...

Thanks so far for reponses We are running IE V.8.07601 Major point I forgot to mention is the Win 2003 server jump host where the IBM clients are installed has access to production and staging datastage on two different redhat servers Information Server Web Console displays correctly against prod bu...

Job Type: N/A OS: Windows 2003 Server : Datastage Clients OS: Datastage Redhat Enterprise Linux server 5.4 I am getting an error when using these two pages of Web Console . Other pages are fine ERROR ====== Information Server Web Console displaying "<" characters WHEN I access the datastag...

Hi all,,, we have used the above routine however we would like to make this case insensitive. Is it possible to change this code slightly ???

Hello Ernie Ostic Thanks for the response. The version that we are working on is 8.1. I did an analysis as to why it was not going past the transformer in the second Job where as it the column lineage was successful in the transformer stage of the third Job. I found out that the transformer stage co...