Sybase connectivity in Linux/UNIX


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sybase connectivity in Linux/UNIX
# 1  
Old 07-07-2014
Sybase connectivity in Linux/UNIX

Hi, i am to linux/unix,i am using AIX 5.3. i want to connect sybase database through shell script, when i used "isql", it throws error "isql not found",

Do i need to install/configure anything, if yes please tell me how

kindly help me on this
# 2  
Old 07-07-2014
You need to have sybase client and a command line utility (isql) to connect to the sybase server. Please check with your administrators/dba's
# 3  
Old 07-08-2014
Thanks, i will check with AIX administrator..
meanwhile can you tell me how to add isql in AIX..?
sybase db is installed in the same server so i dont think there will be sybase client required..
# 4  
Old 07-08-2014
use absolute path of isql in your shell script
# 5  
Old 07-08-2014
If Sybase is already installed in the Sybase install directory there should be a directory starting OCS-XX_X where XX_X is the Release number. This OCS directory contains the Open client pieces including isql and bcp, also in the Sybase install directory there should be SYBASE.yyy where yyy is csh, env or sh if you source this it will set the environment. The interfaces file contains the Sybase instances the server or IP they are on and the port they are listening on.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Help with Windows to Unix connectivity

Hi Can we pass the parameter from the excel in windows and invoke the unix shell script from excel VBA by passing this parameter and get the results of shell script to the excel sheet? We tried to get the things in unix independently but we still strucked in connecting the excel to... (5 Replies)
Discussion started by: bikky6
5 Replies

2. Shell Programming and Scripting

Error in Sybase connectivity via UNIX

Helo Experts, I have an issue in connecting to sybase from UNIX. PFB, my code : #!/bin/ksh ############################################################################### # # Filename: docflo_split.sh # # Description:docflo_split.sh WrapperScript splits the temporary file... (1 Reply)
Discussion started by: Nits
1 Replies

3. Solaris

Sybase Connectivity Check through Shell Script

Hi, I need to check the sysbase database connectivity through the Unix Shell Script. Can you help me on the how to write the script to test the sysbase database connection. Thanks in Advance Nandha (0 Replies)
Discussion started by: nandha2387
0 Replies

4. Shell Programming and Scripting

Database connectivity using unix

Hi, I am trying to connect to the database through Unix serer using following command- mysql -u root -Jepadt -D dtdatabase But it giving me error - mysql: unknown option '-J' Can anybody help me to solve this problm Thanks in advance Please use code tags, thanks. (2 Replies)
Discussion started by: pspriyanka
2 Replies

5. Shell Programming and Scripting

Check the Sybase connectivity

Hi , I am able to connect to sybase using the below script ,but i want to check the status of the connectivity like if there is any network failure during downloading the file ,it will come out with exit 1 status .Any help on this ? # isql database_name db_user_name <<EOF select date_val from... (0 Replies)
Discussion started by: mohan705
0 Replies

6. Shell Programming and Scripting

Linux: Writing a tricky script to check connectivity

So, first and foremost, I'm having issues with my internet connection. Periodically, the connection drops across the network. The fix is simple enough: restart the modem. However, this gets old when the connection dies out every hour. I can hit my surfboard on 192.168.100.1, and navigate to a... (5 Replies)
Discussion started by: kungfujoe
5 Replies

7. Shell Programming and Scripting

Dos-Unix Connectivity

Hi, Is there any method to connect unix box(Excecuting unix commands through Batch Files) through DOS prompt. (1 Reply)
Discussion started by: shekhar_ssm
1 Replies

8. Shell Programming and Scripting

how to connect to sybase from Unix(AIX)

I have a script given below so can anyone explain me what it does? echo "use $DSQUERY\n go\n insert into ff.SmartCareLogin (username, password, userrole, fullname) values ('$1', '$1', '$2', '$3') go"|isql -Uff -P what is the use of $DSQUERY and go. When i am firiing isql command... (0 Replies)
Discussion started by: sachin.gangadha
0 Replies

9. Linux

Linux serial port connectivity help needed

Hai I am newbie to linux and I like know how can we connect linux with unix dump terminal. another thing is that whether I can get graphics in serial port connection using hyperterminal from windows. rgds sunil (2 Replies)
Discussion started by: sun
2 Replies
Login or Register to Ask a Question