Universe Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Universe Stage
Buddies,
I've included Universe Stage as iput and Sequential Text file as o/p.
DSN for Universe Stage is localuv and the sql query is as under :
SELECT "NAME", "CATEGORY" FROM "DS_JOBS" WHERE NAME NOT LIKE '\\%' AND READONLY='NRO'
When i click on View Data, i'm able to see the jobs from universe table, but the job keeps on running without fetching any records.
FYI.: About 4800 odd jobs are there in the DS_JOBS table.
I've included Universe Stage as iput and Sequential Text file as o/p.
DSN for Universe Stage is localuv and the sql query is as under :
SELECT "NAME", "CATEGORY" FROM "DS_JOBS" WHERE NAME NOT LIKE '\\%' AND READONLY='NRO'
When i click on View Data, i'm able to see the jobs from universe table, but the job keeps on running without fetching any records.
FYI.: About 4800 odd jobs are there in the DS_JOBS table.
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
My first thought is that your job is waiting on locks that it will never get. I vaguely recall having had a similar problem in the past. It is easier in this case to use a hashed file stage and change the query syntax around a bit to read "WITH NAME UNLIKE \\... AND READONLY EQ 'NRO'" in the selection tab.
Sure the lex parsimoniae (law of succinctness). http://en.wikipedia.org/wiki/Occam's_razor Easy for us simple minded folks.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Universe Stage - Problem Solved.
Setting the proper Transaction Isolation had solved my problem.
Using the same i'm able to get inside view of some of the internal DS repository tables.
Regards
Abhijit
Using the same i'm able to get inside view of some of the internal DS repository tables.
Regards
Abhijit
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: