DSXchange

Hi,

We have a requirement to filter out Japanese languade address records from the source when we extract and process records.

Is there any we can eliminate these records based on UNICODE values in those fields?

Thanks

Hi I have basic questions which needs to be answered to make proper Architectural decisions. I could not get any answers in documentation and I was wondering if any of you can shed some lights on this. Background: We have Datastage 7.5 (PX) and RTI installed and they are up and running on Solaris sy...

Thanks Ray,

We can use CFF stage to read VSAM files and Db2 API/ODBC stage to read data from Db2 on mainframe. But in thi USS how can we write data into CICS?

Hi Ray,

on the project Adminstrator 'NLS' is not enabled for only this particular project.

Like I said we NLS was enabled in the upgrade process. So for just this one project NLS was not enabled (When upgrade process was in progress, it was too slow for this project)

Thanks,

Hi, We did upgrade Datastage from 7.1 to 7.5.2. We did upgrade all the projects and Jobs. Also, when we upgraded we enabled NLS (earlier it was disabled). We foubd that there was a problem with one particular Project and only in that project NLS is not set. Is there a way to have NLS set for a singl...

Hi, I have Datastage 7.5 installed on Unix box (Solaris). I have requirement to read data from CICS and write write it back to CICS system after transformation. If I have MVS license can I write data into CICS? I know if we have Datastage installed on Mainframe it will generate COBOL programs intern...

Thanks Kenneth, That is very clear explaination. I am seeing 1 million records in the source is grouping to 700,000 records in the target. So it seems the final decision point is that which one is faster sorting the data or letting Aggregator build those Hash tables. In my case I found building Hash...

Hi, Is it Mandotory to Sort the incoming data when we use Aggreator Stage? I have scenario where in I am reading data from a Dataset then to Aggregator and the writing into Dataset . Source Data set is Hash partitioned with GROUP BY keys in same order. I am trying to process 1 million records with 6...

Hi Ray,

I will post the details tomorrow once I am in office.

But this was a known issue with client 7.5.2 and we got the patches from the support team.

Thanks,

I have client Datastage Designer ver 7.5.2

Even Server is Datastage 7.5.2 on Linux.

I dont think there should be any client incompatibility. Even it is, why only for that API stage when passing Env variables?

I saw all those different posts, it seems it is different scenario in each cases (but if you see closely it is related to API stage or Plug in stages). In our case I found out this is related to version of client. We have server 7.5.2 on Linux 3.0. I have client 7.5.2 on windows XP. So in this clien...

Well, I dont know Where exactly it is picking '#DSCAPIOP__DB2DSN#' from.

I am using Env variable $DB2DSN.

How can I correct this?

Thanks

Hi, I am facing problem when I try to execute a job to read from db2 database using Db2 API stage. Connection to Db2 Database is fine we are able to perform view data. We have problem when we tried to execute job with All the details in Db2 API stage passed as Environment variables. When we mention ...

Hi All, This issue is resolved after struggling for a week with all different options. It is resolved after we changed the PS1 command prompt to "$" from default PS1 command prompt. deault PS1 command prompt had [<hostname> @<username>]. We dont know what exactly was wrong with it. But whe...

Version compatability issue is stopping me from installing PX component on Db2 servers which is required to have Native stage connectivity. But having Db2 clinet installed on ETL servers I am using Db2 Clint to connect and talk to Db2 servers and my ETL server acts as a pure Client. So my understnad...