DSXchange

I want to write a generic routine to get the encrypted password from a parameterset. However when I get the encrypted password it returns a value of -16 using the following functions

paramList = DSGetJobInfo(JobHandle , DSJ.PARAMLIST);
param = Field(paramList, ',', P);
paramVal = DSGetParamInfo(JobHandle, param, DSJ.PARAMDEFAULT);

The only other alternative I can think of is to read the parameterset file directly as a file. However in order to do this I need to know where the parameterset directory is and obviously which environment and project I am working on. Is there a way of determining the parameterset directory in real time ?

Does anyone else have any potential solutions or workarounds for this.

Thanks

Did you look up what that -16 means?

$DSHOME/include/dsapi.h

So it appears that I can only get to the password whilst running a job and not from a routine.

I don't actually want to decrypt the password (not that its possible anyway), just get its value. It doesn't seem like an unreasonable demand.

The only way I can think of is to write a routine which calls a job which returns $UserStatus.

So are there any other ways to get hold of the value or the path to the parametersets ?

Funny, just found a post of mine from 8 years ago where I ran across the exact same error. However, don't recall whatever became of the answer. Perhaps try DSJ.PARAMVALUE instead?

I have tried DSJ.PARAMVALUE and DSJ.PARAMDEFAULT

Parametersets weren't around 8 years ago were they ?

Nope. However this is a generic parameter error, nothing specific to a 'set'. Hopefully someone else can help.

You won't find it in the file system unless you've got a value set. Each parameter set has a directory in the ParameterSets directory in your project directory.

What's the end game? I can't think of any reason for getting the encrypted password value without the intention of decrypting it?

You could parse it out of a job log.

I think Kim Duke has some trick for displaying parameter values.

Mike

We are writing a routine which will interrogate a series of tables in databases in order to get data volume information.

Given that it is a generic routine, we have to be able to pass the name of parameter set to the routine in order to connect to the tables.

I am aware of the routine to display parametersets but it will never display the password because of the -16 error previously mentioned.

If you're writing a routine to query tables to get their volume data information, why not just write a server job and use the database stages to execute the custom query and then send the rows to an audit table or whatever? You can write a generic server job that you pass in all the parameters you'd need to make it generic.