DSXchange

Hi wnogalski, SetJobUserStatus might be a built in routine by some of your other team in you site. You just need to create a routine which has the following code Call DSSetUserStatus(Arg1) Ans = Arg1 RETURN(Ans) So that the value will be set for the derivation as well (If requried).

Or the same Batch code can be written in a Routine in server job.
As mentioned, basically through Batch job, you can frame your own control using BASIC code. JobSequence does it by it self, by assembling the stages in the GUI.

Check the record delimiter defined in the source. It might be a case, where these newline character might be carried from the source. Check it by writing into a intermediate Sequential file stage. Check with od -db command.

10.267.160.49.29137 shows that 10.267.160.49 is your ip address and 29137 is the port through which the client is connected. You can cut the required field using cut command. If 10.267.160.49 is your vpn server address, it might be the case, all your client might be connected to vpn server and from ...

Hi, The log pretty much gives out the cause and the solution. You lookup LKP is trying to Converting nullable source to non-nullable result; fatal runtime error could occur . So you can use a modify operator to specify value to which null should be converted . Basically some of your field is been co...

Check the permission for RT_CONFIG471 in your project directory, by any change if that is been created by other user and if your current id dont have access to that file.

Hmm... Try to create a copy of the same job and Delete it. If that works the underlying config file and pointers might be corrupted for that job. You can then try an ugly approach by deleting from DS_JBOS and DS_JOBOBJECTS and if you find the RT_CONFIG471 and its log file you can delete it from unix.

Not necessarily, it can be even on Before/After SQLs. In the before SQLs of the input stage, you can insert the record with the start time as SYSDATE and current batch id as Jobparameter which is passed from JobSequence or the Main job control. And in the After job control populate you can populate ...

You can alternatively you to get the list of active users and process been used.
Or LIST.READU at Adminstrator clinet to get the list of process, Login Id and the jobs that been accessed. But it will not show you Ip address.

Yes, in server. As suggested, try without -ai or simply with -a. Sometimes the settings may only give out the port to which it is connected.

Hi Ritesh, You need two jobs. Job 1 read the table for the table name and pass it to the other job as JobParameter. If you search the forum, you can find lot many similar recent post of the same kind. You can either use UserStatus or write into a file and read it to pass the value as JobParameter. I...

Create a routine, and use a job to find the max and in transformer, call the routine to set the user status as the max value that you found out.

Hi Durga Prasad,
Try log out and log in again and check if you could do that.
It could be as you faced few days back. Check for the space available under /tmp or check the permission to the group or the user id, if it has been changed recently.

If the Invocation Is is not determined at runtime, you and pre determine the values and pass it as hardcoded or as parameter. And what makes you to assert that Job_Activity_2,3 and 4 runs one after other. You may find an entry with JobControl (DSWaitForJob) with Job1+2+3. The other logs will show yo...