DSXchange

parvathi

Hi all, I am trying to get the information of a job in aftersub routine. the parameters are passed during runtime. Now i want to find out the type of the parameter and then do some coding on the value i get. This is the code that i have used v_jobHandle = DSJ.ME v_paramtype = DSGetParamInfo(v_jobHan...

parvathi

the code that i have used is

v_writeJobStatus = DSGetJobInfo(v_writeJobHandle, DSJ.JOBSTATUS)
If v_writeJobStatus <> DSJS.RUNOK Then
ErrorCode =3

parvathi

ray.wurlod wrote:What kind of routine - transform function or before/after subroutine?

Where (and how) are you invoking this routine?

...

It is a before/after subroutine

i am invoking the routine in a after job routine

parvathi

:? Wait... you wrote a routine that runs a job and you run that job in the 'After Job' area of another job? . Sorry it was I am calling a routine in a job after the job runs . what the routine does is it takes info from the job i am running and then it runs another job in the routine . What i am su...

parvathi

Hi all, In a server routine i am running a server job. When the server job does not complete successfully then the routine has to return a non zero routine code. I am calling this routine in after job sub routine in a server job. When I start i set the ERROr code =0. Is the routine code and ERROCode...

parvathi

[quote="ray.wurlod"]If the parameter is encrypted you do not need to do anything to it. Just pass it along to the relevant place (such as the Password field in a database stage). quote] when i am trying to get a parameter of type encrypted from the atached job even though the value is encr...

parvathi

Thanks a lot
Trimming with field function i find it as the most efficient

But Even trim functions is also easier to me

parvathi

Hi
I have varibale with in duoble quotes

ex var="hello"

I want the variable without duoble quotes

just var = hello

how can i do this?

parvathi

You haven't mentioned how secure this needs to be. A very simple BASIC routine using a the builtin random number generator and a common seed will generate a good encryption for obfuscation, but the generated data wouldn't stand up to any professional attempts at decryption. For logging the informat...

parvathi

Call DSExecute("UNIX", "echo $MyVariable", Result, ExitStatus) ... Please correct if I am wrong. I have executed the command given above. iam not able to echo the value. Since my os is unix. I am echoing the value from my user id. where as the variable value that i want is set I...

parvathi

ray.wurlod wrote:
Why are you reading DSParams? If the environment variable is set, you can simply obtain its value from the environment!

i want the parametervalue of a particular parameter in a server routine.
I thought i could read from the DSParams.

If there is any other way please let me know

parvathi

ArndW wrote:I would use a variable to store the current section, or "state" while reading the file.
Code: Select all
   Line = TRIM(Line)
   IF Line[1,1]='[' THEN Section = Line[2,LEN(Line ...[/quote]

can you please expand the the code  a bit further. I could get a little bit of it

parvathi

Hi all, I have requirement like this I have the DSParam file in the projects folder of the datastage. I have to get the parametervalue for a particular parameter. I am struck with transversing the file. The file looks like It contains many line arranged irregularly. and the last it has parametersynt...

parvathi

Mathematically there are a number of well-known, documented and easily implemented solutions out there - ranging from pretty secure trapdoor encryption using large primes to ultra secure DES routines that you can call to encrypt data. You can even use the builtin UNIX encrypt and decrypt in externa...

parvathi

the secnario that i want to use the decrypt function is i will getting one parameter i will check the parameter type if encrpyted then i want to encrypt its value

if i use crc32 function the output will be a some unique number key right

DSXchange

Search found 103 matches

finding the parameter type of a parameter

Routine Error Code

how to remove starting and ending duoble quotes

problem in transversing the file