Sponsored Content
Full Discussion: ISQL syntax can't read
Top Forums Shell Programming and Scripting ISQL syntax can't read Post 302545773 by DGPickett on Tuesday 9th of August 2011 01:01:11 PM
Old 08-09-2011
I prefer the ansi join, which enables more join options ( inner and right, left, full outer ) and sometimes helps optimization:
Code:
select
  c.net_svc_id,
  c.inst_st_dt
 into ${REO_RECON_USERID_LUZON_TEMP} -- Creates a table
 from -- three way inner join using where
  ${WO_INST_SITE_COMP_FIELDS} a -- assume variables have relation names
 join ${WO_INST_SITE_COMPONENTS} b
  ON    a.cust_ac_no = b.cust_ac_no
    and a.inst_seq_no = b.inst_seq_no
    and a.site_no = b.site_no
    and a.comp_no = b.comp_no
    and a.comp_type = b.comp_type
 join ${WO_INST} c
  ON    b.cust_ac_no = c.cust_ac_no
    and b.inst_seq_no = c.inst_seq_no
 where a.field_id = 'USERID'
    and a.field_value like '%@globelines.com.ph%'
    and convert( char(8), c.inst_st_dt, 112) <= "${ICCBS_DATE}" -- better to compare as datetime not char.

 

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

write() / read() syntax

hi am newbie to unix and socket programing I am trying to figuring out syntax for read and write to send data from server to client and client can read it I have to send two integers write(newsockfd,buffer,"%d %d",x,y,0) writing from client where x and y are two integers.. ... (7 Replies)
Discussion started by: karthik1238
7 Replies

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

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

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

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

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

9. Shell Programming and Scripting

Isql syntax error in UNIX script

Hello Everyone, Coming again for your help to solve the below error: In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully) and I wanted to move it to the preferred table (called Main_table) for further use. hence I have added... (1 Reply)
Discussion started by: Suresh
1 Replies

10. UNIX for Advanced & Expert Users

Isql and If Exist syntax error in UNIX script

Hello Everyone, Coming again for your help to solve the below error: In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully) and I wanted to move it to the preferred table (called Main_table) for further use. hence I have added... (7 Replies)
Discussion started by: Suresh
7 Replies
QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME
qrencode - Encode input data in a QR Code and save as a PNG or EPS image. SYNOPSIS
qrencode [OPTION]... [STRING] DESCRIPTION
Libqrencode is a library for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness. Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image. OPTIONS
-h, --help display help message. -o FILENAME, --output=FILENAME write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured symbols are written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified) -s NUMBER, --size=NUMBER specify the size of dot (pixel). (default=3) -l {LMQH}, --level={LMQH} specify error collectin level from L (lowest) to H (highest). (default=L) -v NUMBER, --symversion=NUMBER specify the version of the symbol. (default=auto) -m NUMBER, --margin=NUMBER specify the width of margin. (default=4) -d NUMBER, --dpi=NUMBER specify the DPI of the generated PNG. (default=72) -t {PNG,EPS,ANSI,ANSI256}, --type={PNG,EPS,ANSI,ANSI256} specify the type of the generated image. (default=PNG) -S, --structured make structured symbols. Version must be specified. -k, --kanji assume that the input text contains kanji (shift-jis). -c, --casesensitive encode lower-case alphabet characters in 8-bit mode. (default) -i, --ignorecase ignore case distinctions and use only upper-case characters. -8, --8bit encode entire data in 8-bit mode. -k, -c and -i will be ignored. -M, --micro encode in a Micro QR Code. (experimental) -V, --version display the version number and copyrights of the qrencode. [STRING] input data. If it is not specified, data will be taken from standard input. EXAMPLES
qrencode -l L -v 1 -o output.png 'Hello, world!' encode into a symbol version 1, level L. qrencode -iSv 1 --output=output.png read standard input and encode it into a structured-appended symbols in case-insensitive mode. AUTHOR
Written by Kentaro Fukuchi. RESOURCES
Main Web Site: http://fukuchi.org/works/qrencode/ Source code repository: https://github.com/fukuchi/libqrencode/ COPYRIGHT
Copyright (C) 2006-2012 Kentaro Fukuchi. qrencode 3.3.0 Feb. 29, 2012 QRENCODE(1)
All times are GMT -4. The time now is 10:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy