DSXchange

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

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.

I am not clear about how to collect these.Will you plz elaborate.
I dbout due to partitioning I am not getting the correct count.
say there are 1000 input record counts
the variable doesn't show 1,2,3....,1000
Rather it is showing 1,2,3,...100,1,2,3,....
How to get rid of that.

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,...

So,extracting (using COBOL or SQL) MVS data into file & FTP that to some location can be done from Parallel job itself. Right?

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.

Thanks,it is solved

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...

yes...It is appearing correctly in sequential file..thanks

My target is a data set

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...

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...

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).

Hi ArndW, I even tried that to set the variables from within the DS batch & then tried to access the variables.That also didn't work.Here was the code : command1 = 'export sbpath=/MyProject/recent' Call DSExecute("UNIX",command1,Output,Status) If Status = 1 Then Call DSLogWarn("Co...

Thanks for the help. The problem was solved using 'UNIX' instead of 'NT' as shown below :- command = 'echo $PATH > /MyProjects/Path.txt' Call DSExecute("UNIX",command,Output,Status) If Status = 1 Then Call DSLogWarn("Command Failed","JobControl") End My next question is...