DSXchange

Hi,

I am new to using XML capabilities of DataStage. I would like to know whether there is any limit in the number of rows that can be read in terms of count or Size? Say for e.g. there is a 2GB limit on DataSet?

Regards,
Sai

Hi All, I am trying to append to a sequential file in basic using seek command. But i am not able to achieve this. Can anyone please let me know how to do this? I have searched the forum as stated using the "OpenSequentialFile" keyword, but most of the content is protected. I just want to ...

Hi,

Using Dsjob is similar to using DSGetJobInfo, DSGetStageInfo. They will give me the individual stage names or link names. I want to get Stage names and the corresponding link names.

Regards,
Sai

Hi All,

Is there anyway to get the Stage Names and the corresponding link names within a job. I know that using DSGetJobInfo you can get the stage names and using DSGetStageInfo the link names. But given a job name as parameter i want the stage names along with their link names.

Regards,
Sai

Hi, I am not able to call the routine "Rep" which is a transform function in my job control. I get an error Rep never dimensioned which is because "Rep" is not getting recognized as a routine. Want to know how to call "Rep" in my job control. Hope i am clear. Regards, Sai

Hi Ray, The requirement is like this. I will have to capture the rows per second for all the stages in a job and write it to a file. I am trying to achieve this in a job control where i will accept the job name and get stages corresponding to the job and store them in a file. After this i am trying ...

Hi Ray,

I am traying to call a basic routine "Rep" which is a transform function. I am not able to call it by prefixing DSU. Can you please let me know how to achieve this?

Regards,
Sai

Hi,

Tried to call the routine with prefixing DSU in quotes. and is working fine. HAs gone through a sequner job to see how the routines are being called.

Ex 'DSU.RouTineName'(Arg1);

Regards,
Sai

Hi,

I did search the forum and one of the suggestions was to prefix "DSU" which did not help.

Regards,
Sai

Hi All, I am trying to call a user defined basic routine with in the job Control. I have tried to prefix the Routine with "DSU." while calling but still get the error "Never Dimensioned". From the error i understand that Job Control is not able to recognize the user defined routi...

Hi Ray, I was calling the following code after the job completes and so far it has yielded me the expected results i.e. the rows per second in the job canvas are matching the routine output barring decimal values. $INCLUDE DSINCLUDE JOBCONTROL.H hJob1=DSAttachJob(Arg1,DSJ.ERRWARN); Ans=DSGetStageInf...

Hi All,

Thanks a lot for your suggestions. Was able to capture the rows per second by dividing the link count with the elapsed time for that stage.

Regards,
Sai

Hi All,

Using DSGetLinkInfo we can capture the Link Count. Is there any way to capture the rows per second of that particular link that appear in the Job Canvas?

Regards,
Sai

Hi All, Both the Link Sort and Explicit Sort stage use the same "tsort operator", with an explicit Sort stage having more functionality. However, i have heard that in case of a link sort once the memory exceeds 20 MB, it dribbles to scratch. Where as a Sort Stage doesn't. Is this true? Reg...

Hi Ray,

Thanks a lot. I can't read most of the content as i am not a premium member. Can you please make the content visible?

Regards,
Sai