03-30-2005
Filename containing Single Quotes
Hi ,
I am passing a variable site_name from a shellscript to an SQL script and then I want to spool an sql query on to my Unix box and generate a CSV file.
Everything works fine but I have to give quotes to the variable '&&site_name' in spool statement ..if i remove the quotes it generates an LST file or some other type of file.I am working on korn shell ..
pls help me remove the single quotes from my filename..I have tried many options but unable to resolve it...
define site_name=&&1
spool /projects/hpsd_dwh/global_extract/Closed_Case_Extract/MTD/'&&site_name'.csv
thanks in advance ...
cheers!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all...
This is probably the simplest question but its driving me round the bend :-(
does anyone know how to store a single quote in a variable. Im using cygwin bash
for example
single_qoute = " ' "
echo single_quote
dosnt work :-( it is absolutely baffling me!
The reason why... (4 Replies)
Discussion started by: satnamx
4 Replies
2. Programming
Hi !
Can anyone please tell me how can I check if a character is single quotes in C ?
Thanks,
Jane A (3 Replies)
Discussion started by: janemary.a
3 Replies
3. Shell Programming and Scripting
Hi,
Please help me to echo the following statement using single quotes
Why can't I write 's between single quotes
Thanks in advance,
Chella (3 Replies)
Discussion started by: chella
3 Replies
4. Shell Programming and Scripting
I'm not very familiar with the ssh command. When I tried to set a variable and then echo its value on a remote machine via ssh, I found a problem. For example,
$ ITSME=itsme
$ ssh xxx.xxxx.xxx.xxx "ITSME=itsyou; echo $ITSME"
itsme
$ ssh xxx.xxxx.xxx.xxx 'ITSME=itsyou; echo $ITSME'
itsyou
$... (3 Replies)
Discussion started by: password636
3 Replies
5. Shell Programming and Scripting
Hi guys, I have a sed line in double quotes which works fine, but I want it to be in single quotes
here is the sed line
sed "/abc_def/s/\'.*\'/\'\${abc_def}\'/"
can some one give the equivalent to the above script in single quotes
Thanks a ton (5 Replies)
Discussion started by: sol_nov
5 Replies
6. UNIX for Dummies Questions & Answers
Unix superusers,
I am new to unix but would like to learn more about grep. I am very familiar with regular expressions as i have used them for searching text files in windows based text editors. Since I am not very familiar with Unix, I dont understand when one should use GREP with the... (2 Replies)
Discussion started by: george_vandelet
2 Replies
7. Shell Programming and Scripting
Hi I want to replace single quote with two single quotes in a perl string.
If the string is <It's Simpson's book> It should become <It''s Simpson''s book> (3 Replies)
Discussion started by: DushyantG
3 Replies
8. Shell Programming and Scripting
Hello. I'm trying to write a bash script that uses GNU screen and have hit a brick wall that has cost me many hours... (I'm sure it has something to do with quoting/globbing, which is why I post it here)
I can make a script that does the following just fine:
test.sh:
#!/bin/bash
# make... (2 Replies)
Discussion started by: jondecker76
2 Replies
9. Shell Programming and Scripting
Hi,
Trying to change the prompt. I have the following code.
export PS1='
<${USER}@`hostname -s`>$ '
The hostname is not displayed
<abc@`hostname -s`>$ uname -a
AIX xyz 1 6 00F736154C00
<adcwl4h@`hostname -s`>$
If I use double quotes, then the hostname is printed properly but... (3 Replies)
Discussion started by: bobbygsk
3 Replies
10. Shell Programming and Scripting
Hi,
I have a grep command which searches if a particular word ends in a pattern
grep 'ee\>' *
The above command searches for any word that ends with ee across files and works as expected.
I need to parametrize ee and run the command
so I tried the following but none work
A=ee
grep... (1 Reply)
Discussion started by: wahi80
1 Replies
LEARN ABOUT PHP
ingres_prepare
INGRES_PREPARE(3) 1 INGRES_PREPARE(3)
ingres_prepare - Prepare a query for later execution
SYNOPSIS
mixed ingres_prepare (resource $link, string $query)
DESCRIPTION
Prepares a query for execution by ingres_execute(3).
The query becomes part of the currently open transaction. If there is no open transaction, ingres_query(3) opens a new transaction. To
close the transaction, you can call either ingres_commit(3) to commit the changes made to the database or ingres_rollback(3) to cancel
these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use ingres_autocom-
mit(3) before opening a new transaction to have every SQL query immediately committed.
Note
Related Configurations
See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $link
- The connection link identifier
o $query
- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query(3)
for a list of SQL statements which cannot be executed using ingres_prepare(3)
RETURN VALUES
ingres_prepare(3) returns a query result identifier that is used with ingres_execute(3) to execute the query. To see if an error occurred,
use ingres_errno(3), ingres_error(3), or ingres_errsqlstate(3).
SEE ALSO
ingres_unbuffered_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3),
ingres_rollback(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).
PHP Documentation Group INGRES_PREPARE(3)