[ftmjr]

I'm currently using the below syntax to prevent the password being displayed via "ps".

isql -Smyserver -Umylogin <<EOF
$PASSWORD
EOF

The challange is... the isql output file for some reason contains the string "Password:". For example...

-----------------------------------------------------------------------------------
Password:
The class column will display the cursor name for locks associated with a cursor for the current user and the cursor id for other users.
fid spid loid locktype table_id page row dbname class context

------ ------ ----------- ---------------------------- ----------- ----------- ------ --------------- ------------------------------ ------------------
----------
0 268 536 Sh_intent 688002451 0 0 master Non Cursor Lock

(return status = 0)
-----------------------------------------------------------------------------------

How do I get rid of the "Password:"? Sorry if this is a basic question. I've tried everything I know, but have not been successful in getting rid of the "Password:" string in my isql output file.

Thank you.

[trvishi]

Use -Ppassword OR use -P`cat filename` in the command line.

[ftmjr]

Will the password be displayed in "ps" if I use -P ? For example...

isql -Smyserver -Umylogin <<EOF
-P$PASSWORD
EOF

[pdreyer]

isql -Smyserver -Umylogin -o my.log <<EOF >/dev/null
$(cat ~/.myserver)
select getdate()
go
EOF
more my.log

Can also use -i flag with <<EOF

Using a file to store your password (in e.g. .myserver) allow you to change your password without having to update all your scripts.

[ftmjr]

Will the password be displayed in "ps" if I use -P ? For example...

Below is the exact syntax we are using...

isql -S $SERVERNAME -U $LOGINNAME -i $ISQL_INPUT_FILE -w 500 >> $ISQL_OUTPUT_FILE <<EOF
$PASSWORD
EOF

Will the below syntax work? Without displaying the password via "ps"?

Below is the exact syntax we are using...

isql -S $SERVERNAME -U $LOGINNAME -i $ISQL_INPUT_FILE -w 500 >> $ISQL_OUTPUT_FILE <<EOF
-P$PASSWORD
EOF

[pdreyer]

Originally Posted by ftmjr

Will this work.... <<EOF -P$PASSWORD EOF

No I don't thik so

[pdreyer]

This is the best I can come up with to append to output

isql -S $SERVERNAME -U $LOGINNAME -i $ISQL_INPUT_FILE -w 500 <<EOF | tail +2 >> $ISQL_OUTPUT_FILE
-P$PASSWORD
EOF

[ftmjr]

You were right. I tried the below and it did not work...

isql -S $SERVERNAME -U $LOGINNAME -i $ISQL_INPUT_FILE -w 500 >> $ISQL_OUTPUT_FILE <<EOF
-P$PASSWORD
EOF

So we will give your code a spin...

isql -S $SERVERNAME -U $LOGINNAME -i $ISQL_INPUT_FILE -w 500 <<EOF | tail +2 >> $ISQL_OUTPUT_FILE
-P$PASSWORD
EOF

Sincere thanks for your help.