DSXchange

Hi, We are using DataStage to connect to DB2 on AS/400 machine. The connection is established using port 446, but the returning port from AS/400 is random, which is sometimes blocked by the firewall on DS server. Since disabling the firewall is not an option, we are looking for a way to "tell&q...

How exactly are you 'calling a procedure in another server'? Hi, We exeute: call qsys.qcmdexc('CALL .....',xxxxxx) in the "Before" section of the DSDB2 Stage's SQL tab. Again, this is working fine on the OLD DS server. We didn't modify any job. So we think this has something to do with th...

Hi, We have just upgraded to a new DS server and we encounter a strange problem: DS is calling a procedure in another server (AS/400), and waiting for it to respond. After 2 hours of wait, it aborts for connection timeout reason. When looking at the AS/400 log file, we see that it returned an answer...

I can see the XML stages On my client when I connect to the old server.So It is not a client problem

Hi, I have installed Datastage version 7.5.3 on linux server. I cannot see the xml stages on the designer. In the install log I see that I got this error : "Installing Plugin package 'xmli' in project 'template' This directory does not contain a Datastage package. Aborting package instaliation....

Hi,
Does SAP Pack support loading data from the Datastage to Z tables on SAP (ZBapi)?

thanks
Moshe

Hi all, Our client is consider to combine his 3 Linux datastage server (two of them are "sus" and the third one is "red hat") to only one windows 2003(64 bit) server. Do you know if there is a performance issue between Linux and windows servers? I know that I need to change the O...

Hi, I have a server sequencer job that is running in a loop, creating invocation name by the $counter. The sequencer builds of 3 jobs: 1. write to an hash file one record. 2. Simple transformation job reading from DB and writing to another. this job get a parameter from the function "UtilityHas...

Hi all, we have instal the RDB oracle driver(version 3.02). the test connection is successful. In the designer I create a job that read a table by the ODBC stage.I defined the rows of the table manualy. Then the job run and finish successfuly. My problem is to bring the metadata. When I try to impor...

Hi all, I have some questions 1) Does version 7.5.1 supports working with SQL Server 2008 ? 2) Does version 7.5.1 supports working with server 2008 operating system? 3) Does version 7.5.1 supports working on a server with QUOTA processor? 4) Does version 7.5.2 parallel can work with oracle 11.g than...

Hi, Our client is working with DB2 (as4000) vesion 5.4 on linux envirnment. They are reading and writing to the database with the DB2 UDB API stage. when I tried to use the DB2 UDB LOAD stage I got the next error message : "SQL1325N The remote database environment does not support the command o...

Hi everyone, I ran into a strange problem, upgrading from 7.5 to 8.1: When I run a 40-row lng, complex custom SQL statement I receive an Abnormal Termination. When I cut down the query length (by deleting some CR/LFs), it magically works fine! This never happened in 7.5, only in 8.1. An ideas why th...

Hi everyone, I have the following very simple job: Seq file -> Sort -> Seq file The source file contains a list of decimal values that needs to be sorted. When the type of the column is set to Decimal , the output results in "-Infinity" in each row, instead of the original values. When I c...

<ROOT> <BILL> <BILL_INFO paymentDueDate="2008-06-15" billSequenceNo="000000000003" billerId="8888888888" billerName="STP" billNumber="000000000003" version="0001"> <BILL_DATES billEndDate="2008-06-01" billStartDate="2008-06-0...

Hi, We have a process that read XML file(by XML input stage) and extract some attributes and 1 element to output file. The process was working on Windows environment. But now in UNIX it is not working. The attributes are written to the output file. But the element is not written and it is empty and ...