Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parse SQL text and only format first SELECT statement.
Top Forums Shell Programming and Scripting Parse SQL text and only format first SELECT statement. Post 302849017 by pchang on Friday 30th of August 2013 03:55:18 PM
Old 08-30-2013
Parse SQL text and only format first SELECT statement.
Hi Forum.

Need your expertise on the following question.

I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited):

Code:
Old File:
SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */
        CCOMM.CAMPAIGN_SK AS CAMPAIGN_SK,
         CCOMM.CONTACT_DTTM AS ENTRY_DATE,
         '1005' AS COST_CENTRE,
         SCPA.CIF AS CIF
    FROM (  SELECT /*+ USE_HASH(CCP CCCH CC CCE CCOMM CCOMME) */
                  MAX (CCP.CAMPAIGN_SK) AS CAMPAIGN_SK,
                   CCCH.CUSTOMER_KEY AS CUSTOMER_KEY,
                   MAX (TRUNC (CCCH.CONTACT_DTTM)) AS CONTACT_DTTM,
                   MAX (CCOMME.OFFER) AS OFFER,
                   MIN (CCE.CAMPAIGN_START_DATE) AS CAMPAIGN_START_DATE,
                   MAX (CCE.CAMPAIGN_END_DATE) AS CAMPAIGN_END_DATE
              FROM SAS_MA.CI_CELL_PACKAGE CCP,
                   SAS_MA.CI_CUST_CONTACT_HISTORY CCCH,
                   SAS_MA.CI_CAMPAIGN CC,
                   SAS_MA.CI_CAMPAIGN_EXT CCE,
                   SAS_MA.CI_COMMUNICATION CCOMM,
                   SAS_MA.CI_COMMUNICATION_EXT CCOMME
                   .....

Code:
Desired File:
SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */
CCOMM.CAMPAIGN_SK||'~'||CCOMM.CONTACT_DTTM||'~'||'1005'||'~'||SCPA.CIF
    FROM (  SELECT /*+ USE_HASH(CCP CCCH CC CCE CCOMM CCOMME) */
                  MAX (CCP.CAMPAIGN_SK) AS CAMPAIGN_SK,
                   CCCH.CUSTOMER_KEY AS CUSTOMER_KEY,
                   MAX (TRUNC (CCCH.CONTACT_DTTM)) AS CONTACT_DTTM,
                   MAX (CCOMME.OFFER) AS OFFER,
                   MIN (CCE.CAMPAIGN_START_DATE) AS CAMPAIGN_START_DATE,
                   MAX (CCE.CAMPAIGN_END_DATE) AS CAMPAIGN_END_DATE
              FROM SAS_MA.CI_CELL_PACKAGE CCP,
                   SAS_MA.CI_CUST_CONTACT_HISTORY CCCH,
                   SAS_MA.CI_CAMPAIGN CC,
                   SAS_MA.CI_CAMPAIGN_EXT CCE,
                   SAS_MA.CI_COMMUNICATION CCOMM,
                   SAS_MA.CI_COMMUNICATION_EXT CCOMME
                   .....

Thank you for all feedback/insight that you may have.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Hello I would like to perform a select from a oracle table and return those values to my shell script For example: site=head -1 $infile | cut -c1-15 | awk '{printf "s%", $0} sqlplus -s /nolog |& #Open pipe to sql select col1, col2, col3, col4 from oracle_table where col5 =... (6 Replies)
Discussion started by: houtakker
6 Replies

2. UNIX and Linux Applications

Oracle Select IN statement

If I recall, when I used informix I could do a sql statement like: SELECT Value from Table WHERE ID in (100,200,300); How do I do this in Oracle? I believe I am using Oracle 10 if that matters. Thanks. (1 Reply)
Discussion started by: benefactr
1 Replies

3. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Discussion started by: hcclnoodles
4 Replies

4. Shell Programming and Scripting

How can i assign an select statement into a variable?

I am trying to assign an select statement into a variable. Can someone hel me with this. example : a='select * from dual' echo $a should give me select * from dual But this is not working. I trying with \ before * and quotes too. (1 Reply)
Discussion started by: rdhanek
1 Replies

5. Shell Programming and Scripting

Select variable within a if statement

i want to select a variable created and use it in a if statement, but not getting the desired results LINE='device for 0101a01: lpd://172.25.41.111:515' prt=`echo $LINE | awk '{print $3 }' | cut -c 1-7` echo $prt My if statement to select just what i want.. IFS=$":" while read prt... (11 Replies)
Discussion started by: ggoliath
11 Replies

6. Shell Programming and Scripting

for each value in an array, execute select statement

Hello All, I am new to shell scripting. I am working on Solaris O/S, bash script and sybase programming. I want to loop through multiple values in an array and for each value, I want to select a row from the database. following is the code written for it. output="loop.csv" ... (8 Replies)
Discussion started by: arundhati_s
8 Replies

7. Shell Programming and Scripting

script to parse text file into sql commands

Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need. In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script: ---filename... (3 Replies)
Discussion started by: hamanjam
3 Replies

8. Shell Programming and Scripting

Problem with select statement

Hi I have run out of ideas as to why this select doesn't work in a script I am writing. The script sources a file of common functions and I am trying to use a select statement within one of the functions - PS3="Try? " select X in CONT EXIT; do if ] ... (4 Replies)
Discussion started by: steadyonabix
4 Replies

9. Shell Programming and Scripting

Help with awk statement to format text file.

Hello, I am fairly new to shellscripting and have written a script to check on messages file and report failed logins: Here is the original file: Jul 17 03:38:07 sfldmilx086 sshd: error: PAM: Authentication failure for houghn97 from 10.135.77.201 Jul 17 03:38:07 sfldmilx086 sshd: error:... (2 Replies)
Discussion started by: neilh1704
2 Replies

10. Shell Programming and Scripting

SQLPLUS command with more than 1 select statement

Hi all, I'm using below code processId=`sqlplus -s ${sysuser}/${syspwd} <<CHK_PROCESS whenever sqlerror exit sql.sqlcode; set head off feedback off echo off pages 0 SELECT PROCESS_ID FROM LSHADMIN.DATA_DOMAIN WHERE DOMAIN_NAME = '${tabname}' ... (8 Replies)
Discussion started by: Pratiksha Mehra
8 Replies

LEARN ABOUT DEBIAN

ng_deflate

NG_DEFLATE(4)						   BSD Kernel Interfaces Manual 					     NG_DEFLATE(4)

NAME

     ng_deflate -- Deflate PPP compression (RFC 1979) netgraph node type

SYNOPSIS

     #include <sys/types.h>
     #include <netgraph/ng_deflate.h>

DESCRIPTION

     The deflate node type implements the Deflate sub-protocols of the Compression Control Protocol (CCP).

     The node has two hooks, comp for compression and decomp for decompression.  Only one of them can be connected at the same time, specifying
     node's operation mode.  Typically that hooks would be connected to the ng_ppp(4) node type hook of the same name.	Corresponding ng_ppp(4)
     node hook must be switched to NG_PPP_DECOMPRESS_FULL mode to permit sending uncompressed frames.

HOOKS

     This node type supports the following hooks:

     comp    Connection to ng_ppp(4) comp hook.  Incoming frames are compressed (if possible) and sent back out the same hook.
     decomp  Connection to ng_ppp(4) decomp hook.  Incoming frames are decompressed (if they are compressed), and sent back out the same hook.

     Only one hook can be connected at the same time, specifying node's operation mode.

CONTROL MESSAGES

     This node type supports the generic control messages, plus the following:

     NGM_DEFLATE_CONFIG (config)
	  This command resets and configures the node for a session (i.e., for compression or decompression).  This command takes a struct
	  ng_deflate_config as an argument:

	  struct ng_deflate_config {
		  u_char  enable;		  /* node enabled */
		  u_char  windowBits;		  /* log2(Window size) */
	  };
	  The enabled field enables traffic flow through the node.  The windowBits specify compression windows size as negotiated by the Compres-
	  sion Control Protocol (CCP) in PPP.

     NGM_DEFLATE_RESETREQ (resetreq)
	  This message contains no arguments, and is bi-directional.  If an error is detected during decompression, this message is sent by the
	  node to the originator of the NGM_DEFLATE_CONFIG message that initiated the session.	The receiver should respond by sending a PPP CCP
	  Reset-Request to the peer.

	  This message may also be received by this node type when a CCP Reset-Request or Reset-Ack is received by the local PPP entity.  The node
	  will respond by flushing its compression state so the sides can resynchronize.

     NGM_DEFLATE_GET_STATS (getstats)
	  This control message obtains statistics for a given hook.  The statistics are returned in struct ng_deflate_stats:

	  struct ng_deflate_stats {
		  uint64_t	  FramesPlain;
		  uint64_t	  FramesComp;
		  uint64_t	  FramesUncomp;
		  uint64_t	  InOctets;
		  uint64_t	  OutOctets;
		  uint64_t	  Errors;
	  };

     NGM_DEFLATE_CLR_STATS (clrstats)
	  This control message clears statistics for a given hook.

     NGM_DEFLATE_GETCLR_STATS (getclrstats)
	  This control message obtains and clears statistics for a given hook.

SHUTDOWN

     This node shuts down upon receipt of a NGM_SHUTDOWN control message, or when hook have been disconnected.

SEE ALSO

     netgraph(4), ng_ppp(4), ngctl(8)

     J. Woods, PPP Deflate Protocol, RFC 1979.

     W. Simpson, The Point-to-Point Protocol (PPP), RFC 1661.

AUTHORS

     Alexander Motin <mav@alkar.net>

BUGS

     Due to nature of netgraph PPP implementation there are possible race conditions between data packet and ResetAck CCP packet in case of packet
     loss. As result, packet loss can produce bigger performance degradation than supposed by protocol.

BSD
								 December 23, 2006							       BSD
All times are GMT -4. The time now is 04:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy