DSXchange

you can get latest warning message(means last warning message ). By using the DSgetNewstLogID() function.

Cheers,
Praveen.

what you want to output ErrorID or ErrorDetail ?

assign These variable to Ans.

Hi, I wrote a Routine $INCLUDE DSINCLUDE JOBCONTROL.H Ans=0 Erroid = 0 ErrorDetail=0 JobName= ' ' handleJob = DSAttachJob(JobName, DSJ.ERRNONE) If NOT(handleJob) Then Errorid = -99 End Else /*Ans = DSGetJobInfo(handleJob, DSJ.LOGFATAL) */ Errorid = DSGetNewestLogId (handleJob, DSJ.LOGFATAL) EventDe...

If you edit your job, open and edit the shared container in the job, then save the shared container and save the job you will only be asked to compile 1 time in the designer. ... I was opend the sahred container direct from repository and I made changes and saved.If we will do in this it will give ...

ArndW wrote:This is because shared containers are actually loaded and compiled into a job at compile time. ...

why it is asking againg before run the job?

...But I am trying to run the job it is again asking to recompile job like this going on every time... When it asks you to recompile it usually gives a reason, what is that? Also, are you using one designer instance for both the job and shared container? Reason is the job reference shared container...

Hi All, I made a small change in the shared container and recompiled what job using that shared container.But I am trying to run the job it is again asking to recompile job like this going on every time.When I closed the data stage session and open the new session then it is not asking for compilati...

I always use a state file and Surrogate Key Generator (or SCD) stage. I guess that's why I never spotted it. Hi Ray, Can you tel me how your passing database values in SCD stage?Are you created any connection object? In my case Connection object also giving problem it is not picking the values. I w...

I always use a state file and Surrogate Key Generator (or SCD) stage. I guess that's why I never spotted it. Hi Ray, Can you tel me how your passing database values in SCD stage?Are you created any connection object? In my case Connection object also giving problem it is not picking the values. I w...

ray.wurlod wrote:Why do you need database connection details in a Transformer stage?! This stage type does not connect to databases. ...

in v8 we have option to connect the database through transformer stage for getting the surrogate key from database sequences.

In that case I think you have discovered a limitation; it is unclear from the documentation as to whether or not this is a bug (which means that it probably isn't a bug according to IBM). I would guess that the only workaround is to hard-code the values and create an appropriate DB2 userid with acc...

Can you explain? does that mean you cannot type it in, or that you cannot compile or that it won't run correctly? ... It is allowing to type the parameters but you know tha job is aborting because the database values are taking what you are typed in the text boxes. suppose if you type the user=#use...

ArndW wrote:Have you tried manually entering the parameters, e.g. "#UserId#'? ...

yes, it is not allowing.

ArndW wrote:What exactly is the problem? I just tested it and it worked as expected with parameters. ...

Actully i need to pass database connection details as parameter values to transformer stage for getting surrogate key from db2 sequence.

have you checeked? please letme know.

Thanks,
Praveen.

I am using Datastage V.8.0 in Output page of SCD stage we have DimUpdate tab. here i have given the setting for Dimension Updation. my settings were like this Deivation ColumName ,Purpose , Expire NextSurrogateKey() , PRODSK , Surrogate Key ,Diabled SalesDetals.ProdSKU , SKU , Business Key ,Disable...