on 08-25-2015 3:02 PM
Hi all,
I have installed SAP sybase on suse linux. Everything is working fine except dbisql. Can anyone please guide how to use dbisql.??
When i type dbisql at the prompt it says "command-not-found dbisql". Do i have to go to any specific file location in sybase to invoke it??
thank you...
hi
when i try to run isql64 at OCS-15_0/bin/
getting error:
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Any idea how to resolve this.??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gek,
Thank you for the reply. I am able to login isql/isql64. what i am trying to achieve here is the view which we get using dbisql.
Please ignore my previous error message
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Hello Dinakar,
(I apologize for the confusion with my previous message, I did mean "isql64", not dbisql).
In fact, when you install ASE for SAP Applications, the OS user syb<SID> gets created and under this OS user all ASE environment variables are set as they should.
So it is a good practice to log on with this OS user when you need to work in ASE environment, i.e to be able to execute any executable under $SYBASE directory, in that way you don't need to source SYBASE.sh(csh) nor set variables manually.
Now, regarding the dbisql and the fact you don't have DBISQL directory: when installing ASE for Business Suite, dbisql is not installed by default by SAPinst (our recommended tool to execute SQL commands is the SQL command line of the DBA Cockpit).
However, you should be able to install it afterwards using directly the setup executable of the SAP ASE media and selecting the custom installation with only the option Interactive SQL (be careful to not select any other option!).
HTH
Cris
Thanks cris/Nic/Marc.....As i am using SAP sybase i think there wont be DBISQL cos i dont have that folder under sybase in the first place.
i am able to connect using isql commnad... isql -Usapsa -S<sid> -X. but i dont like the way the query result appear . In dbisql the format is tabular which is very clear to understand.
I think i have to use SCC instead in this case...
Regards,
Dinakar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
Do you have sybase env. variables properly set?
Can you post output of:
echo $SYBASE
echo $PATH
File should be located in $SYBASE/DBISQL/bin
so your $PATH variable should contain this location.
You can use SYABSE.sh script located in your Sybase main directory to set this variables.
(for example ' source /my-sybase/dir/SYBASE.sh ' or set variables manually in .bash_profile or .cshrc in your home dir.)
Best Regards
--
Marcin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As Cris stated your env is probably not correct.
su - syb<sid>
isql -Usapsa -S<SID> -X
Location of it should be:
/sybase/<SID>/OCS-16_0/bin
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
As this SCN space is specific to ASE for Business Suite applications, I'd recommend you to use isql/isql64 executables or DBA Cockpit SQL Command line when working with ASE in a Business Suite env.
Having said that, the dbisql executable is located under /sybase/<SID>/DBISQL/bin.
Logged with syb<SID> OS user, your Sybase environment variables should be configured properly to allow you to execute the dbisql without sourcing SYBASE.csh (or.sh) previously.
HTH
Cris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.