DSXchange

DSLogFatal() will stop the job from running and update the log file. DSStopJob() will issue a stop request, and if the job gets stopped then it will also have a status of aborted in the log. ... Thanks Arnd, One more small question, What is the difference between Abort and DSLogFatal functions. Ple...

Well in your DataStage help, you can just search for those worlds. DSLogFatal - It logs a fatal error message in that particular jobs log file and aborts the job. DSStopJob- As the name suggests, it sends a stop request to the DS engine. Thanks a ton guru, I have a small question, Suppose if the jo...

HI All,

I would like to know that what is the difference between DsLogFatal, Abort and DsStopJob.

What is the major difference between DSLogFatal and DSStopJob. I am totally confused with these two functions.

Why do we require Abort function, when we have DsLogfatal.
Please Help me

I have the following code i have to find the Names of all the jobs which starts with "A" and load into sequential file. Following is the after job routine in my job. When i ran it, its creating sequential file but when i view the same, it simply showing "SQL" as test in the file....

You can use DSExecute to execute UV commands. But its is also possible to retrive the informations like DSJobStartDate, DSJobStartTime... through DsMacro from JobSequencer itself. Hello Kumar, thanks a ton..!! I want to learn how to use DSExecute command to use UV commands. Could i get the document...

HI, Shall we use Datastage repository tables in the basic routines. I would like to calculate the current date of the job and i want to populate to sequential file. by executing the below query in the administratori am getting the current date value, but i would like to know, how to implement thislo...

kduke wrote:should be:

Code: Select all

code = DSSendMail("From:me@here.com\nTo:": Dummy :"\nSubject:Hi ya\nBody:Line1")

Thanks a lot Duke, Its working fine now.

Hi, I have a sequential file which contains Email Ids. I have to write a routine, which should fetches the email id from the sequential file and mail has to be send dynamically to that email id which has been fetched earlier. i have written a code like: $INCLUDE DSINCLUDE JOBCONTROL.H sleep 20 Dummy...

Hi,

I am using Exception handler, in my sequencer jobs. My jobs looks like

Exception Handler -> Job1--> job2.

When i am compiling this job, its throwing the following error
"Error Job has no start points defined"

Could any one help me.

ArndW wrote:Madhu - there is no need to continually post the same question; it has the effect that some people (myself included) just ignore the question and won't post a response. ...

HI Arnd.

I am sorry, Could you please tell me how to delete the post here

Hi, I have two jobs. First job will create a dataset, which is the source of the second job. My sencond job looks like Dataset --> Copy --> DB2. I am unsing Upsert menthod in DB2 stage. When i ran the job with 1 node it is runnig succewsfully. When i ran with 4 nodes it is throwing the following err...

Hi, I have two jobs. First job will create a dataset, which is the source of the second job. My sencond job looks like Dataset --> Copy --> DB2. I am unsing Upsert menthod in DB2 stage. When i ran the job with 1 node it is runnig succewsfully. When i ran with 4 nodes it is throwing the following err...

kumar_s wrote:What if you try SAME partition on both copy and DB2 stage?

Hi Kumar, I have given the SAME partition on both copy and DB2 stages. Still i am getting the same problem.

Please help me

Hi, I am using pivot stage in my job. The pivot runs in sequential mode as default. If i cahnge it to parallel, will my functinality affects or not. Shall i change it to parallel. My Functionality is : I am getting four fields from pivot input and writting one filed in pivot output. Kindly help me.

Hi, How many nodes availble in server? How many are configured? Is it running in sequential mode? What is the partition mentiond in copy and target db2. Hi Kumar, My dataset is coming from previous job which has 4 nodes. Each node contains 7 lacks of rows. When i am runnign the jobs with only 7 lac...