12-27-2012
Thanks Scott,
that helped me a lot!!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
What does the isql command do for solaris 8????
Is this something that comes with solaris because I have it at work but not at home.
Plus does anyone know a good SQL site where I could learn all the sql commands
thankx (2 Replies)
Discussion started by: eloquent99
2 Replies
2. UNIX for Dummies Questions & Answers
can anyone pls explain me the command
$ isql -Usa -SIN63DS -Pgoalmal
1>load database STS_IN_PRD from "/STSDBBakup/ AEOD20030509"
2>go
thx (2 Replies)
Discussion started by: girish_shukla
2 Replies
3. Shell Programming and Scripting
Hello all...
i'm trying to execute a shell script through crontab.
To run at 8pm on wednesday's
The crontab entry:
00 20 * * 3 /u2/dir1/dir2/jobs/p.sh
the p.sh file:
isql -s claims /u2/dir1/dir3/dir4/a.sql
permissions for it are -rwxrwx--x
i've confirmed a.sql is in that directory.
... (2 Replies)
Discussion started by: mrviking
2 Replies
4. Shell Programming and Scripting
Hi,
We are using isql in our scripts to connect to sybase dataserver on Solaris
See the following snippet:
isql -U${USER} -S${SERVER} -w999 <<- EOB
${PASSWD}
use ${QS_DBNAME}
go
EOB
The above code works even if there are spaces before the ${PASSWORD}
But if we... (1 Reply)
Discussion started by: justsam
1 Replies
5. Shell Programming and Scripting
Hi,
Please help me to solve this problem on Unix isql. Following is an example table and expected select result. I need to select NAMEs where those NAMEs don't have a record which TYPE='T1'. I tried, but got both N2 and N3.
NAME TYPE DATA
---------------------
N1 T1 D11
N2... (0 Replies)
Discussion started by: momi
0 Replies
6. Shell Programming and Scripting
hi all
i m running following code
# set up environment
. /u/pimms/pimms_global.ksh
echo "Get record from database"
#echo ${PIMMS_ID}
#echo ${PIMMS_PWD}
#echo "1"
isql -U${PIMMD_ID} -P${PIMMS_PWD} -S$SRV << eof > /sybase/applications/pimms/bin/automate1.txt
use pimms
... (6 Replies)
Discussion started by: d_swapneel14
6 Replies
7. Shell Programming and Scripting
I have been given an SQL script I need to convert to ISQl. In the styatement it has the following line which is flagging an error:
Select stocknum as 'bipart'
this comes up with: 201: A syntax error has occurred
Does ISQL support the SELCT AS statement and if not is there a simple... (2 Replies)
Discussion started by: andydb70
2 Replies
8. Shell Programming and Scripting
Hi All,
I'm niks and i'm a newbie here and newbie in shell, i'm just wondering what is the meaning of -U -P -S in the sample script below.
"-U iccbs_dbo -P iccbsdbo -S CCB_REO"
Thanks, (2 Replies)
Discussion started by: nikki1200
2 Replies
9. Shell Programming and Scripting
I have searched the forums and other sites and cannot come with the applicable approach for what I am trying to do. I am trying to setup a cron job that executes this script. The script uses iSQL - which is connecting ok - to then query a field and then assign that field to a variable to do an If... (4 Replies)
Discussion started by: courtneyjh
4 Replies
10. Programming
Hello,
I am having sybase database want to use ISQL to extract some data. Can someone please provide the link from where i can download freeware ISQL. Also documents which i can read and know
1. How to get he list of tables.
2. How to check data inside the table.
3. How to make queries etc.... (1 Reply)
Discussion started by: rajjev_saini123
1 Replies
XScreenSaver(1) General Commands Manual XScreenSaver(1)
NAME
drift - draws drifting recursive fractal cosmic flames
SYNOPSIS
drift [-display host:display.screen] [-foreground color] [-background color] [-window] [-root] [-mono] [-install] [-visual visual] [-ncol-
ors integer] [-delay microseconds] [-count integer] [-grow] [-no-grow] [-liss] [-no-liss]
DESCRIPTION
The drift program draws drifting recursive fractal cosmic flames
OPTIONS
drift accepts the following options:
-window Draw on a newly-created window. This is the default.
-root Draw on the root window.
-mono If on a color display, pretend we're on a monochrome display.
-install
Install a private colormap for the window.
-visual visual
Specify which visual to use. Legal values are the name of a visual class, or the id number (decimal or hex) of a specific visual.
-ncolors integer
How many colors should be used (if possible). Default 200. The colors used cycle through the hue, making N stops around the color
wheel.
-count integer
-grow
-no-grow
Whether fractals should grow; otherwise, they are animated.
-liss
-no-liss
Whether we should use lissojous figures to get points.
ENVIRONMENT
DISPLAY to get the default host and display number.
XENVIRONMENT
to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.
SEE ALSO
flame(1), X(1), xscreensaver(1), xlock(1)
COPYRIGHT
Copyright (C) 1991, 1995 by Scott Draves.
Permission to use, copy, modify, and distribute this software and its documentation for any purpose and without fee is hereby granted, pro-
vided that the above copyright notice appear in all copies and that both that copyright notice and this permission notice appear in sup-
porting documentation.
AUTHOR
Scott Draves <spot@cs.cmu.edu>, 06-Jun-91, 01-Jun-95.
Ability to run standalone or with xscreensaver added by Jamie Zawinski <jwz@jwz.org>, 10-May-97.
X Version 11 10-May-97 XScreenSaver(1)