Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: db2look statement -no password in test.sql

    Hello everybody,

    I try export the structure of the following table with the db2look statement:

    db2look -e -d sample -t table -i xx -w yy -o x:\test.sql

    In the output file test.sql the password is missing.

    There only stands: connect to sample user xx;

    But I want the following output: connect to sample user xx using yy;

    Can anyone tell what is wrong in this export statement.

    Thanks for help toette

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I do not think that db2look can supply the password. This is because the password is maintained by the OS and is usually encrypted with an algorithm that is basically one way. This means that the password that is stored cannot be decrypted easily. Password checking is done by encrypting the inputted values and checking the result against what is stored.

    Besides having the password in an uncrypted format in some script file is not a good idea anyway. It is a big security risk.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts