DSXchange

By exporting dsx of job having $PROJDEF for sure and my concern job dsx and by comparing their encoded password values I'm able to find out whether encrypted job parameter is having value $PROJDEF or not.

Thanks all for your help.

qt_ky wrote:The simple way, export & view, has been suggested above. Have you tried it??

thanks, I'll try this on Monday morning.

yes, I too remember in v8.1 i used to see encrypted password but in v9.1 I'm seeing only stars. Is there any other simple way to find out password is $PROJDEF.

For me encrypted password is shown as ***** irrespective of what the password is. Thanks, But this is not my query, usually what we do is when we add environment variables in our parallel job we forgot to change value of password to $PROJDEF and when we export these jobs to other enviroments that is...

ArndW wrote:The algorithm for encrypting within DataStage is not a complex one, so if you write a job and use $PROJDEF as a the value of an encrypted parameter that string can be used as comparison as it will alw ...

Can't view your premium content

Could you please advise is there any way to check and verify whether encrypted password in parallel job has value $PROJDEF not anything else directly through designer or is there any shortcut to verify this.

Now I added Decimaltodecimal() function for all decimal columns and now job is running fine without hanging.

Thanks for suggestions.

Are u asking after chopping everything after transformer stage..... the results above (hanging up) which I have mentioned are all after my chopping off everything.

PaulVL wrote:If you chop off everything after the transformer stage and add a peek, does the job still hang?

In test job I did the same, I chopped off everything after transformer and added sequential file at end.

I did not use DecimalToDecimal() conversion function as number of digits in decimals are same( we are not rounding off and as it is generally said when we are not rounding off no need to use decimaltodecimal() function). However last night I used stringtodecimal() for test and job was aborting as ex...

It is just hanging up without any warning. I added up reject link as you advised but still it is hanging up may be because reject link is also having dec(10,3).

My target is sequential file. To identify this firstly i just kept char columns at output and ran, job ran fine. Then after this I mapped that decimal column then the job was hanging. To exactly identify issue was due to dec(12,3) into dec(10,3), I kept constraint condition in transformer to remove ...

In my parallel job, I'm mapping decimal(12,3) to decimal(10,3) in transformer stage (also I received confirmation from analyst that we will not be receiving any number greater than decimal(10,3)). However, when I'm receiving any number greater than decimal(10,3) in that column (in test region) datas...