DSXchange

i have few routines in datastage server jobs, i have one requirenment in parallel jobs to use those routines? how to get the server tansformer stage in paralle jobs?

Regards
Malli

we are not having any rotine in c++ for using the above said utility and we also not able to use server transformer stage

ray.wurlod wrote:Reject link with maximum rows = 1. ...

Hi,

i also want to display the custom message in job log, how to do?

Hi All,

How to abort the job when condition fails without using server transformer in parallel jobs. i have to abort the job by displaying fatal error in the log.

ex: if a>0 then "1" else abort.

When i tried to load the data in AS/400 by using ODBC stage,following error is coming EP_lodins_future_planned_ordersC..MapToPopf0107DbTgt.Popf0107DbTgt: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO RAC56041.POPF0107(OPVENDOR, OPSUBVEN, FILLER1, OPLOC, FILLER2, OPORDERPER, OPVENTY...

i tried with merge stage in server jobs,but this stage not allowing to giving input links to merge stage.

can we use merge stage in server jobs?i never used merge stage in server jobs,that's why i am asking this question.

HiAll,

I have one sequential file and one hash file as sources, how to do full outer join of these with out using oracle or oci stage in server jobs.

Thanks
Malli

Hi All,

How to compare two alpha numeric strings,it may include '/' and other special characters also,any function exist for this?

Thanks
Malli

I am doing the lookup by using one hash file and I have some conditions, if the conditions are satisfied then I want to write the record in the same hash file, which is one of the output link from the same transformer. And one more thing is I am using link collector stage also in this job. if it is ...

when i tried to read and write the data from same hash file at a time ,the following warning is comming?

"Abnormal termination of stage detected".

please tell me how to solve this problem.

How can we increment the surrogate key value for every insert in to target database?

Hi All,

what is the difference between SMP and MPP systems?

Thanks in Advance
Malli

Hi All,

what are JOBCONTROL.H and UNIVERSE.INCLUDE ODBC.H

files?and where these file available?

Thanks in Advance.

what is the exact difference between routine and transfroms?