With "=" as the operator only the "full path" will work.
That's why I suggested the LIKE operator.
Quick question on querying DS_JOBS table
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
vivekgadwal
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
No worries. I've left copies of his free KBA Job Control Utilities everywhere I've been and constantly added functionality over the years, so that's why it looked familiar. It's been awhile since I've done any DataStage work and never got the chance to play with it in the 8.x world but... maybe someday.greggknight wrote:Ya when he was working for ascential I had a class with him in Texas call building dataware houses with datastage about 9 or 10 years ago
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers