1.Please let me know how one should be sure whether C/C++ compiler is installed in the server or not.
2.What are the DS parameters need to be set to run a parallel routine.
3.Where to write the code of the routine in DS.
4.Please give me an example of a simple C/C++ Parallel routine code.
Thanks
Search found 47 matches
- Tue Sep 05, 2006 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Routine questions
- Replies: 3
- Views: 2138
- Thu Aug 17, 2006 1:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Storing duplicate records
- Replies: 3
- Views: 2002
Storing duplicate records
Using 'Remove Duplicate' stage we can remove the duplicates. Now since we can not have Reject link with that stage so how to collect (and store them in a file) the duplicate records that are being rejected.
- Fri Aug 11, 2006 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting record count from Transformer
- Replies: 6
- Views: 7805
- Fri Aug 11, 2006 2:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting record count from Transformer
- Replies: 6
- Views: 7805
Getting record count from Transformer
I have 2 source tables followed by Join stage(outer join),followed by Transformer stage which branches data into 4 output sequential files. Now I want to calculate the total records coming into Transformer stage and write it to a sequential file. I used a stage variable 'TotalCounts' in Transformer,...
- Thu Aug 10, 2006 7:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating Mainframe jobs
- Replies: 5
- Views: 2566
- Thu Aug 10, 2006 6:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Creating Mainframe jobs
- Replies: 5
- Views: 2566
Creating Mainframe jobs
Please let me know whether I can extract data from MVS database & transform it using a Parallel job or I need to create a Mainframe job for that.
- Thu Aug 10, 2006 4:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NULL Handling using Modify stage
- Replies: 2
- Views: 2000
- Thu Aug 10, 2006 4:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NULL Handling using Modify stage
- Replies: 2
- Views: 2000
NULL Handling using Modify stage
I want to convert any NULL values in column XYX to "NULLXYZ" using Modify stage. I used the following statement as specification : XYZ:string = NullToValue(XYZ,"NULLXYZ") But it is giving error like : main_program: Error parsing modify adapter: Error in binding: Unknown conversio...
- Fri Aug 04, 2006 4:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort stage with duplicate values in input
- Replies: 4
- Views: 2260
- Fri Aug 04, 2006 3:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort stage with duplicate values in input
- Replies: 4
- Views: 2260
- Fri Aug 04, 2006 3:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort stage with duplicate values in input
- Replies: 4
- Views: 2260
Sort stage with duplicate values in input
I have a sequential file as Sort stage input containing data like : empid 1 2 3 1 2 4 4 Now when I use the Sort stage on this input file with ascending empid (Allow Duplicate=True,all other options default), I get the following output empid 3 1 1 2 2 4 4 which shows repeating values are sorted but n...
- Wed Jun 21, 2006 4:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Running a SQL statement using parameter
- Replies: 4
- Views: 2442
Running a SQL statement using parameter
Can I do the following(dynamic building of SQL query) in a server job : I am using a DB2 UDB stage. In it output custom SQL I write : #SQL_STATEMENT# Then define the parameter SQL_STATEMENT as Select count(*) as all from ABC.X_CONTACTS where XID = 'RVH' Now when I run the job I get error like : An u...
- Tue Jun 20, 2006 1:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling a DS job from Unix server
- Replies: 1
- Views: 1318
Calling a DS job from Unix server
I have been using Director from DS client to invoke a DS server job.Please let me know the command to invoke a DS job from Unix server(also DS server).
- Mon Jun 19, 2006 5:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Accessing Unix/AIX environment variables
- Replies: 10
- Views: 4000
- Mon Jun 19, 2006 4:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Accessing Unix/AIX environment variables
- Replies: 10
- Views: 4000