Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SQL Select and awk
Top Forums Shell Programming and Scripting SQL Select and awk Post 302261278 by habuzahra on Monday 24th of November 2008 07:56:11 AM
Old 11-24-2008
SQL Select and awk
Dear All ,
I have file1.txt contain values like the following:
----------

23
24
25

and I have shell script which has the following :

more file1.txt | awk '{print "select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='" $1 "';"}' > file2.sql

all I need is to have the following sql in the file2.sql
select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='23';
select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='24';
select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='25';

but I got error on the | and the DUMP string is look like 'DUMP' is look like DUMP with out single quotations

Please Advise , I believe that the problem in the ' and the | maybe it's a speacial charchters .


Best Regards.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formatting the sql select result

Hi, I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ? Thanks, Sateesh (2 Replies)
Discussion started by: kotasateesh
2 Replies

2. Web Development

SQL Select inside Insert

I have following. . . . $userid = 2 . $query = "select username from users where userid = ".$userid.";"; . $username = $line; $data="Some Data Here"; . $query = "insert into logger (username, data) valuse ($username, $data);"; . I would like to not have 2 database calls. (3 Replies)
Discussion started by: Ikon
3 Replies

3. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

Hi, I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use.. Please can any body help me in this regards Thanks & Regards Abdul Hafeez Shaik (17 Replies)
Discussion started by: abdulhafeez
17 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

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

6. Shell Programming and Scripting

SQL select all but not if it is already in an other column

I know I know.. for sure one of the easier mysql statements. But somehow I can not figure out this. I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row) data_12 ... (6 Replies)
Discussion started by: lowmaster
6 Replies

7. Programming

I'm going crazy with SQL select. Please help!

Hello people, as wrote in title I'm going crazy with a "complex" SQL select. This is the seelct: select T_ADDRESS, T_MCC,T_MNC,T_MSIN,T_IM_MNC, COUNT(*) FROM TABLETEST WHERE T_MCC=123 AND (T_MNC=11 OR T_MNC=01) GROUP BY T_ADDRESS,T_MCC,T_MNC,T_MSIN,T_IM_MNC HAVING count(*) > 5;This select... (7 Replies)
Discussion started by: Lord Spectre
7 Replies

8. Programming

[Solved] SQL SELECT REPLACE

Hi All, I had a query related to sql select update replace command. i have a table named clusters and it looks like this name model characteristics sample1.1 +123 parent sample1.2 -456 clone sample1.3 +122 ... (5 Replies)
Discussion started by: sonia102
5 Replies

9. Programming

Sql select replace

Hi All, I had a query related to sql select replace command. i have a table named clusters and it looks like this Code: name characteristics sample 1.1 parent sample 1.2 ... (2 Replies)
Discussion started by: siya@
2 Replies

10. Shell Programming and Scripting

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): Old File: SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */ ... (5 Replies)
Discussion started by: pchang
5 Replies

LEARN ABOUT CENTOS

lwp-dump

LWP-DUMP(1)						User Contributed Perl Documentation					       LWP-DUMP(1)

NAME

       lwp-dump - See what headers and content is returned for a URL

SYNOPSIS

       lwp-dump [ options ] URL

DESCRIPTION

       The lwp-dump program will get the resource indentified by the URL and then dump the response object to STDOUT.  This will display the
       headers returned and the initial part of the content, escaped so that it's safe to display even binary content.	The escapes syntax used is
       the same as for Perl's double quoted strings.  If there is no content the string "(no content)" is shown in its place.

       The following options are recognized:

       --agent str
	   Override the user agent string passed to the server.

       --keep-client-headers
	   LWP internally generate various "Client-*" headers that are stripped by lwp-dump in order to show the headers exactly as the server
	   provided them.  This option will suppress this.

       --max-length n
	   How much of the content to show.  The default is 512.  Set this to 0 for unlimited.

	   If the content is longer then the string is chopped at the limit and the string "...
(### more bytes not shown)" appended.

       --method str
	   Use the given method for the request instead of the default "GET".

       --parse-head
	   By default lwp-dump will not try to initialize headers by looking at the head section of HTML documents.  This option enables this.
	   This corresponds to "parse_head" in LWP::UserAgent.

       --request
	   Also dump the request sent.

SEE ALSO

       lwp-request, LWP, "dump" in HTTP::Message

perl v5.16.3							    2012-01-14							       LWP-DUMP(1)
All times are GMT -4. The time now is 04:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy