ISQL syntax can't read Post: 302544865

Sponsored Content

Top Forums Shell Programming and Scripting ISQL syntax can't read Post 302544865 by DGPickett on Friday 5th of August 2011 08:53:30 AM

08-05-2011

Registered User

Formatting and -- comments, and assuming the $ variables expand to simple items:

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
  ${WO_INST_SITE_COMPONENTS} b,
  ${WO_INST} c
 where 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
    and b.cust_ac_no = c.cust_ac_no
    and b.inst_seq_no = c.inst_seq_no
    and 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.
 
select
  net_svc_id,
  max(inst_st_dt) inststdt
 into ${REO_RECON_USERID_LUZON_UPDATE} -- creates a table
 from ${REO_RECON_USERID_LUZON_TEMP}
 group by net_svc_id

Unless tables get repeat or delayed use, you can put them into derived tables of the using query.

Last edited by DGPickett; 08-05-2011 at 10:01 AM..

This User Gave Thanks to DGPickett For This Post:

DGPickett

View Public Profile for DGPickett

Find all posts by DGPickett

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

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

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

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,

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

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

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

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

10. UNIX for Advanced & Expert Users

Isql and If Exist syntax error in UNIX script

LEARN ABOUT PHP

dbplus_rcreate

DBPLUS_RCREATE(3)							 1							 DBPLUS_RCREATE(3)

dbplus_rcreate - Creates a new DB++ relation

SYNOPSIS

       resource dbplus_rcreate (string	$name, mixed  $domlist, [bool  $overwrite])

DESCRIPTION

	Creates  a  new  relation.  Any  existing  relation sharing the same $name will be overwritten if the relation is currently not in use and
       $overwrite is set to TRUE.

PARAMETERS

	      o $name
		-

	      o $domlist
		- A combination of domains. May be passed as a single domain name string or as an array of domain names.   This  parameter  should
		contain  the  domain specification for the new relation within an array of domain description strings. A domain description string
		consists of a domain name unique to this relation, a slash and a type specification character. See the db++  documentation,  espe-
		cially the dbcreate(1) manpage, for a description of available type specifiers and their meanings.

	      Note

		      This  function  will  also  accept a string with space delimited domain description strings, but it is recommended to use an
		     array

	      o $overwrite
		-

RETURN VALUES

NOTES

       Warning

	      This function is EXPERIMENTAL. The behaviour of this function, its name, and surrounding documentation may change without notice	in
	      a future release of PHP. This function should be used at your own risk.

PHP Documentation Group 													 DBPLUS_RCREATE(3)