DSXchange

[quote="ray.wurlod"]DSR_ExecJob is a helper subroutine. It's called when you submit a job run request from Director. Chances are that the job name or some aspect of the job's configuration can not be found because Repository indexing has become out of date or, as Arnd suggests, permissions...

[quote="ArndW"]Sunshine, the DSR_ExecJob() routine is called at runtime, so it must happen when you try to execute the job from the Designer. Have you checked you director log for this job are an aborted run? Do you have a before- or after-job subroutine call in the job? Have you seen this...

[quote="elavenil"]My memory works correctly, the inter process option should be set in order to get rid of the error occurred.

HTWH.

Regards
Elavenil[/quote]

if you have some time,can you look into this issue..

viewtopic.php?t=98611

[quote="elavenil"]My memory works correctly, the inter process option should be set in order to get rid of the error occurred.

HTWH.

Regards
Elavenil[/quote]


great job, Elavenil.

Thanks you very much..

Error calling subroutine: DSR_ExecJOb ( Action = 5); check DataStage is set up correctly in project Sampleproject. i got this problem many times.but i am unable to find the solution. while working in designer,i got this issue. i already tried in the forum.but nothing worked out for me. Looking forwa...

[quote="rwierdsm"]Sunshine, From your example above, it appears that your data streams have the same format. If this is true, use a collector stage to bring the two sources together and feed into your OCI. Could look something like: Seq ---> Xfm \ \ Collector --> XFM --> OCI / OCI ---> Xfm...

[quote="rwierdsm"]Sunshine, From your example above, it appears that your data streams have the same format. If this is true, use a collector stage to bring the two sources together and feed into your OCI. Could look something like: Seq ---> Xfm \ \ Collector --> XFM --> OCI / OCI ---> Xfm...

[quote="ray.wurlod"]Two separate streams into the same Oracle table. If the keys form disjoint sets, these streams can run in parallel.[/quote] Thanks for the suggestion, it worked,got one more doubt, hope u will clear it. I took two instances of oracle, is it possible to have only one ins...

[quote="ray.wurlod"]Two separate streams into the same Oracle table. If the keys form disjoint sets, these streams can run in parallel.[/quote]


in both sources, cust_ID (first column) is primary key..

[quote="ray.wurlod"]Two separate streams into the same Oracle table. If the keys form disjoint sets, these streams can run in parallel.[/quote] hi Ray, as i am novice, can you explain me in detail. currently i am practising using server jobs.. Two separate streams into the same Oracle tabl...

Hi, subject: appending data from 2 different sources to a single table. I have 2 source systems source_1:oracle database cust_id cust_name cust_city cust_zip 101 XXX City_1 1234 102 YYY City_2 5432 103 ZZZ City_1 1234 104 PPP City_1 1234 source_2: flatfile.txt cust_id,cust_name,cust_city,cust_zip 10...

[quote="chulett"]Have you tried searching for 'access violation'? There seem to be quite a number of posts with similar error messages in them, like [url=http://www.dsxchange.com/viewtopic.php?t=96581&highlight=Access+violation]this one[/url] for example. Perhaps something out there wi...

I am trying to extract data from oracle and inserting into Teradata. I have an emp table in oracle.i am copying the table with content into Teradata. but unfortunately,i got the following exception. DataStage Job 45 Phantom 284 Program "DSP.Open": Line 116, Exception raised in GCI subrouti...

Hi,

where can i find an example to work on XML Input/XML Output/XML Transformer.

Thanks for your info.

Kind Regards
sunshine

Thanks for your info. yes.we can give parameters in job properties. as i am a novice to datastage, can you give a scenario,where exactly these parameters will be useful. i would like to try an example,how using these parameters.. Thanks for your help kind regards sunshine [quote="naveendronaval...