DSXchange

Stop fretting that you are getting multiple values for single records (which is the "more than 80,000 records" being manifested). Imagine the left input has 80,000 records and the right input has t ... I am very sorry for not giving full information at a time.. I have also noticed that in...

[quote="ray.wurlod"]Stop fretting that you are getting multiple values for single records (which is the "more than 80,000 records" being manifested). Imagine the left input has 80,000 records and the right input has t ...[/quote Sorry forget to give you some more information The ...

Stop fretting that you are getting multiple values for single records (which is the "more than 80,000 records" being manifested). Imagine the left input has 80,000 records and the right input has t ... Ray, The same logic i have not used hash partitioning the default is auto then i get th...

Sure, whatever you are joining to from your "source of 80,000 records" is making multiple joins to the other side of the join, at least for some of the records (i.e. a one-to-many relationship). Thanks for your information. But my requirement is not to get multiple values for the for sing...

Simply getting more records out of the join than went in isn't an error, per se. Please explain the nature of the "join" you are doing. ... Thanks alot for your resonse. I am using and left outer join wherin my source is data base and other is Dataset. My requirement is that from the sour...

Hi All,

I am using an join stage with Hash partioning. if the source records for 80,000 records then i am getting 90,000 records as the output from the join stage.

Can anyone please guide me what mistake has been occured.

Please suugest and let me know if you any require any one details on this

Call DSLogFatal is not available in a shell script. It is only available within the DataStage BASIC programming language, which only executes within the DataStage run machine. The same is true of $I ... Thanks alot Ray, I am actually capturing the log of bcp and searching if it fails then i need to...

Hi all, I am using the below unix script is it possible to call DS functions in the script. Please guide me on this. #! /usr/bin/ksh # Load into od_trans_map_output table for HALO Transaction Mapping #$INCLUDE DSINCLUDE JOBCONTROL.H echo $1 $2 $3 $4 $5 $6 isql -U$4 -P$5 -S$2 <<-EOI1 use $3 go trunca...

Hi All, Can anyone please guide me how to use the open and close command in the ODBC stage. My requirement is that i have to drop the index and truncate the table beforing inserting the records and once the records are inserted i have to recreate the index So i have used the open and close command b...

Definitely with Craig on that one... what changed between the two jobs data-wise? Did you definitely use the same input data? Moreover, was the data you loaded with job1 actually removed from the target before re-running the data in with job2...? Apologies if I'm asking the obvious, but best to sta...

Hi All, Can anyone please guide me on the below issue. I have a job1 to insert records into sybase stage using server job , while inserting 1million records it took around 1hr to complete without any WARNING Similarly i designed a job in Parallel job2 and inserting the same 1million records and it t...

(1) Write a after job sub routine to capture the status of the job sequence. Call dsjobfatal() iff the job sequence is finished with warnings. This will abort your job. (2) In the job sequence properties, enable the check boxes "Add check points so that sequence is re-startable". HTH Can ...

(1) Write a after job sub routine to capture the status of the job sequence. Call dsjobfatal() iff the job sequence is finished with warnings. This will abort your job. (2) In the job sequence properties, enable the check boxes "Add check points so that sequence is re-startable". HTH Than...

Hi All, Can anyone please guide me How can i achieve the below senario's 1. how to handle the sequencer job if it finishes with the warning in that case it should Abort the job. 2. If we have Sequencer job which runs 5 jobs together , incase if 4th job aborts then we need our sequencer to re-run onl...

chulett wrote:It's not fixed-width. Declare it as a normal csv file that just happens to have a single column in it. ...

Thank you so much chulett,

Can you please guide me what format needs to implemented in this senario.,

This is very help full for me.