Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Code needed to get sql queries
Top Forums Shell Programming and Scripting Code needed to get sql queries Post 302773935 by surender reddy on Friday 1st of March 2013 01:59:51 AM
Old 03-01-2013
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
Code:
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.

Code:
UPDATE service_subscription SET quota_exceeded = 'N' WHERE service_id='I-H-2048-10GB-M';
 DELETE FROM service_subscription_override WHERE service_id='I-H-2048-10GB-M';
 commit;
 select * from service_subscription where service_id='I-H-2048-10GB-M';
 select *  FROM service_subscription_override WHERE service_id='I-H-2048-10GB-M';

Required output.

Code:
UPDATE service_subscription SET quota_exceeded = 'N' WHERE service_id='I-H-2048-10GB-M';
 DELETE FROM service_subscription_override WHERE service_id='I-H-2048-10GB-M';
 commit;
 select * from service_subscription where service_id='I-H-2048-10GB-M';
 select *  FROM service_subscription_override WHERE service_id='I-H-2048-10GB-M';
UPDATE service_subscription SET quota_exceeded = 'N' WHERE service_id='I-H-4096-12GB-M';
 DELETE FROM service_subscription_override WHERE service_id='I-H-4096-12GB-M';
 commit;
 select * from service_subscription where service_id='I-H-4096-12GB-M';
 select *  FROM service_subscription_override WHERE service_id='I-H-4096-12GB-M';
UPDATE service_subscription SET quota_exceeded = 'N' WHERE service_id='I-H-2048-p1000-M';
 DELETE FROM service_subscription_override WHERE service_id='I-H-2048-p1000-M';
 commit;
 select * from service_subscription where service_id='I-H-2048-p1000-M';
 select *  FROM service_subscription_override WHERE service_id='I-H-2048-p1000-M';

can anybody help.

tnx in advance.
 

10 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? (1 Reply)
Discussion started by: jpprial
1 Replies

2. UNIX for Dummies Questions & Answers

Sh Shell Script executing remote SQL queries

Hi there folks, I am trying to execute remote sql queries on an Oracle server. I would like to save the result of the executed sql queries on a text file, and send that text file as an attachment to an email address. Could anyone give me an idea on how the above could be achieved? Any help... (2 Replies)
Discussion started by: Javed
2 Replies

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 (1 Reply)
Discussion started by: user71408
1 Replies

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 (2 Replies)
Discussion started by: killboy
2 Replies

5. Shell Programming and Scripting

Nested SQL queries within Shell script

Hi, Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows: my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g" connect... (2 Replies)
Discussion started by: shrutihardas
2 Replies

6. Emergency UNIX and Linux Support

Insert data into sql queries from a file

Hello friends, I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences. my sql query file will consist of 50.000 times the below line consecutively: insert into subscriber... (6 Replies)
Discussion started by: EAGL€
6 Replies

7. Shell Programming and Scripting

Script (with sql queries) not working using cron

Hi all, I have script, which performing sql queries and put output into file. When I run this script manually, its working fine, but when I want to schedule it with cron I am getting errors... I defined LD_LYBRARY_PATH and ,but no result. After I defined it, I am getting error: # more... (4 Replies)
Discussion started by: nypreH
4 Replies

8. 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... (9 Replies)
Discussion started by: techstudent01
9 Replies

9. 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,... (3 Replies)
Discussion started by: Lord Spectre
3 Replies

10. 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... (3 Replies)
Discussion started by: Rokkesh
3 Replies

LEARN ABOUT LINUX

vdltodmx

vdltodmx(1)						      General Commands Manual						       vdltodmx(1)

NAME

       vdltodmx - dmx configuration file parser and printer

SYNOPSIS

       vdltodmx infile outfile

DESCRIPTION

       vdltodmx  reads	the  input file, which should be in VDL configuration file format.  After a successful parse, a file in Xdmx configuration
       file format is written to the output file.

       The VDL file format is used with xmovie, which is available from http://www.llnl.gov/icc/lc/img/xmovie/xmovie.html

EXAMPLE

       Given the following VDL-format file:
	      0
	      2
	      #
	      #
	      2560 2048 Left two-thirds [restrict=*:2]
	      2
	      :2.1 1280 2048   0    0 0 0
	      :2.2 1280 2048   1280 0 0 0
	      4
	      1280 1024 0      0
	      1280 1024 0      1024
	      1280 1024 1280   0
	      1280 1024 1280   1024
	      #
	      2560 2048 Right two-thirds [restrict=*:2]
	      2
	      :2.2 1280 2048   0   0 0 0
	      :2.3 1280 2048   1280 0 0 0
	      4
	      1280 1024 1280	0
	      1280 1024 1280	1024
	      1280 1024 2560 0
	      1280 1024 2560 1024
       the following DMX-format file will be produced:
	      #
	      #
	      virtual "Left two-thirds" 2560x2048 {
		  display :2.1 1280x2048;
		  display :2.2 1280x2048 @1280x0;
	      }
	      #
	      virtual "Right two-thirds" 2560x2048 {
		  display :2.2 1280x2048;
		  display :2.3 1280x2048 @1280x0;
	      }

BUGS

       If the VDL file is not in the expected format, the program will probably dump core.

SEE ALSO

       Xdmx(1), xdmxconfig(1), vdl(3), xmovie(1)

X Version 11							xorg-server 1.12.4						       vdltodmx(1)
All times are GMT -4. The time now is 09:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy