isql can't read code

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting isql can't read code
# 1  
Old 08-09-2011
isql can't read code

Hi Guys,

I'm a newbie here can you please help me reading this code. because i'm confuse.

        into bash_temp -- is this create a table name bash_temp?
    and b.field_id='USERID'

    into bash_temp2 
    from bash_temp 
    group by field_value
        into bash_temp3 -- is this create a table name bash temp3?
        from ${REO_SWITCH_USERID_LUZON_DB} a
        left join bash_temp2 b
    from bash_temp3 where inst_st_dt not in (NULL,null,'',"")
    drop table bash_temp
    drop table bash_temp2

BASH_COUNT=`${SERVER_DATABASE} -b << EOF 2>>/dev/null
SET nocount on
select count(*) from ${REO_BASH_USERID_LUZON_ICCBS}

# 2  
Old 08-09-2011
Would you please explain what the problem is? Is this a shell script? Is this a SQL script that you are trying to execute is ISQL directly?
This User Gave Thanks to g.pi For This Post:
# 3  
Old 08-09-2011
Hi Sir,

this is a shell script that i'm trying to execute using isql. i just don't understand the code, because i'm a newbie sorry.

# 4  
Old 08-09-2011
This is a shell script (a fragment) with embedded sql queries (as here documents). To understand the code you need to know shell programming and sql language. If your questions are in comments then yes, these statements creates new tables.
This User Gave Thanks to yazu For This Post:
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

return code of read and/or for

I am trying to validate an ip address, based on what is in the netmasks file, I have a function that checks the values of the ip against the network and netmask, this returns a 1 if the ip doesn't match and a 0 if the IP does. ##################### #Validate IP Network#... (1 Reply)
Discussion started by: eeisken
1 Replies

4. Shell Programming and Scripting

ISQL syntax can't read

Hi Everyone, newbie here, please help me i can't read the code i'm confused reading this code. select c.net_svc_id, c.inst_st_dt into ${REO_RECON_USERID_LUZON_TEMP} from ${WO_INST_SITE_COMP_FIELDS} a, ${WO_INST_SITE_COMPONENTS} b, ${WO_INST} c where a.cust_ac_no = b.cust_ac_no and... (3 Replies)
Discussion started by: nikki1200
3 Replies

5. Shell Programming and Scripting

can't read the code.

Hi All, I'm a newbie here, can you help me tried to figure out this code. i know that this code is to check the path directory, however when i tried to run the scripts it always says error even though the folder is exist. CHECK_PATH_FXN() { _CHECK_PATH=$1 if then ${ECHO_CMD} "ERROR :... (4 Replies)
Discussion started by: nikki1200
4 Replies

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

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

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

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


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