06-19-2008
connect sybase with deifferent IP
Quote:
Originally Posted by
jingi1234
use here documents
ISQL -U -P -S -o output.txt ............ << EOF
Whatever you want to do in the sybase
EOF
Jingi
That's works, but how if the sybase server has a different IP with the UNIX OS?
For example, the shell script is created ini IP 192.168.1.4, and i want to connect sybase in server with IP 192.168.1.5?
Thanx
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I am trying to connect to a remote sybase database server (sitting on windows) from my freebsd apache webserver.
My Webserver has installed;
Apache2.0
PHP 4.3.8
Freetds with ODBC enables ( tsql works but isql doesnt )
unixODBC
syabse-ocsd
When i connect with tsql from... (4 Replies)
Discussion started by: lealyz
4 Replies
2. Shell Programming and Scripting
Hi,
Can anyone please give me a script or let me know how to connect to a sybase database and execute a query using Korn shell scripts.Am new to Unix but i need to do this ASAP.
Please help.
Thanks,
Gops (7 Replies)
Discussion started by: bhgopi
7 Replies
3. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: arvindcgi
1 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
This is my first post. Need your favour guys.
I need to authenticate syabse login/password thru shell script.
I am getting the ID & Pwd form user and storing it in variable..
But how to authenticate and echo user back if the id/pwd doesnt work.
isql -U$1 -P$2 -S$3 ??
thanks in... (3 Replies)
Discussion started by: libin4u2000
3 Replies
5. Shell Programming and Scripting
I am trying this
>$ /usr/sybase/bin/isql -UABC -Pdef -SXYZ -b
Getting the following error.
Help is appreciated (1 Reply)
Discussion started by: pinnacle
1 Replies
6. Shell Programming and Scripting
Greetings,
I need to capture the output of a Sybase stored procedure, inside my
shell script( k shell). Based on this output, I need to call another
perl script, with input arguments as the result set of the procedure
execution. I need to keep looping through and call the perl script, ... (2 Replies)
Discussion started by: rajpreetsidhu
2 Replies
7. Shell Programming and Scripting
Greetings,
I need to make an open server call to a shell script from inside a Sybase Stored procedure.
Coul any one please provide a sample code?
TIA (0 Replies)
Discussion started by: rajpreetsidhu
0 Replies
8. Solaris
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
9. Shell Programming and Scripting
Hi All,
I'm trying to connect to Sybase via shell script. i'm getting the following error.
Please let me know where i'm going wrong. Note that i'm not having this issue when connecting via terminal.
#!/usr/bin/bash
SYBASE=/usr/sybase
ISQL=$SYBASE/bin/isql
export SYBASE ISQL
... (6 Replies)
Discussion started by: Irishboy24
6 Replies
10. Shell Programming and Scripting
Hi, I am new to advanced scripting.
I need to get top 20 records from database (Sybase) with a condition that all Char/varchar columns should have more than 4 characters.
I need to do this via shell scripting, I have got half logic (on how to get varchar/char columns and stored it in a... (2 Replies)
Discussion started by: Selva_2507
2 Replies
LEARN ABOUT DEBIAN
rst2pdf
RST2PDF(1) General Commands Manual RST2PDF(1)
NAME
rst2pdf - Convert reStructuredText documents to PDF
SYNOPSIS
rst2pdf [options]
DESCRIPTION
The usual way of creating PDF from reStructuredText (ReST) is by going through LaTeX. The rst2pdf utility provides an alternative by pro-
ducing PDF directly using the ReportLab library.
OPTIONS
--output=FILE, -o FILE
Specify output location.
--stylesheet=STYLESHEET, -s STYLESHEET
Specify custom stylesheets (comma-seperated)
--compressed, -c
Create a compressed PDF.
--print-stylesheet
Print the default stylesheet and exit.
--language=LANG, -l LANG
Language to be used for hyphenation.
--break-level=LEVEL, -b LEVEL
Maximum section level that starts in a new page. (Default: 1)
--font-folder=FOLDER
Search this folder for fonts
--quiet, -q
Print less information.
--verbose, -v
Print debugging information.
--very-verbose
Print even more debugging information.
-help, -h
Show help message.
EXAMPLES
$ rst2pdf rest.txt -o out.pdf
Produce an out.pdf file which is a PDF version of the ReST document rest.txt.
AUTHOR
rst2pdf was written by Roberto Alsina <ralsina@netmanagers.com.ar>.
This manual page was written by Chris Lamb <chris@chris-lamb.co.uk>, for the Debian project (but may be used by others).
September 01, 2008 RST2PDF(1)