DSSqlLdr?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

DSSqlLdr?

Post by chulett »

:? Someone just pointed out to me a 'Before/After' routine called DSSqlLdr that I've never noticed before and I'm not having any luck finding it as it doesn't seem to exist in the Manager. Does anyone know anything about this and where I might find some documentation / information on it?
-craig

"You can never have too many knives" -- Logan Nine Fingers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi Craig,
My install isn't showing such a routine as well.
Can it be a user routine they built?
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's not in the Manager or in the VOC file for 7.5x2. What is the date/time modified on theirs, and what is the date/time modified for one of the "supplied" routines?

In passing, I do note that there are two new supplied before/after subroutines (well, I haven't explored in there for some while) called ExecSHSilent and ExecDOSSilent.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

This reminds me why I always dictate my standard as building a new category in every client location with their name and building all custom routines under that category/subcategories so I won't have to figure out such things and also making it easier to import/export.
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As do I. Trust me, this isn't anything user-written because I'm the only user writing custom routines here. And I never start anything with 'DS'.

This is a 7.0.1 install on HP/UX and the only thing out of the ordinary that was installed was the ClickPack - and it created its own category where everything starts with CP... oh, and Perl. And three new 'Real Time' stage types for reading web logs and email. One of which just core dumps and which Ascential has no intention of fixing. :wink:

Not sure how I check anything date/time related when I can't find the darn thing anywhere. :? Only place it shows up so far is in job's drop-down list.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sheesh... should have looked harder before posting. :oops:

Found it buried down in a sub-sub-custom category in and amongst several things I'd loaded as examples for my noobies. It's part of the "Ascential Technical Tips & Tricks CD Version 1 - September 2002" that Mr Totman put together way back when, specifically some contributions by John Campbell to allow calling sqlldr from a routine.

Never mind. :lol:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply