DSXchange

Hi All, Can someone pls shed some light around how to accomplish the below logic in Datastage. I have an input file with the below values Input : --------- P1 P2 P3 I have another DB2 Table where i will have record with P1 value . The input record with value P1 is combined to P2 & P2 is combined...

Hi All - Is there a way we can read the Mainframe Tapes from IIS without landing the data into the UNIX server ?

Thanks
Synsog

Thanks Ray.

The issue here is, the password is generated in Mainframe & they will store this file in Mainframe system. I am not sure how Datastage can interpret this decrypted value.

Thanks again
Synsog

Hi All - Is there a way Datastage can validate a password value in a txt file which is in encrypted format ? My requirement is as follows, We have a external application whose password to connect to Database(DB2) changes very often. They will store the encrypted value in a txt file. I need to decryp...

the same code works with expected reult in 7.5 version .but where as in the 8.5 version it doesnt gives the desired out put

ya, its based upon copy book definitionand more over when i tried to convert to integer the derived columns that are mappped to binary column.still it doesn ot gives the correct result as of DS 7.5 version .

but the derived columns which have char data type comes from the mainframe file with EDCBIC character set and dataformat in Binary.pls suggest

In transformer, the data type is defined as binary ,where the mapped columns have char ,int dataype which conatins numeric values .pls suggest

Hi Andrew, yes we, have Ds 7.5 old server too. i had created a simple job by taking row generator stage with column datatype Binary and writing to text file. so the output data in the Datastage 7.5 is different as compared to datastage 8.5 . so this means the datastage 8.5 has bug int it ? or fix ne...

Hi Andrew,

even in the target database also , it shows the wrong values for DS85 load where as the DS 75 out put displays the correct values.

Hi All, we are migrating PX jobs from Ds 7.5 windows to DS 8.5 linux os.we have the datatype binary for one of the column. the incoming values are same for both the DS 7.5 code and DS 8.5 code .the output data mismatches in bothe versions.below is example and datatype is binary (20).please suggest. ...

Hi Team,

All production jobs started failing suddenly with below error in Datastage 8.7.

Error: "Could not connect to datasourceCommunication link failure".
Database : Netezza database 6.0.5

Before 1 hour all jobs were running fine.

Can anyone help us on this??


Thanks in advance!!!!

Thanks ray for the information.

Hi All, We are facing issue for Netezza connector stage in 8.7 Datastage. The Netezza Connector stage is not fetching records when we are using SPARSE lookup. It is running for long time but not fetching any single record. It ran successfully when we used NORMAL lookup. Datastage Version: 8.7 Netezz...

Hi All, We have DS 8.7 on Windows 2008 R2 Enterprise 1. Is is mandatory/recommended to create the the user "dsadm"? 2. If yes what is the advantage of doing this? 3. Is this user relevant only for Non Windows (Unix/Linux..) Env? 4. If we create this, is this a Windows user we need to creat...