Sponsored Content
Full Discussion: isql - select ... where ...
Top Forums Shell Programming and Scripting isql - select ... where ... Post 302177369 by momi on Thursday 20th of March 2008 08:43:51 PM
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
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
explain_select_or_die(3)				     Library Functions Manual					  explain_select_or_die(3)

NAME
explain_select_or_die - blah blah and report errors SYNOPSIS
#include <libexplain/select.h> void explain_select_or_die(int nfds, fd_set *readfds, fd_set *writefds, fd_set *exceptfds, struct timeval *timeout); DESCRIPTION
The explain_select_or_die function is used to call the select(2) system call. On failure an explanation will be printed to stderr, obtained from explain_select(3), and then the process terminates by calling exit(EXIT_FAILURE). This function is intended to be used in a fashion similar to the following example: explain_select_or_die(nfds, readfds, writefds, exceptfds, timeout); nfds The nfds, exactly as to be passed to the select(2) system call. readfds The readfds, exactly as to be passed to the select(2) system call. writefds The writefds, exactly as to be passed to the select(2) system call. exceptfds The exceptfds, exactly as to be passed to the select(2) system call. timeout The timeout, exactly as to be passed to the select(2) system call. Returns: This function only returns on success. On failure, prints an explanation and exits. SEE ALSO
select(2) blah blah explain_select(3) explain select(2) errors exit(2) terminate the calling process COPYRIGHT
libexplain version 0.52 Copyright (C) 2008 Peter Miller explain_select_or_die(3)
All times are GMT -4. The time now is 02:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy