DSXchange

As I have dynamic tables in the RCP job. So I assume, I will have to read each and every schema file with proper table structure to get decimal field and use sed/awk command to suppress these zeros. And all this activity has to be included in a loop at sequencer. This seems to be a tough approach :(...

Hi ,

Do you mean to use sed/awk command in execute command stage at sequencer level. Just wanted to confirm as these are RCP jobs.

Thanks in advance.

Hi Ray,

I was not able to see your complete reply. Can you please post it separately.

-Swapna

Hi All, I have a RCP enabled jobs for dynamic DB tables. So for every run my table changes. There are some tables which has decimal field and my output is a sequential file. I need to find a way to suppress zero for these fields either at job or sequencer level. Also I am not using schema file. Can ...

Anyone, Kindly help me with my query above?

Yes all 40 went into the target and job finished with no warnings.

Hi All,

I have a multiple instance job. My RCP is turned on through all the links and the job property, there are 40 rows flowing through the job still i can not see any output in the file.

Can anyone help with that?

Thanks. I will try.

I used "wc -l" in command line instead of "find" and searched if the file created is more than zero byte. So depending upon whether the file is zero byte or greater than that we would direct our o/p to desired link. Reject file is created in both the scenario whether we have reje...

Thanks for reply.The problem was with find command. Although it does return values 0 &1, but somehow it is not working.When i tried with other option it worked.

Hi All, Scenario : I have to search a reject file in one of the unix path/directory after one job has run. If the reject file is present then the job sends a email notification to users with the reject file. If no reject file, then it sends a success email. Solution: I have used Execute Command stag...

This job runs on 8 nodes. I tried to increase the buffer size in sort stage by setting auto-buffer , but it is not helping. Actually this is one job of the whole interface, whereas the whole interface is taking 3hr 45 mins to process 88 million records, this job itself is consuming most of it. Busin...

Hi All, I have a job which is processing around 89 million records. The job desgin is like this : Seq--->Transf--->funnel--->sortstage--->Transf--- has 2 output---(seq,xml) until sortstage it takes 30mins. But for sorting this huge volume data it takes 2 hrs 15 mins. :cry: Can anyone help to reduce ...

Hi All,

I want to know how can I use stage variable in DS v 7.5.3 for getting the row count of total no.of records coming out of input link on one primary key. Can anyone help !!

Swapna

Alright Craig.Thanks for info, I will try that tomorrow once I go to office, and if I stuck up somewhere I will let you know. Hey btw do we have any way of having Datastage installed at our WAN/LAN home server ?