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
Search found 83 matches
- Mon Apr 23, 2007 3:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filtering out records based on UNICODE values
- Replies: 2
- Views: 1465
- Wed Feb 14, 2007 11:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Connectivity to JDBC and JMS
- Replies: 7
- Views: 6301
Datastage Connectivity to JDBC and JMS
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...
- Wed Feb 14, 2007 6:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Writing Data into CICS (Mainframe)
- Replies: 3
- Views: 2086
- Wed Feb 14, 2007 3:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Upgrading NLS to a speicifc Project
- Replies: 4
- Views: 2348
- Wed Feb 14, 2007 2:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Upgrading NLS to a speicifc Project
- Replies: 4
- Views: 2348
Upgrading NLS to a speicifc Project
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...
- Wed Feb 14, 2007 2:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Writing Data into CICS (Mainframe)
- Replies: 3
- Views: 2086
Writing Data into CICS (Mainframe)
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...
- Thu Jan 18, 2007 7:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Requirements for Aggregator Stage
- Replies: 3
- Views: 4332
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...
- Thu Jan 18, 2007 6:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Requirements for Aggregator Stage
- Replies: 3
- Views: 4332
Requirements for Aggregator Stage
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...
- Thu Jan 11, 2007 11:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Reading from Db2 database using Db2 API stage.
- Replies: 11
- Views: 5228
- Thu Jan 11, 2007 6:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Reading from Db2 database using Db2 API stage.
- Replies: 11
- Views: 5228
- Thu Jan 11, 2007 6:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Reading from Db2 database using Db2 API stage.
- Replies: 11
- Views: 5228
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...
- Thu Jan 11, 2007 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Reading from Db2 database using Db2 API stage.
- Replies: 11
- Views: 5228
- Thu Jan 11, 2007 4:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Reading from Db2 database using Db2 API stage.
- Replies: 11
- Views: 5228
Error Reading from Db2 database using Db2 API stage.
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 ...
- Thu Jan 11, 2007 3:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage PX Install Issue
- Replies: 8
- Views: 7163
- Tue Jan 09, 2007 10:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Load mechanism with ODBC Enterprise Stage
- Replies: 9
- Views: 4216
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...