Sponsored Content
Full Discussion: New to ISQL
Top Forums Programming New to ISQL Post 302910450 by migurus on Thursday 24th of July 2014 02:38:52 PM
Old 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

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 - 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... (0 Replies)
Discussion started by: momi
0 Replies

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

5. Shell Programming and Scripting

isql out in shell script

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

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

isql can't read code

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

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

10. 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
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)
All times are GMT -4. The time now is 01:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy