DSXchange

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.

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.

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

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.

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

I like the simple ones.

I should have thought of Occam's Razor!

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

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

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

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

Why? It all changes completely in the next version.

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