07-24-2014
When you have isql installed, to list tables just type help and push <GO> button. Your question 2 is not clear. To query data you just type the query in the isql query area and hit <GO>, use <BLANK> key to start over
This User Gave Thanks to migurus For This Post:
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
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
4. 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
5. Shell Programming and Scripting
Hi
I wrote a script for connecting isql(Sybase database) and stored the SQL output in Unix box.
my script:
isql -U${USER} -P${PASS} -S${SERVER} <<EOF > $WORK_DIR/out1.log
go
select convert(varchar(10),sdcurrent,101) from pr_sysdate
go
exit
EOF
Unfortunately, the output file not... (5 Replies)
Discussion started by: koti_rama
5 Replies
6. 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
7. 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
8. Shell Programming and Scripting
Hi Guys,
I'm a newbie here can you please help me reading this code. because i'm confuse.
select
b.field_value,
b.cust_ac_no,
b.net_svc_id,
b.inst_seq_no,
b.field_id,
b.comp_status,
b.inst_status,
b.inststdt
into bash_temp -- is this... (3 Replies)
Discussion started by: nikki1200
3 Replies
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
ares_mkquery
ARES_MKQUERY(3) Library Functions Manual ARES_MKQUERY(3)
NAME
ares_mkquery - Compose a single-question DNS query buffer
SYNOPSIS
#include <ares.h>
int ares_mkquery(const char *name, int dnsclass, int type,
unsigned short id, int rd, unsigned char **buf,
int *buflen)
DESCRIPTION
The ares_mkquery function composes a DNS query with a single question. The parameter name gives the query name as a NUL-terminated C
string of period-separated labels optionally ending with a period; periods and backslashes within a label must be escaped with a backlash.
The parameters dnsclass and type give the class and type of the query using the values defined in <arpa/nameser.h>. The parameter id gives
a 16-bit identifier for the query. The parameter rd should be nonzero if recursion is desired, zero if not. The query will be placed in
an allocated buffer, a pointer to which will be stored in the variable pointed to by buf, and the length of which will be stored in the
variable pointed to by buflen. It is the caller's responsibility to free this buffer using ares_free_string(3) when it is no longer
needed.
RETURN VALUES
ares_mkquery can return any of the following values:
ARES_SUCCESS Construction of the DNS query succeeded.
ARES_EBADNAME The query name name could not be encoded as a domain name, either because it contained a zero-length label or because it
contained a label of more than 63 characters.
ARES_ENOMEM Memory was exhausted.
SEE ALSO
ares_expand_name(3), ares_free_string(3)
AUTHOR
Greg Hudson, MIT Information Systems
Copyright 1998, 2000 by the Massachusetts Institute of Technology.
20 Nov 2009 ARES_MKQUERY(3)