DSXchange

You should also check the parameter NLS_LANG for the oracle client.

Nicolas

I already had this error. There was a bug in a job ending in inserting some bad characters in a table. (If I remember well, it was @FM character or something like that). We had the error when doing a query with join conditions on the field having that bad character. I had actually to drop and re-cre...

Apart from what is the problem of Arshi, the easiest way I found to remove key duplicates is to send all the lines in a Hash File with the right key definition.
The input sort order defines which lines are kept.

Nicolas

You should also check your NLS_LANG setting for the Oracle client you're using with Datastage.

The NLS_LANG setting is used by any Oracle client, Windows or Unix.

Do you have any error from Datastage ?
Are the NLS activated in Datastage ?

I deleted the 10 306 files of the &PH& folder, and it's working much better.

Would it be a good thing to clear that folder automatically every month on each of our environnement ?

I checked the cpu use during that 'pause' and it was mainly idle.

We tried to purge the logs for that job before lauching it, the start is still delayed.

The auto-purge is on and keep 3 days of logs.

Since a few days, our jobs sequence are taking more than one minute to start the job design in our development environment. Here is the log of one of our job : 2694 INFO ~2006-12-13 11:20:22 JsIntegrationMAPP_FAB_MAPP..JobControl (DSRunJob): Waiting - for job JcCMNExecuteJobDesign.JaAlimentationT_AX...

Is the oracle database parameter 'NLS SEMANTICS' set to CHAR ?

I had that case with the nls not activated in Datastage, and the code page of Oracle set to utf8.

So a char(1) in Oracle was considered as a char(4) in Datastage.
(Any char(n) become a char(4n)).

Nicolas

About the DSAttachJob function :

I was wondering how it works when you have multiple instances of the same job runing ?

How do DS know which job handle to use as he only get the name of the job ?

And as an FYI, I've never bothered to check to that level. Simply checking the status of the DSSetParam function is sufficient: ErrCode = DSSetParam(JobId, ParamName, ParamVal) If ErrCode # DSJE.NOERROR Then (error code) End Actually I wanted to check the values I got from the parameters files rath...

Ok, thanks for your answer. Too bad I can't read the post, but I get the point from the first sentence :wink: About the online help on the DSGetParamInfo function : DSJ.PARAMVALUEString - Current value of the parameter for the running job or the last job run if the job is finished. Maybe we can say ...

Hi, I'm facing a situation I do not understand, even if everything is working ok. Maybe someone know how this work ? I'm using a job control in order to get the parameters values to execute a job sequence. I'm doing something like this in order to get the parameters list : ParamList = DSGetJobInfo(J...