Does the SetDSParamsFromFile exist for DSEE

timsmith_s · Post by **timsmith_s** » Tue May 01, 2007 9:12 am

The SetDSParamsFromFile routine doesnt appear in the dropdown of available before-job/after-job subroutines - can it still be used for DSEE jobs? If so, what am I missing? THX!

DSguru2B · Post by **DSguru2B** » Tue May 01, 2007 9:51 am

Can you see that custom before/after job subroutine in server jobs? Does the routine exist?

timsmith_s · Post by **timsmith_s** » Tue May 01, 2007 10:07 am

No, it doesnt appear in the dropdown list.

DSguru2B · Post by **DSguru2B** » Tue May 01, 2007 10:13 am

You did not answer my second question. This routine does not get shipped with the product and hence must be a user defined routine. This routine must be present for it to show up in the drop down. Check your routine repository.

ray.wurlod · Post by **ray.wurlod** » Tue May 01, 2007 3:08 pm

It may also be the case that this routine was written as a transform function (so that it can be called from a job sequence's Routine activity) rather than a before/after subroutine. In that case it will never appear on the drop-down list of before/after subroutines.

It may also be the case that it has not been successfully compiled, which is also a prerequisite for appearing on the list.

timsmith_s · Post by **timsmith_s** » Sat May 05, 2007 5:48 am

Sorry for not answering your 2nd question, my bad. If its not shipped with the product, why does Ascential make mention of it as a method for parsing parameters? Is this a public domain routine?

chulett · Post by **chulett** » Sat May 05, 2007 6:55 am

Where exactly does "Ascential make mention of it"?

timsmith_s · Post by **timsmith_s** » Tue May 08, 2007 11:40 am

Its in their "Advanced DataStage" course material - under job design

chulett · Post by **chulett** » Tue May 08, 2007 12:59 pm

So, apparently a routine provided by the class. Did they provide you with a CDROM when you took the class? I'd look there...

timsmith_s · Post by **timsmith_s** » Sat Jun 02, 2007 5:00 am

Not it was not on the CDROM, first place I checked - moving on with a different approach.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 02, 2007 5:20 am

Assuming you're referring to class DX436, can you please give the page number (and whether it's in the notes or the lab manual)? I'll try to track it down.

I_Server_Whale · Post by **I_Server_Whale** » Sat Jun 02, 2007 8:26 am

Topic has been marked as a "WORKAROUND". What is the workaround? I couldn't see any.

timsmith_s · Post by **timsmith_s** » Tue Oct 02, 2007 9:56 am

The fuction was specified in the Appendix of the Advanced course - course manual (not the lab manual)