DSXchange

Hi We are looking to add a "continuous delivery" model into our current SDLC. We are about to choose a new version control system. We are currently looking at git and RTC. Does anyone have any good or bad experience with Datastage projects and git? git seems to be an ok SCM tool but just w...

Hi, I am using a Column Import stage to read EBCDIC data. The stage reads in one big column and produces many smaller columns from it. One of those is a packed decimal field which contains EBCDIC spaces (ie 40404040). So I want to use the "default" property on that field to default to null...

Hi, sorry if this has been covered - I had a good look but didn't see anything. I am reading an fixed-width EBCDIC file into Datastage using CFF stage. The file has a field indicating record type (header, details or trailer). The first 500 bytes of each detail record are defined the same (in the cop...

yes, we are using LongVarChar in Datastage in the working env and the problem env.

The CLOB size in DB2 is 4194304

Surely it's some config setting that is different across our environments? I'm guessing something related to the DB2 interface ... what are the relevant config files?

Thanks, the credentials are all correct. The problem seems to be that one of the fields being queried is a CLOB. When I remove that field from the SQL query, there is no error. So since there is different behaviour across environments, maybe the DB2 interface is configured incorrectly in one ... whe...

A job which reads from a DB2 table fails in one environment while the same job succeeds in another environment. The error in Director: DsStag3TransactionHistoryImage05..db2_service_action: Error occurred during link open processing. DsStag3TransactionHistoryImage05..db2_service_action.DSLink1: DSP.O...

Hi We are using the Oracle Enterprise stage to read and write to our database. Is it possible to roll back transactions in Datastage if a sequence fails? ie in the sequence job1 writes to db, succeeds job2 fails for some reason job3 never starts because job2 failed Is there a feature in Datastage wh...

eostic wrote:Can we assume that these two environments are also the exact same operating system?

Yes they are both AIX.

eostic wrote:Patch levels maybe?

The environments are at the same patch level which is "no patches". We will look at installing the fixpacks. We're running Datastage v8.1

Does Xalan get installed with Datastage?

How can I check the version number of Xalan on AIX?

We have two environments with Datastage 8 and the XML plugin installed on both. I have a job which uses the XML Input stage to read in filepaths from an External Source stage. It uses these filepaths to read in XML file content and then loads that XML content on to a queue. The same job works fine i...

Is it possible to see a log of all the sessions (username, computer name, time of use) using Datastage Designer in the last week?

What about seeing who modified what jobs? That is what I'm really interested in.

Thanks.

Thanks. Number of records per project:

Proj1 119

Proj2 135

Proj3 115

Proj4 115


Projects are ordered from newest to oldest. We are using Proj2. Our key plugin stages are related to XML and ODBC

I exported the job, deleted it from the repository and imported it back but the same funny powerplug is still there. In the XML source of the export the offending stages do have valid stage types. No, it's not all XMLoutput stages that changed like this - most remain unaffected, in the same job. Als...

Our Datastage 8 installation has been doing compilation progressively slower in the last month or so. We have been writing more and more jobs and they have been getting bigger but we have split them recently to reduce their size and hopefully their compile time. But the compile time is still too gre...

I opened a local container in a parallel job and some of the stages had changed from ODBC or XMLout stages to "plugin" stages, now appearing as electrical outlets, if you can picture that. These stages appear to be the same as before when I open them. But I can't copy them now because this...