PRo*C program for SQL queries using threading concept Post: 302197415

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL queries in background?

I have to query a DB2 database, and sometimes they take a long time to produce results. Can I run these queries in the background, and if so, where will the results appear?

2. Shell Programming and Scripting

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

3. UNIX for Dummies Questions & Answers

shell script for sql queries

Hi All, I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries... i.e 1.select * from head; 2. select * from detail; 3. delete from head; 4. delete from detail; Please let me know how to write a shell script... Thank you

4. Shell Programming and Scripting

Select SQL Queries Option

count.sh#!/bin/ksh SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3` SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3` LIST="Count Select_All" select i in $LIST do if then echo $SQL1 elif then echo $SQL2 fi done

5. Shell Programming and Scripting

Code needed to get sql queries

Hi i need code to get sql queries through a shell script for a text file input which contain the service ids iputfile I-H-2048-10GB-M I-H-4096-12GB-M I-H-2048-p1000-M the code should contain below queries among which service_id is replacable with value from input file. ...

6. Shell Programming and Scripting

awk script to parse SQL from Pro*C program

Hello, I have a Pro*C program which contains SQL sentences, such as: .... Pro*C sentences .... /*SQL 1*/ EXEC SQL SELECT t1.field1, t1.field2 INTO :w_field FROM TABLE1 t1, TABLE1 t2 WHERE t1.field1 = t2.field1 AND t1.ID = :wl_id; .... Pro*C sentences .... /*SQL 1*/ EXEC...

7. AIX

Convert MS Access Queries to AIX SQL

Unix Team, I'm a recent college graduate entering in the " real world" and boy let me tell you it can quite challenging. I just got a job with a large fortune 50 company lets just say that my expectations and tasks have expanded since I first got hired. Last week I got assigned a pretty big...

8. Programming

Join 2 SQL queries into one

Dear community, could someone help me to join 2 queries into one? Basically it's the same query with different clauses (please notice the FIELD3 filters and related counters into the subquery): SELECT A.FIELD1,A.FIELD2,A.FIELD3 FROM TABLE A INNER JOIN ( SELECT FIELD1,...

9. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

LEARN ABOUT DEBIAN

lurker-search

LURKER-SEARCH(1)					      General Commands Manual						  LURKER-SEARCH(1)

NAME

       lurker-search -- searches for messages in a lurker database

SYNOPSIS

       lurker-search [-c <config-file>]  [-k <keyword>]  [-d -f -i -v -q]  [<terms>*]

DESCRIPTION

       lurker-search searches a lurker database the same way as the web interface. It can output summary information and delete messages.

OPTIONS

       -c config-file
		 Use this config file for lurker settings.

       -k keyword
		 Tag the matching messages with this keyword.

       -d	 Delete the messages found by this search

       -f	 Don't prompt before deleting

       -i	 Command line paramers are not search terms, but message IDs.

       -v	 Output message summary information

       -q	 Don't output message ids or status

SEARCH TERMS

       Lurker-search accepts these keywords for searching:

       -xxx	 select messages which do NOT match this term

       id:xxx	 select a message by the Message-ID field

       rt:xxx	 select messages which reply to the chosen Message-ID

       th:xxx	 select messages included in this thread

       ml:xxx	 select messages in this mailing list

       gr:xxx	 select messages in this mailing list group

       au:xxx	 select messages with this term in the author fields

       sb:xxx	 select messages with this word in the subject

       lang:xxx  select messages in this language

SEE ALSO

       lurker-index(1), lurker-prune(1), lurker-params(1), lurker-list(1)

       lurker documentation on http://lurker.sourceforge.net/

COPYRIGHT

       Copyright (C) 2002: Wesley W. Terpstra <terpstra@users.sourceforge.net>

       This  program  is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; version 2.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY	WARRANTY;  without  even  the  implied	warranty  of  MER-
       CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You  should  have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
       Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

BUGS

       Before reporting a bug, please confirm that the bug you found is still present in the latest official release.  If  the	problem  persists,
       then send mail with instructions describing how to reproduce the bug to <lurker-users@lists.sourceforge.net>.

																  LURKER-SEARCH(1)