how to disable to display password when use dbisql access IQ database

[former_member1368358]

Hi

when i use cmd   "dbisql -c "uid=dba;pwd=sql" -nogui"  to access IQ database,

I run ps -ef | grep dbisql, it can see the dba  password sql

[root@node1 ~]# ps -ef | grep dbisql

sybase   18287 13574  4 11:45 pts/0    00:00:00 /opt/sybase/shared/JRE-6_0_20_64BIT/bin/java -Xmx257m -Dsybase.native.executable=/opt/sybase/IQ-15_4/bin64/dbisql -Dsun.java2d.noddraw=true -Dsun.java2d.d3d=false -cp /opt/sybase/IQ-15_4/java/isql.jar:/opt/sybase/IQ-15_4/java/jlogon.jar:/opt/sybase/IQ-15_4/java/SCEditor610.jar:/opt/sybase/IQ-15_4/java/JComponents1201.jar:/opt/sybase/IQ-15_4/java/jsyblib610.jar:/opt/sybase/IQ-15_4/java/batik-anim.jar:/opt/sybase/IQ-15_4/java/batik-awt-util.jar:/opt/sybase/IQ-15_4/java/batik-bridge.jar:/opt/sybase/IQ-15_4/java/batik-codec.jar:/opt/sybase/IQ-15_4/java/batik-css.jar:/opt/sybase/IQ-15_4/java/batik-dom.jar:/opt/sybase/IQ-15_4/java/batik-ext.jar:/opt/sybase/IQ-15_4/java/batik-extension.jar:/opt/sybase/IQ-15_4/java/batik-gui-util.jar:/opt/sybase/IQ-15_4/java/batik-gvt.jar:/opt/sybase/IQ-15_4/java/batik-parser.jar:/opt/sybase/IQ-15_4/java/batik-script.jar:/opt/sybase/IQ-15_4/java/batik-svg-dom.jar:/opt/sybase/IQ-15_4/java/batik-svggen.jar:/opt/sybase/IQ-15_4/java/batik-swing.jar:/opt/sybase/IQ-15_4/java/batik-transcoder.jar:/opt/sybase/IQ-15_4/java/batik-util.jar:/opt/sybase/IQ-15_4/java/batik-xml.jar:/opt/sybase/IQ-15_4/java/js.jar:/opt/sybase/IQ-15_4/java/pdf-transcoder.jar:/opt/sybase/IQ-15_4/java/xerces_2_5_0.jar:/opt/sybase/IQ-15_4/java/xml-apis-ext.jar:/opt/sybase/IQ-15_4/java/xml-apis.jar sybase.isql.ISQLLoader -c uid=dba;pwd=sql -nogui

how to use dbisql access IQ database and hidden the password?

thks

[saroj_bagai · Accepted solution]

You can  put your connection parameters in options.txt and then encrypt it
using dbfhide e.g

cat options.txt

-c
"uid=DBA;pwd=sql;eng=redhead_iq160801" -nogui

[sybase@redhead
data0801]$ dbfhide options.txt options.enc

SQL Anywhere Command File Hiding Utility Version 16.0.0.807

1. delete
   options.txt

[sybase@redhead
data0801]$ dbisql @options.enc

(DBA)> quit

[former_member1368358 · Accepted solution]

Thanks, I try it, it ok