Batch reporting using isql - way to hide password?

bachle · Post by **bachle** » 10 Sep 2009 7:43

Hi,

Is there a way to hide the dbo password when using isql in batch?

Any other way (ctm utility?) than using sql to generate a report with all the job starting with a character? Will extract from the ctm server db.

Thanks.

Post by **fyot** » 10 Sep 2009 8:06

Hi,

I you works directly on the Control-m Server, no need to use isql.
Try "SQL" utility, it access directly.

philmalmaison · Post by **philmalmaison** » 11 Sep 2009 2:32

depending of your destination:
controlm/EM
or
controlm server

in controlm/em the psfile is used to have a encrypt password
for controlm server, using SQL doesn't give access to the engin of your database, but for anythink you want on the flowshart controlm

regards
philmalmaison

bachle · Post by **bachle** » 17 Sep 2009 10:29

Hi,

Thanks for your answers.

I need to run it as a script (schedule job).

I know that I can use the sql from the ctm menu but this is not the way I need to do it.

Any other suggestions?

philmalmaison · Post by **philmalmaison** » 18 Sep 2009 12:55

As we already said :
for controlm server in batch use the SQL command, with only necessary to have controlm env to use it
for controlm em use the psfile process or create a protect file somewhere in controlm em and read it

regards
philmalmaison