Unanswered: DB2 task Scheduler requires "db2 connect to database command"
I am looking for some help here.
I am trying to set up some tasks with the DB2 Task Scheduler.
In order for it to work I need to use the command
connect to database user .... using ...;
insert into table .....
If I remove the connect to database it fails with a database connection does not exist.
Is their anway to get the statement to work with the removal of the password from the database connection command ? Basically I need to make sure that the password is not visible to end users so that the database cannot be hacked .