Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk script to parse SQL from Pro*C program
Top Forums Shell Programming and Scripting awk script to parse SQL from Pro*C program Post 302868699 by mvalonso on Monday 28th of October 2013 02:16:27 PM
Old 10-28-2013
Somthing like:

TABLE1, TABLE2, ...

or

TABLE1
TABLE2

just the names of the tables appearing in the FROM clause.
Thks.

---------- Post updated at 03:16 PM ---------- Previous update was at 03:12 PM ----------

But all the tables in all SELECT statements.
Please note that there can be SELECT without WHERE clause and there can also be some subselects like in:

Code:
	EXEC SQL SELECT ID
	INTO :twl_partition
	FROM (SELECT (ROWNUM-1) ID FROM PERIODE WHERE ROWNUM         <= :wl_nb_partition)
	WHERE :dlg_no_process = MOD(ID, :dlg_nb_process );

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pro*c program for sql query

Hi all, I have sql query as follows. Please write a pro*c program for the following query. select sp1.cost_change ||','|| sp1.cost_change_desc ||','|| sp1.reason ||','|| to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS') ||','|| sp1.status ||','|| sp1.cost_change_origin... (0 Replies)
Discussion started by: user71408
0 Replies

2. UNIX for Dummies Questions & Answers

PRo*C program for SQL queries using threading concept

Hi All, I have written 4 SQL queries. I want to write PRO*C program for this. I want to put these 4 queries in a single PR*C program using threading concept. Please guide me to write the pogram. the queries are as follows. 1. select * from head; 2. select * from details; 3. delete from head... (0 Replies)
Discussion started by: user71408
0 Replies

3. Programming

problem with sql command in pro*c

In a pro*C program, I use query follow: INSERT INTO radacct_wk SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime, acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress FROM radacct@DBSV_B;... (7 Replies)
Discussion started by: quynhtrang
7 Replies

4. Shell Programming and Scripting

awk script to parse results from TWO files

I am trying to parse two files and get data that does not match in one of the columns ( column 3 in my case ) Data for two files are as follows A.txt ===== abc 10 5 0 1 16 xyz 16 1 1 0 18 efg 30 8 0 2 40 ijk 22 2 0 1 25 B.txt ===== abc... (6 Replies)
Discussion started by: roger67
6 Replies

5. Programming

Do pro*c program need to recompile

hi, I have pro*c program running on sunsolaris 5.9.Currently the same program has been migrated to solaris 5.10.But the program is not giving the desired output.Do i need to recomplie the source code again. Regards, Megh (4 Replies)
Discussion started by: megh
4 Replies

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

7. Programming

Sql Procedure in Pro C file

Hi, Can any one help me how to write a sql procedure in a pro *c file for selecting the data from a database and inserting the rows into a queue in a .pc file. thanx in advance. (1 Reply)
Discussion started by: jhon1257
1 Replies

8. Shell Programming and Scripting

AWK script to parse a data in a file

Hi Unix gurus.. I have a file which has below data, It has several MQ Queue statistics; QueueName= 'TEST1' CreateDate= '2009-10-30' CreateTime= '13.45.40' QueueType= Predefined QueueDefinitionType= Local QMinDepth= 0 QMaxDepth= 0 QueueName= 'TEST2' CreateDate= '2009-10-30'... (6 Replies)
Discussion started by: dd_psg
6 Replies

9. Shell Programming and Scripting

awk Script to parse a XML tag

I have an XML tag like this: <property name="agent" value="/var/tmp/root/eclipse" /> Is there way using awk that i can get the value from the above tag. So the output should be: /var/tmp/root/eclipse Help will be appreciated. Regards, Adi (6 Replies)
Discussion started by: asirohi
6 Replies

LEARN ABOUT DEBIAN

sql::reservedwords::postgresql

SQL::ReservedWords::PostgreSQL(3pm)			User Contributed Perl Documentation		       SQL::ReservedWords::PostgreSQL(3pm)

NAME

       SQL::ReservedWords::PostgreSQL - Reserved SQL words by PostgreSQL

SYNOPSIS

	  if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) {
	      print "$word is a reserved PostgreSQL word!";
	  }

DESCRIPTION

       Determine if words are reserved by PostgreSQL.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3, 7.4, 8.0 or 8.1.

       is_reserved_by_postgresql7( $word )
	   Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3 or 7.4.

       is_reserved_by_postgresql8( $word )
	   Returns a boolean indicating if $word is reserved by either PostgreSQL 8.0 or 8.1.

       reserved_by( $word )
	   Returns a list with PostgreSQL versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_postgresql7
       is_reserved_by_postgresql8
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www.postgresql.org/docs/manuals/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28				       SQL::ReservedWords::PostgreSQL(3pm)
All times are GMT -4. The time now is 08:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy