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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT NETBSD
glob
GLOB(7) BSD Miscellaneous Information Manual GLOB(7)NAME
glob -- shell-style pattern matching
DESCRIPTION
Globbing characters (wildcards) are special characters used to perform pattern matching of pathnames and command arguments in the csh(1),
ksh(1), and sh(1) shells as well as the C library functions fnmatch(3) and glob(3). A glob pattern is a word containing one or more unquoted
'?' or '*' characters, or ``[..]'' sequences.
Globs should not be confused with the more powerful regular expressions used by programs such as grep(1). While there is some overlap in the
special characters used in regular expressions and globs, their meaning is different.
The pattern elements have the following meaning:
? Matches any single character.
* Matches any sequence of zero or more characters.
[..] Matches any of the characters inside the brackets. Ranges of characters can be specified by separating two characters by a '-' (e.g.
``[a0-9]'' matches the letter 'a' or any digit). In order to represent itself, a '-' must either be quoted or the first or last
character in the character list. Similarly, a ']' must be quoted or the first character in the list if it is to represent itself
instead of the end of the list. Also, a '!' appearing at the start of the list has special meaning (see below), so to represent
itself it must be quoted or appear later in the list.
Within a bracket expression, the name of a character class enclosed in '[:' and ':]' stands for the list of all characters belonging
to that class. Supported character classes:
alnum cntrl lower space
alpha digit print upper
blank graph punct xdigit
These match characters using the macros specified in ctype(3). A character class may not be used as an endpoint of a range.
[!..] Like [..], except it matches any character not inside the brackets.
Matches the character following it verbatim. This is useful to quote the special characters '?', '*', '[', and '' such that they
lose their special meaning. For example, the pattern ``\*[x]?'' matches the string ``*[x]?''.
Note that when matching a pathname, the path separator '/', is not matched by a '?', or '*', character or by a ``[..]'' sequence. Thus,
/usr/*/*/X11 would match /usr/X11R6/lib/X11 and /usr/X11R6/include/X11 while /usr/*/X11 would not match either. Likewise, /usr/*/bin would
match /usr/local/bin but not /usr/bin.
SEE ALSO fnmatch(3), glob(3), re_format(7)HISTORY
In early versions of UNIX, the shell did not do pattern expansion itself. A dedicated program, /etc/glob, was used to perform the expansion
and pass the results to a command. In Version 7 AT&T UNIX, with the introduction of the Bourne shell, this functionality was incorporated
into the shell itself.
BSD November 30, 2010 BSD