Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

isql - select ... where ...

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting isql - select ... where ...
# 1  
Old 03-20-2008
isql - select ... where ...
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 T1 D21
N2 T2 D22
N3 T2 D32

output of the select:
NAME
-----
N3

Thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

New to ISQL

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

2. Shell Programming and Scripting

Can't log in with -P for isql

Hi all, I am a newbie with isql, so couldn't find what is the problem by myself. I am writing script at Solaris which will log in to DB, run some SELECT queries and put in to some file. The problem is that whe I am trying to log in with: /eniq/sybase_iq/OCS-15_0/bin/isql -U username -P... (4 Replies)
Discussion started by: nypreH
4 Replies

3. Shell Programming and Scripting

Need Help with isql in Shell Script

Hi Guys, I need help with my code. I am not able to find what the error is (tried debugging and everything). #! /bin/sh # MODSET_CLOSE # Usage: modset_close echo "Enter the Type of Modsets that needs to be Closed: " read mod_typ serv_name=`cat $mod_typ | awk '{ print $1 }'`... (5 Replies)
Discussion started by: gkrish
5 Replies

4. Shell Programming and Scripting

ISQL syntax

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

5. Shell Programming and Scripting

ISQL - SELECT AS

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

6. Shell Programming and Scripting

isql output

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

get values from isql query

hi all i have an isql sentence in a ksh script, what get some values from my database (Sybase IQ 12.5 - solaris 5.7) how can i read this sql results??? do i have to do a while?? a for??? where do i put the values?? my idea is put them in an array, is that possible? please, help me... (3 Replies)
Discussion started by: DebianJ
3 Replies

8. Shell Programming and Scripting

isql in shell script help

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

9. UNIX for Dummies Questions & Answers

regarding isql

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

10. UNIX for Dummies Questions & Answers

isql

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
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

osql

osql(1) 							 FreeTDS Utilities							   osql(1)

NAME

       osql - utility to test FreeTDS connections and queries

SYNOPSIS

       osql  -S dsn -U username -P password [-I ini_dir]

DESCRIPTION

       osql  is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
       everything checks out OK, it invokes isql.

       osql works only with the isql that comes with unixODBC.

OPTIONS

       -S dsn the Data Source Name to which to connect, as known to odbc.ini.

       -U username
	      database login name.

       -P password
	      database password.

       -I ini_dir
	      override odbc.ini file location.

EXAMPLE

       If you have an odbc.ini with a section like this:

	       [myDSN]
		       servername = myserver
		       TDS_Version = 5.0

       You would invoke osql as:

	       osql -S myDSN [...]

NOTES

       If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.

       osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach.  If  it  doesn't
       work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.

       If  osql  cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
       not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully  at	the  error  output  before
       overriding.

       If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.

HISTORY

       osql first appeared in FreeTDS 0.65.

AUTHORS

       The osql utility was written by James K. Lowden

doc								 13 November 2011							   osql(1)