Universe Stage

Abhijeet1980 · Post by **Abhijeet1980** » Fri Nov 17, 2006 12:24 am

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.

ArndW · Post by **ArndW** » Fri Nov 17, 2006 5:17 am

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.

kduke · Post by **kduke** » Fri Nov 17, 2006 6:42 am

You need ";" at the end of your SQL statement.

chulett · Post by **chulett** » Fri Nov 17, 2006 8:30 am

Yah... too bad 'View Data' works for something that won't actually run in your job. Much like if you add a semi-colon to the end of an Oracle query.

ArndW · Post by **ArndW** » Fri Nov 17, 2006 8:40 am

Lol - I was thinking of complex solutions and locking that is done differently in SQL for hashed files... and the answer was so simple!

kduke · Post by **kduke** » Fri Nov 17, 2006 7:16 pm

I like the simple ones.

ArndW · Post by **ArndW** » Sat Nov 18, 2006 3:02 am

I should have thought of Occam's Razor!

kduke · Post by **kduke** » Sat Nov 18, 2006 4:12 pm

Sure the lex parsimoniae (law of succinctness). http://en.wikipedia.org/wiki/Occam's_razor Easy for us simple minded folks.

ray.wurlod · Post by **ray.wurlod** » Sat Nov 18, 2006 4:55 pm

Curiously, perhaps, William of Ockham was bearded for much of his life.

The term "razor" is not the one related to shaving, of course.

Abhijeet1980 · Post by **Abhijeet1980** » Sat Nov 25, 2006 8:52 am

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

ray.wurlod · Post by **ray.wurlod** » Sat Nov 25, 2006 12:55 pm

Why? It all changes completely in the next version.

kduke · Post by **kduke** » Sat Nov 25, 2006 5:33 pm

We can't wait 6 months or a year before version 8 is running at our site.

DSXchange

Universe Stage

Universe Stage

Universe Stage - Problem Solved.