DSXchange

Thanks a ton asorrell for such a useful post!
This helped me a lot!

smosalakanti wrote:thank you for the details on the utility "istool". Is it possible to encrypt password ?

This is possible in version 8.7. You can also (in 8.7) use an -authfile option to specify a file containing authentication information - the password can be encrypted there also.
IBM provides encrypt.bat to encrypt using AES-128, but you can substitute your own encryption technology - it's all documented.

probal wrote:@asorrell:: As you have pointed out earlier that if the password contains '$' a backslash needs to be infront of it.

I don't think it is needed.I'm using a password that contains a '$' and without the '/' it is working fine for me.

It's actually '\' and not '/' and i believe you are enclosing your password within double quotes "password$"(in case of special characters either you should use '\'or enclose whole password within double quotes)

I believe single quote will work for special characters like '$', etc.

@asorrell, Thanks a billion for such a useful post!
I was about to dig myself.
Thanks for the tremendous time-saving I can have.

ray.wurlod wrote:IBM provides encrypt.bat to encrypt using AES-128, but you can substitute your own encryption technology - it's all documented.

Yes, in 8.7 you can encrypt the password and more. Some more details: if you're on UNIX or Linux then you can use the encrypt.sh command. The Administration Guide has details under the Encrypt command section. Happy encrypting!

qt_ky wrote:Yes, in 8.7 if you're on UNIX or Linux then you can use the encrypt.sh command.

Is this in built?

Yes.

Hi,

The post had detailed explanation. Thank you.

I was looking for a command where I could export certain set of jobs to one isx file. These jobs could exist in different folders in DataStage project.

Your help is appreciated.

Thank you

The istool command doesn't give you a means to selectively backup jobs from multiple projects. You could create a temporary project, drag and drop the jobs into that one project using the Manager, and then back them up.

Also - please note I did make edits in main post at end...

Is there a server side compile yet? We use istool to migrate jobs. Sometimes we need to force compile a job when source server and target server different hardware.

The engine-side compile should be dscc

Thanks Ray.

I could not find dscc on the UNIX servers.

My bad. dscc is the client-side command line compiler.

I have to do backup for entire project but not sure what vale i need to pass for -base flag.Any help on this?I have jobs in Multiple categories