Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: ISQL syntax can't read
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
Old 08-05-2011
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:
nikki1200
 

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

LEARN ABOUT PHP

iconv_mime_encode

ICONV_MIME_ENCODE(3)							 1						      ICONV_MIME_ENCODE(3)

iconv_mime_encode - Composes a MIMEheader field

SYNOPSIS

       string iconv_mime_encode NULL (string  $field_name, string  $field_value, [array  $preferences])

DESCRIPTION

	Composes and returns a string that represents a valid MIME header field, which looks like the following:

       Subject: =?ISO-8859-1?Q?Pr=FCfung_f=FCr?= Entwerfen von einer MIME kopfzeile

PARAMETERS

	      o $field_name
		- The field name.

	      o $field_value
		- The field value.

	      o $preferences
		-  You	can  control the behaviour of iconv_mime_encode(3) by specifying an associative array that contains configuration items to
		the optional third parameter $preferences. The items supported by iconv_mime_encode(3) are listed below. Note that item names  are
		treated case-sensitive.

	      Configuration items supported by iconv_mime_encode(3)

	      +-----------------+--------------------------+---+---+---+
	      |      Item	|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	    Type	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	Description	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|      Default value	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	  Example	   |   |   |   |
	      | 		|			   |   |   |   |
	      +-----------------+--------------------------+---+---+---+
	      |     scheme	|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	   string	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|  Specifies the method to |   |   |   |
	      | 		| encode a field value by. |   |   |   |
	      | 		| The  value  of this item |   |   |   |
	      | 		| may  be  either  "B"	or |   |   |   |
	      | 		| "Q",	where  "B"  stands |   |   |   |
	      | 		| for	base64	  encoding |   |   |   |
	      | 		| scheme  and  "Q"  stands |   |   |   |
	      | 		| for	  quoted-printable |   |   |   |
	      | 		| encoding scheme.	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	     B		   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	     B		   |   |   |   |
	      | 		|			   |   |   |   |
	      | input-charset	|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	   string	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|  Specifies the character |   |   |   |
	      | 		| set in which	the  first |   |   |   |
	      | 		| parameter    $field_name |   |   |   |
	      | 		| and the second parameter |   |   |   |
	      | 		| $field_value	 are  pre- |   |   |   |
	      | 		| sented.  If  not  given, |   |   |   |
	      | 		| iconv_mime_encode(3)	   |   |   |   |
	      | 		| assumes those parameters |   |   |   |
	      | 		| are  presented  to it in |   |   |   |
	      | 		| the	      iconv.inter- |   |   |   |
	      | 		| nal_encoding	 ini  set- |   |   |   |
	      | 		| ting. 		   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		| iconv.internal_encoding  |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	 ISO-8859-1	   |   |   |   |
	      | 		|			   |   |   |   |
	      | output-charset	|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	   string	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|  Specifies the character |   |   |   |
	      | 		| set  to  use	to compose |   |   |   |
	      | 		| the MIME header.	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		| iconv.internal_encoding  |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	   UTF-8	   |   |   |   |
	      | 		|			   |   |   |   |
	      |  line-length	|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	  integer	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|  Specifies  the  maximum |   |   |   |
	      | 		| length   of  the  header |   |   |   |
	      | 		| lines.   The	 resulting |   |   |   |
	      | 		| header  is "folded" to a |   |   |   |
	      | 		| set of multiple lines in |   |   |   |
	      | 		| case	  the	 resulting |   |   |   |
	      | 		| header  field  would	be |   |   |   |
	      | 		| longer than the value of |   |   |   |
	      | 		| this parameter,  accord- |   |   |   |
	      | 		| ing  to RFC2822 - Inter- |   |   |   |
	      | 		| net Message  Format.	If |   |   |   |
	      | 		| not  given,  the  length |   |   |   |
	      | 		| will be  limited  to	76 |   |   |   |
	      | 		| characters.		   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	     76 	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	    996 	   |   |   |   |
	      | 		|			   |   |   |   |
	      |line-break-chars |			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	   string	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|  Specifies  the sequence |   |   |   |
	      | 		| of characters to  append |   |   |   |
	      | 		| to  each line as an end- |   |   |   |
	      | 		| of-line sign when "fold- |   |   |   |
	      | 		| ing"	is  performed on a |   |   |   |
	      | 		| long	header	field.	If |   |   |   |
	      | 		| not given, this defaults |   |   |   |
	      | 		| to "
" ( CR LF). Note |   |   |   |
	      | 		| that	this  parameter is |   |   |   |
	      | 		| always  treated  as	an |   |   |   |
	      | 		| ASCII  string regardless |   |   |   |
	      | 		| of the value	of  input- |   |   |   |
	      | 		| charset.		   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	    
	   |   |   |   |
	      | 		|			   |   |   |   |
	      | 		|	     
 	   |   |   |   |
	      | 		|			   |   |   |   |
	      +-----------------+--------------------------+---+---+---+
RETURN VALUES

	Returns an encoded MIME field on success, or FALSE if an error occurs during the encoding.

EXAMPLES

       Example #1

	      iconv_mime_encode(3) example

	      <?php
	      $preferences = array(
		  "input-charset" => "ISO-8859-1",
		  "output-charset" => "UTF-8",
		  "line-length" => 76,
		  "line-break-chars" => "
"
	      );
	      $preferences["scheme"] = "Q";
	      // This yields "Subject: =?UTF-8?Q?Pr=C3=BCfung=20Pr=C3=BCfung?="
	      echo iconv_mime_encode("Subject", "Prufung Prufung", $preferences);

	      $preferences["scheme"] = "B";
	      // This yields "Subject: =?UTF-8?B?UHLDvGZ1bmcgUHLDvGZ1bmc=?="
	      echo iconv_mime_encode("Subject", "Prufung Prufung", $preferences);
	      ?>

SEE ALSO

       imap_binary(3), mb_encode_mimeheader(3), imap_8bit(3), quoted_printable_encode(3).

PHP Documentation Group 												      ICONV_MIME_ENCODE(3)
All times are GMT -4. The time now is 01:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy