DSXchange

As already suggested job parameter is the way to go.

Add a routine Activity to the Master Sequence calling the server jobs. Pass the return value of the routine to all the 10 jobs as parameter.

Use DCount to get the number of occurences of double spaces.
Use Field to get the last field (which is no returned from DCount).

You don't need to write a function for that.

Open the RT_BP271 folder and check the files out there, you will see the code of the job there. The line number can be traced out there.

Go to Edit DDL tab and click the Create DDL button to generate the DDL statement.

I have no other option than using it

I guess you ar hitting the limit allowed for the max number of characters permissible.
Can't you just replace it with a function?

1.May I know how to stop the job if the job seems not completely stopped? In the above case,even though I stoped the DS services,the job cannot be stopped completely.This morning ,even I did rename the job and recompiled it,but it didn't stopped completely. If you have successfully compiled it, you...

hi

why no reply

What is batch SID ? and what is the use of creating it?

Ray.wurload r u there


mohan

You got a response from ArndW in less 2 hours time, what else you want?
Hey Ray, sombody is calling you.

Can anyone tell me how can we generate batch SID for the datastage jobs. If there is any routine then plz send it across it to me. I guess you are talking in terms of peoplesoft related product EPM!!!! It is nonthing but the sequence number genarated per run, i.e., for one run of a job one particul...

Possible options available: 1. Stop the Job from director (if it is still running). 2. If it is not running then possibly it has locked the resources and aborted. Run DS.TOOLS from your Administrator and release the locks held by process of the job. (This should release the lock on the Seqential fil...

Which version of Data Stage?
Was it 7.5.1a?
We also had simliar problem, for which an ODBC related patch was supplied by the Ascential.

instead Try with

Oops I misread your post, the files are all different!!! You can create three separate links from the Sequential File Stage (or three separate stages) reading from the 3 different files and can load into the target (assuming its a table) (If its a sequential file then you can not load the data in pa...

On windows machine you can find this file within the C:\winnt or C:\windows folder (depending on the OS).
But you won't be using this file if it is a client machine.

im thinking of the solution is using on multiple instances. Is it this is only approach that i can develop? Yes this is the only external parallellism that you can introduce. If you want it within job itself, you can think of having it through the different paths for the 3 countries or explicit use...

Split the Source into 2 links one for update and one for Insert and put each of them into a sequential file. How do i be able to diff between the records to be inserted and updated. You can do this by including a target table lookup, if lookup passes it should go to the update link else the insert ...