Hi all,

I have two accounts in a Unix server, the first one uses .tcsh as default shell and the other uses .ksh (korn shell) as default.

When I login using the account with .tcsh default, I can use the isql command and connect to our database server. However, when I use the other account that uses korn shell (.ksh) as default, the isql does not work. Unix does not recognise it.

I noticed that in the .tcsh account, i have these two files .login and .tcshrc, which I think contain the configuration to connect to our database server.

I tried copying these files to my .ksh account, and even tried renaming the file .tcshrc to .cshrc but still, the .ksh account does not recognise the isql command.

Any suggestions how I can make my .ksh account recognise isql? I also noticed that even though i have this .login file in my .ksh account, it does not load. (as the echo command is not being displayed)

Thank you.

Find where the isql binary resides ( find / | grep isql ), and put in your PATH for ksh, and if not even echo is working I would check the PATH and make sure it has /usr/bin:/usr/sbin:/sbin:/usr/local/bin etc or symlink the isql binary to /usr/bin or something like that and make sure it is in your PATH. echo $PATH will show you the current PATH variable. do
the PATH variable is where unix stores the locations of command commands so you do not need to type the absolute path every time you want to execute them. hope this helps

thank you raidzero.

However, when I tried using find / | grep isql, the command returns too many directories and most of them displays "Permission denied" at the end of the directory. e.g.

find: cannot read dir /var/sadm/patch/: Permission denied
find: cannot read dir /var/adm/db/patchlogs: Permission denied
find: cannot read dir /var/spool/cron/crontabs: Permission denied
find: cannot read dir /var/spool/clientmqueue: Permission denied
find: cannot read dir /var/spool/mqueue: Permission denied
find: cannot read dir /var/krb5/rcache/root: Permission denied
find: cannot read dir /var/fm/fmd/xprt: Permission denied
find: cannot read dir /var/fm/fmd/rsrc: Permission denied
find: cannot read dir /var/fm/fmd/ckpt: Permission denied
find: cannot read dir /var/preserve/casaall: Permission denied
find: cannot read dir /var/preserve/chuljay: Permission denied
find: cannot read dir /var/preserve/cheherb: Permission denied
find: cannot read dir /var/cron: Permission denied