DSXchange

Chulett
The job abort because the Cust_Id field is sent with null value to the database.
The row is rejected because a Cust_Id cannot be null.

Ray
Do you mean the file D_HashFile or the directory HashFile ?
The directories are stored in a .ini file.
I will check them.

Thanks

Hi
Sorry for the delay, i was waiting to my premium validation.

Chulett,
I already did that the job work well the day after and abort the next day (is it clear ?).

Ray,
Do i have to execute the the point 5 commands in the administrator ?

Thanks.

Hi
Can i fix it by Export / Delete / Import my jobs.
I don't have the right to write on the disk of the production and the project is protected.


Thank you

Hi all Sometimes i have in my input DATA (from a hashed file who is built in a previous job ) the string DATA.30 in the key field of my Hashed File. If i delete the hashed file the job works fine one or two days and then the problem is back. MyJob..MyTransForm: At row 480, link "to_table",...

Hi all
This topic is great because we all have this king of problem.
What about the Replace existing rows completely.(I have this option in the DB2 plugging).
You don't have to do a lookup but i don't know the impact on the Database.

Hi
You are right Chulet , i missed a step in my job.
I convert a date to YOURDATE with then i place this constraint to select the rows i want

Hi
You can try this YOURDATE=MONTH.LAST(YOURDATE).
The format of YOURDATE is DMY[2,2,4] in my case.

Hi,
When i have to do this i use RowProcCompareWithPreviousValue.

Hi
What do you with your hashed file after the two jobs are executed ?
What do you think about using a parameter for the name of the hashed file ?
In that case you'll have to execute the job(s) who read it twice.

Hi
This message appears when you add a column whithout specify its type and its legnth.
Happens to me yesterday.

Me Four
And Thank you all for your help.

Hi
We use ini files to store our parameters.
We have a routine who read the file and then we use DSSetParam inside a job control.

Hi Ray
Your routines are fine but i don't understand the bold part of this code
(from the AddYears routine)

Ans = Iconv(NewYear "R%4" : "-" : OriginalMonth : "-" : NewDay "R%2", "DYMD")

Hi, I just discovered that DSJ.JOBELAPSED return 0 when a job start before midnight and end after. It bother me a little so i wrote this : * Gestion du passage de Minuit (pas de l'execution sur plusieurs jour) JobStart=DSGetJobInfo(Action <ActionOrder, ParallelOrderWait, COL_HANDLE>,DSJ.JOBSTARTTIME...

Hi
Do you check your copybook ?