DSXchange

Hi, I am trying to connect to DB2 on mainframe from Datastage installed in Windows 2003 Server. I need to be able to connect to DB2 on mainframe through DB2 API stage. Can any one of you please guide me through the procedure of setting up this connection. Also, how can we set up ODBC connection to D...

Hi,

I wanted to know if Datastage 7.5 could be installed on Unix AIX 5.3 (I know it could be run on Unix AIX, I am was not sure aobut version).

Also does datastage provide any interfaces to Trillium and Sonic ESD?

Thanks

Hi, I am trying to load a table with Oracle enterprise stage using LOAD option. But I am getting following error. Oracle_Enterprise_10,0: Call to sqlldr failed. Return code = 256Please see loader logfile: C:/Ascential/DataStage/Scratch/ora.4132.640000.0.log for details. Below is the entry of the log...

I have Datastage installed on my laptop and also Oracle 10i Personal edition installed on the same. I am working in this mode for the first time. How should I mention the server name in Oracle Enterprise Stage? Typically we used to provide the server name and database name in the 'Remote Server' Tab...

Thanks, Istsaur and Ray, I was able to install Oracle properly without any error. I have Datastage installed on my laptop and also Oracle 10i Personal edition installed on the same. I am working in this mode for the first time. How should I mention the server name in Enterprise Stage? Typically we u...

Thanks for the reply Istsaur, Does installing SP2 solve the problem with this ODBC connection? I will update my Xp with SP2 and let you know the result. And about your earlier post for Oracle enterprise connection. I found following detailed reply 1. cd to your C:\Ascential\DataStage\PXEngine\instal...

Hi, I have installed Datastage 7.5x2 and Oracle 10i on windows XP (Server and ). I am able to run and compile datastage jobs. I am facing some problem setting up Oracle connection from Datastage. Following are the issues that I am facing. 1. I set up an ODBC connection throuh Control Panel -> Admist...

Hi, I have installed Datastage 7.5x2 and Oracle 10i on windows XP (Server and ). I am able to run and compile datastage jobs. I am facing some problem setting up Oracle connection from Datastage. Following are the issues that I am facing. 1. I set up an ODBC connection throuh Control Panel -> Admist...

Can anybody give me details how Datastage Enterprise connection is made to Database (What kind of connection is this?, What set up is required at Unix side?). Are these set up at Server level or project level? If we create a new project in the existing server (where other projects are created with p...

For below approach to work, we need to run Transformer in sequential mode right? Hi... I think I know what you're saying now. You have a multiple set of records that contains detail records and one trailer record that resume the detail records of your set. And you want to validate that the trailer r...

Hi All, we were able to solve this problem and here is the solution: When I manually selected node map constraints in Teradata Enterprise stage (stage -> Advanced-> Node map constraints) to available nodes (i.e. node1,node2) it went fine and inserted records into the table. Any body knows how exactl...

On teradata Enterprise stage I have Auto partition.

Configuration file does not have any node defined for Database, in this scenarion how can teradata load can happen on multiple nodes? How is data partitioned (if on different nodes) when datastage loads it to Teradata.

Well, Dataset is already partitioned in previous job. I am keeping 'same' partition in dataset and copy stage. In Teradata enterprise stage it is auto partitioned. My configuration file has 2 nodes, but error below says It has 3 operators: op0[2p] {(parallel Data_Set_44) } op1[2p] {(parallel Copy_45...

Hi, I am trying to load a Teradata Table from Datastage PX job (Unix platform). Job reads data from a Dataset (I am able to view data from Dataset) Copy stage drops some column and changes column name and send the records to Teradata Enterprise Stage. Teradata Enterprise stage is loading Teradata ta...

Hi I am using an UDB enterprise Stage in UPSERT mode. (job has only 2 stages, read from dataset and and load into UDB) When I run the job with same data 2 times, after the second run log still shows the records inserted more than 0 (very high number about 20% of total records). When we are using UPS...