DSXchange

Server jobs are server jobs...they run in the server engine as always. They will not use a parallel configuration file because they do not utilize the parallel engine. Parallel jobs run only on the parallel engine, except for those instances where you can use a BASIC transformer or other server-bas...

Hi, Is there anyway that we can use the above code in Sequence job or do we need to use this only in individual job. If i can use it in sequence how can we use it in sequence as there is no option called after job subroutine. And can anyone tell me if i want to delete the file which is created from ...

Hi , As we can run the server jobs in Enterprise edition , then what is the configuration file that it is going to be when we run the server jobs in Enterprise edition . And when we run the server jobs in Enterprise edition , then is it going to compile in Basic language or in C++ compiler. And can ...

Hi craig,

Can't we do it through parallel job?

Find the number of rows that are going into the reject link and use DSSETUSERSTATUS of the row count and keep the job in sequence and trigger to send an email with the user status if it is greater than zero.

Kiran , the code is $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 JobHandle = DSJ.ME JobName1 = DSGetJobInfo(JobHandle,DSJ.JOBNAME) JobStarted1 = convert(" :-","_",DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP)) JobEnd1 = convert(" :-","_",DSGetJobInfo(JobHandl...

Hi craig,

In genral when we talk about 2 readers/node and no. of nodes are 2 then no. of invocations or copies of a job are 4 each one sharing the workload and transforming their share of the data?

thanks in advance

Do you have parallel (Enterprise Edition) installed? If so you can use UNIX commands on Windows. Otherwise you can create an after-job subroutine in DataStage BASIC that opens file using OpenSeq, ... Hi ray, we have only server edition and we dont have paallel edition installed. Thanks in advance

Hi , Is there any command that i can use in after job subroutine to delete a file if the rows are zero. I mean for unix there is something like `cat filename | wc -l ` -eq 0 to delete a file using after job subroutine with DSexecute f the rows are zero Is there anything similar to this kind in windo...

Hi Kim,

I have no idea about these ETLStats. Can you explain me little bit about these.

Thanks in adavnce

hi craig , I gave the valid path as input and also has the access rights. when i tried to create a file in the routine and tried to open the file in the directory i am getting an error Failed to open the directory, but the File is creating but getting an error, instead if i give directory path and f...

hi, the code to store jobname and time is $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 JobHandle = DSJ.ME JobName1 = DSGetJobInfo(JobHandle,DSJ.JOBNAME) JobStarted1 = convert(" :-","_",DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP)) JobEnd1 = convert(" :-","_"...

Hi , Kiran this code is to write the log into file $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 Suffix = ".txt" JobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) JobStarted = convert(" :-","_",DSGetJobInfo(DSJ.ME,DSJ.JOBSTARTTIMESTAMP)) FileName = JobName:"_":JobSta...

Hi ray ,

but i am getting the error in code saying failed to open the directory,

is this error because of write syntax?

thanks in advance

Thanks ray,

I will try to use the correct syntax fo write and see what is the result i am going to get and will update.

Thanks in adavance