De-encrypting parameters

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
gpbarsky
Participant
Posts: 160
Joined: Tue May 06, 2003 8:20 pm
Location: Argentina

De-encrypting parameters

Post by gpbarsky »

Hola mis amigos.

I need to know how to de-encrypt some parameters that are defined as encrypted.

I mean, I want to make a call to DSLogInfo function for the value of the parameters to be sure that I'm receiving the correct value.

Is there any function or any way to see the value of an encrypted field or parameter ?

Thanks in advance.
Guillermo P. Barsky
Buenos Aires - Argentina
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

No, they are encrypted so that this is not possible.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

IBM would not be happy if someone published a way to decrypt these values.
Mamu Kim
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

The whole purpose of encryption is to avoid it from public display.

Anyhow in earlier version of DataStage you can identify the value of the encrypted parameter.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ogmios should be along soon to let us all know how easy it is to decrypt things in DataStage. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Post by ogmios »

Hey :? ... :wink: ... :lol:

Left as exercise for the student
In theory there's no difference between theory and practice. In practice there is.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Having all that said...
In order to test for development reasons nothing prevents you from logging the value from inside the job :wink:
Bare in mind you should not leave any job in this condition in your production project what so ever (or loose the whole encrypted idea)

IHTH,
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
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi,
Does this means that one cannot decrypt the job paramters like user id and password which have been encrypted?

Thanks

Ketfos
jetlim
Participant
Posts: 8
Joined: Tue Jan 18, 2005 12:40 am

De-encrypting Parameters

Post by jetlim »

try this :

DSGetParamInfo(DSJ.ME,"<parameter name>", DSJ.PARAMVALUE)

eg:

DSGetParamInfo(DSJ.ME,"Database_Password", DSJ.PARAMVALUE)

regards,
Jet
Post Reply