DSXchange

Hi All, I have a job, which extract data from MSSQL database server using ODBC enterprise stage. In the extract query I have field called NAME which is varchar (50) in the table and in the job I have defined it as varchar without any length. Now the issue is the data in this column is getting trunca...

The best solution is to upgrade to version 8.5, where there's a totally re-architected XML Transformer stage (in the parallel canvas). Otherwise track down a copy of XML Best Practices. (Search DSXchange to find one.) It's the issue of length specified for the column was shorter then incoming messa...

Hello, We got a job with three stages. MQ -> XML input Stage -> Sequential file We are trying to process a file of size 27MB. Error: srcCBXCurrRatesWeekly_ESBEx..XI_CurrExRateWAREBO: Xalan fatal error (publicId: , systemId: , line: 1, column: 10000000): Invalid character (Unicode: 0x0) I tried to ch...

Hi, When we are trying to run a job in production, it is running till some extent(stages) and after that it is not writing any logs but the status is still showing as running. Below is the warning which is present in log : rtpexecutil.signalHandler(int)() at 0xdae0df6c Can some one please help in le...

Thanks Ray for clarifying!!

Thanks Prakash and Ray. Ray, When you say "Re-partitioning is almost guaranteed to destroy parallel-sorted data's sorted order.", i guess you mean to say if the input was a dataset containing parallel sorted data. Correct? In my scenario, since i am reading a csv file in a sequential mode ...

Hello, I have a sequential file with 2000 million records which is already sorted on key1,key2 and key3. I am reading this file using a sequential file stage running in sequential mode and then hash partitioning the data after reading on Key1. Seq stage -> copy stage (input hash on key 1) -> Dataset...

We have a scenario where in we need to read a message from a queue as soon as it is in and process using datastage. Is it possible to trigger datastage job which reads a message from this queue as soon as it is in queue. or do we need to have a separate trigger mechanism

hamzaqk wrote:do you have TPT installed on the server?

Yes TPT is installed.

Hi,

Yea, I've defined the metadata in job as-is. Any information regarding the error i've posted.

Hi, Yes. And i've read in a blog yesterday that immediate read works in sequential mode only. I've tried a sample job using bulk mode to read data. I'm getting an error. Error info - Teradata_Connector_0,0: [IIS-CONN-TERA-005004] RDBMS code 21012: Could Not Find Message Catalog opermsgs.cat SQL stat...

Hi, No the job did not abort. Its completing normally. But the teradata stage is running in sequential mode. I've monitored the job in Director. For other parallel stages apart from teradata, it showed operator name X 2. example: peek x 2. It means it should be running on two nodes. Also in the logs...

Hi, I'm using teradata connector to read data from teradata db. I have gone through documentation and came to know that to achieve parallel reads parallel synchronization property has to be set. I'm using a 2 node configuration. When i tried reading in immediate mode i'm not able to acheive parallel...

Hi,

I am using DS v8.1 on UNIX. I need to access DB2 database on mainframe. Is it true that DB2 Enterprise Stage can not connect to DB2 on mainframe. Is DB2 API stage the only option i have to connect to DB2 on mainframe.

Thanks in advance.

Hi

Can anyone share the full form of APT?

Thanks.