DSXchange

Problem: The current user does not have read permission on the file; or the file is empty. (CC_OraUtils::getFileSize, file CC_OraUtils.cpp, line 1608) Solution: if you are using the Oracle Connector, and you are using the custom SQL query to extract the data from Oracle source, please select " ...

Doing the Test connection on the stage I get "The connection failed" - other times I will also get doing this test "system resources exceeded" - I have been at other sites where the test connection option alway failed - the work around - option was not to be used I have now chang...

In all my runs of my test job the error I get is DRS_Connector_3: Error when checking operator: Caught unknown exception during wrapDescribeOperator(). As part of testing I have changed from using a connection_string to using dsn and the test job work So the issue now focusses DRS stage using a conn...

Quoting did not change the error message. Could someone please provide an example of the text that enter on each the properties page and columns page of the DRS_connector stage - An example connecting to an Excel odbc would be great but any working examples would be appreciated Thanking you all in a...

I attempting to do a dns-less connection to an excel obdc has any one done this using a connection string like Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\directory; Can you provide a simple example of how you used it because I am at a lost how to use it Tha...

I am attempting to read a single data value from Excel (Column heading Ready_ Status) with DRS_connector stage Connection string Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=790;Dbq=F:\Data\EDW_DEV\Import\ETL_DATA.xls.ETL_Data;DefaultDir=F:\Data\EDW_DEV\Import;READONLY=TR...

Just a bit more information.

Connecting to an unsecured service works with no problems.

Hi All, Has anyone had any success using the Web Services Client to connect to a web service on a different domain. I can connect to the service using SoapUI but when I try using DataStage I get the following error: Web_Services_Transformer_3,0: Error: 0026`:`com.ascentialsoftware.wsclient.ServiceIn...

I am aware of larger companies (AMAZON for example) that have made the move of replacing their HDD with SSD. For our purpose it would be mainly for temporally storage due to the high throughput and extremely low access times. For example the OCZ Z-Drive R4 models use the PCIE bus (x8) and reach 2800...

Hi, We are looking at speeding up our DataStage jobs with the use of SSD technology (enterprise SSD). Our main bottleneck is the Disk I/O, so the idea is to try and decrease this bottleneck. We would mainly use the SSD for Scratch/Temp/Sorting. Has anyone implemented SSD's with Information Server ? ...

Since DataStage requires .Net 4, I would use this Windows SDK (Microsoft Windows SDK for Windows 7 and .NET Framework 4) http://www.microsoft.com/download/en/details.aspx?id=8279 I would also suggest to install Visual Studio 2010 followed by the Windows SDK (link above). Don't forget to add the INCL...

Hi, This is my first post, so be gentle with me (lol). Here is our environment:- OS: Windows Server 2008 R2 Sp1 (64bit) and InfoServer8.5 with Fp1 (64bit). Instillation Path D:\IBM\InformationServer JRE and JDK (64bit) installed on Windows (D:\Java\jre6_x64 and D:\Java\jdk6_x64). We are looking at t...

Blaz,

Are the datasets sorted? if they aren't, then there will be a lot of records not matched.

Hi Folks,

Has anyone figured out how to use a PL/SQL code as a query in an oracle connector stage? Have gone through the manuals but couldn't find any examples or further instructions on it.

thanks

Hi James,

That's it! It worked.

Now, tell me where in the documentation you found that???

Cheers