Sybase Connectivity Check through Shell Script

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check connectivity with multiple hosts - BASH script available here

Hi everyone! Some time ago, I had to check connectivity with a big list of hosts, using different formats (protocol://server:port/path/, server:port, ....). I developed a script that checks the connectivity using different commands (ping, telnet, nc, curl). It worked for me so I'm sharing it...

2. Shell Programming and Scripting

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

3. Shell Programming and Scripting

Help with shell script to check the tcp network connectivity between server

Hello, I have a requirement to check the tcp network connectivity between server it's running on and the list of host's and ports combination. i have written the below code but it doesn't work, but when i execute the nc command outside the script it works fine. please help me where i am...

4. 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...

5. Shell Programming and Scripting

Check the connectivity of the DB through script, exit if no connection

check the connectivity of the DBs through script, script should exit if no connection and display the output as below. connectivity for DB1 is OK connectivity for DB2 is OK connectivity for DB3 is FAILED for DB in 1 2 3 do (sqlplus -s...

6. 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...

7. Shell Programming and Scripting

Check connectivity script

This past weekend I had some issues with my ISP. So for future purpose I'm going to have some logging on my internet so I'm able to attach log files to my complaint email if this issue reoccurs. Decided to do a simple ping script that runs every 5 or 10 min with crontab if ping fail write date...

8. 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...

9. Shell Programming and Scripting

Script to check connectivity

I want to write a script to check if a unix box say abc.tdc.cin.net can be connected or not on certain port say 22. right know i have to telnet them manually from DOS prompt and if it is successful then isay it is connected. Also to check Database connectivity I am using tnsping From DOS prompt....

10. Shell Programming and Scripting

Connecting to sybase via shell script.

Hi All, I was able to connect to sybase in shell script and also able to run few sql queries, something like this, #!/usr/bin/ksh -x temp=`echo "select name from sysobjects where type = 'U'"` results=`isql -SDS_SERVER-UAdhocUser -Pha12 <<EOF set rowcount 6 $temp go EOF` line_count=0...

LEARN ABOUT DEBIAN

dbix::class::schema::loader::dbobject::sybase

DBIx::Class::Schema::Loader::DBObject::Sybase(3pm)	User Contributed Perl Documentation	DBIx::Class::Schema::Loader::DBObject::Sybase(3pm)

NAME

       DBIx::Class::Schema::Loader::DBObject::Sybase - Class for Database Objects for Sybase ASE and MSSQL Such as Tables and Views in
       DBIx::Class::Schema::Loader

DESCRIPTION

       This is a subclass of DBIx::Class::Schema::Loader::DBObject that adds support for fully qualified objects in Sybase ASE and MSSQL including
       both "database" and schema of the form:

	   database.owner.object_name

METHODS

   database
       The database name this object belongs to.

       Returns undef if ignore_schema is set.

sql_name
       Returns the properly quoted full identifier with "database", schema and name.

SEE ALSO

       DBIx::Class::Schema::Loader::Table::Sybase, DBIx::Class::Schema::Loader::DBObject, DBIx::Class::Schema::Loader::Table,
       DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base

AUTHOR

       See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.

LICENSE

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-05-05			DBIx::Class::Schema::Loader::DBObject::Sybase(3pm)

Solaris