CATALOUG PREFIX

Gokul · Post by **Gokul** » Mon Jun 20, 2005 1:29 am

Hi,

I want to knoe the Different prefixes used by Datastage to Cataloug Routines and Functions?

How do we determine those prefixes?

Thanks in Advance,
Gokul 10dulkar

ArndW · Post by **ArndW** » Mon Jun 20, 2005 1:46 am

User functions & jobs will get catalogued with a DSU.<name> format; other prefixes or formats are used within the product itself and are not encountered in normal DS use.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 20, 2005 2:38 am

Not sure why you want to know, but you determine the prefixes by inspection of the VOC hashed file. If you attempt to change the prefixes the routines will cease working. It's more complex than just the prefixes.

Gokul · Post by **Gokul** » Mon Jun 20, 2005 4:10 am

Thanks Ray.

Actually I was referring to one of your Posts regarding DSGetLinkMetaData,where you had specified.

Code:
Result = DSGetLinkMetaData(JobName, StageName, LinkName)

Of course, you will need a DEFFUN in the second case, so will need to determine with what prefix DSGetLinkMetaData is cataloged. Writing from an airport lounge, I can't help with that.

So in this case how do we determine the Catalogue prefix.

Thanks,
Gokul

talk2shaanc · Post by **talk2shaanc** » Mon Jun 20, 2005 4:18 am

basically all user defined routines are prefixed with DSU and all in-built routine are prefixed with DSX.

And DSGetLinkMetaData is a function NOT routine or Transform, so you need to declare it by adding below line, on the top.
$include DSINCLUDE JOBCONTROL.H