Hello I have a problem with job sequence :
I have two jobs with (insert new or update existing clause) that inserts records or update different fields in the same table.
Job 1 : Key, field1, field2
Job 2 : Key, field3
Informix table : Key, field1,field2,field3
If I run the two jobs separate all rows are inserted and updated (for the same key values correctly).
But if I build a job sequence that runs in order Job1 then Job2 it does't write rows correctly.
Values Inserted : Key,field1(correct),field2(correct),field3,field3(null)
Any help will be appreciated, thnX in adv. Marco
Job sequence
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am
First job and scond job end with "OK conditial" with no errrors or warnings.
They are not parallel jobs.
If I run the jobs separate all rows are inserted correctly..
If I run the two jobs in sequence in the target Informix table in all rows the field value3 (Inserted from the second job) has all values set to null ....
They are not parallel jobs.
If I run the jobs separate all rows are inserted correctly..
If I run the two jobs in sequence in the target Informix table in all rows the field value3 (Inserted from the second job) has all values set to null ....
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am
In first Job I insert/update only field1, field2
In the second job I insert/update only field3
the "strange" is that if I run job1 and the job2 spearate all rows are inseted with correct values, but if I link the two jobs in the sequence and run it with the sequence job it runs correctly but all values for field3 are set to 'null' values...
Could it be for transcation isolation problem ?? mah dunno
In the second job I insert/update only field3
the "strange" is that if I run job1 and the job2 spearate all rows are inseted with correct values, but if I link the two jobs in the sequence and run it with the sequence job it runs correctly but all values for field3 are set to 'null' values...
Could it be for transcation isolation problem ?? mah dunno
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 13
- Joined: Thu Jun 16, 2005 6:44 am