06-14-2011
In the shell script I am connecting the database using below method
sqlplus -s prod/prod1@prod
Prod1 is the password in the shell script, How to hide the password in the script or calling the password from other location
Password should not be open to all users
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have statement like this
column_id.columnname=="value"
in unix i want to modify above statement to
variable1=="value"
that means i have to replace the string before "==" by string "variable1"
second catch is, in statement instead of "==" you can have any arithmatic comarision... (7 Replies)
Discussion started by: mahabunta
7 Replies
2. UNIX for Advanced & Expert Users
Hi
I am trying to find a product code hightlighted in red, and re-insert it at another place on the same file. I shall be grateful if anyone can help me with this. Stuck and have deadline!!:confused:
Original Line: (I can get source data in one of these two formats)
ISD=977155185403901+DIE... (2 Replies)
Discussion started by: gloovy_tb
2 Replies
3. Shell Programming and Scripting
Hi,
There are some "n" files in a directory which contains comman string.A command to find and replace the string in all the files without looping.
like if i am in a directory :
# find ./ -name ".txt" | xargs sed -e 's/test/tst'
Upto here is performed correctly and i want to... (4 Replies)
Discussion started by: rakshit
4 Replies
4. Shell Programming and Scripting
hi,
i have a data in a file like below:
100 8388kmn844., 8488
200 8398kmn894., 8398
i want replace from kmn to . as null.
output should be
100 8388, 8488
200 8398, 8398
Plz help.
Thanks in advance (1 Reply)
Discussion started by: javeed7
1 Replies
5. UNIX for Dummies Questions & Answers
I am looking to find and replace a string in a file, can anyone suggest a global find and replace. looked at previous replies on other queries but none seem to address what i am looking for. aint familiar with sed so trying to use ordinary unix commands if possible
Thanks in advance (2 Replies)
Discussion started by: SummitElse
2 Replies
6. Shell Programming and Scripting
Need to convert
echo "7 6"
to
$7,$6
But the count of numbers can increase say echo "7,6,8,9" tried this didn't work
echo "7 6" | sed 's/\(*\)/\1/'
But did not help much (3 Replies)
Discussion started by: dinjo_jo
3 Replies
7. Solaris
Dear All
To find a file, according to you, I tried as:
#find / -name file-name -print
To find a string inside the files , I tried as :
#find / -name "*" |xargs grep "string"
Can you please let me know how can I try for find/replace (i.e.
finding the intended string inside the text files... (6 Replies)
Discussion started by: hadimotamedi
6 Replies
8. Shell Programming and Scripting
i am having a file test1.txt and its contents is as follows.
<abcaaa bbb ccc ddd>
<dddeeeffff>
<my computer>
<abcmydocuments>
Now I need to find the text abc and should be replaced as follows.
<abc>
<dddeeeffff>
<my computer>
<abc>
First line has the text "abc" and it has to be... (3 Replies)
Discussion started by: kmanivan82
3 Replies
9. Shell Programming and Scripting
Hi All,
I have data like below
1 CREATE TABLE temp123
2 (
3 col1 INTEGER,
4 col2 CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
5 col3 DECIMAL(19,0),
6 col4 VARCHAR(80) CHARACTER SET LATIN NOT CASESPECIFIC,
7 start_dt DAte FORMAT 'YY/MM/DD',
8 end_dt DATE FORMAT 'YY/MM/DD',
9 datecol1... (6 Replies)
Discussion started by: baranisachin
6 Replies
10. Shell Programming and Scripting
Hi Team,
one silly issue. but its not working for me.
I need to find a pattern a file and replace it with the given value in another file.
Here's the code snippet.
Search_String=100
Replace_String=151
cat ${work}/temp_${CSV_File} | sed 's|"${Search_String}"|"${Replace_String}"|g'... (2 Replies)
Discussion started by: kmanivan82
2 Replies
LEARN ABOUT PHP
ingres_pconnect
INGRES_PCONNECT(3) 1 INGRES_PCONNECT(3)
ingres_pconnect - Open a persistent connection to an Ingres database
SYNOPSIS
resource ingres_pconnect ([string $database], [string $username], [string $password], [array $options])
DESCRIPTION
Open a persistent connection to an Ingres database.
There are only two differences between this function and ingres_connect(3): First, when connecting, the function will initially try to
find a (persistent) link that is already opened with the same parameters. If one is found, an identifier for it will be returned instead of
opening a new connection. Second, the connection to the Ingres server will not be closed when the execution of the script ends. Instead,
the link will remain open for future use (ingres_close(3) will not close links established by ingres_pconnect(3)). This type of link is
therefore called "persistent".
PARAMETERS
o $database
- The database name. Must follow the syntax: $[vnode::]dbname[/svr_class]
o $username
- The Ingres user name
o $password
- The password associated with $username
o $options
- See ingres_connect(3) for the list of options that can be passed
RETURN VALUES
Returns an Ingres link resource on success or FALSE on failure
SEE ALSO
ingres_connect(3), ingres_close(3).
PHP Documentation Group INGRES_PCONNECT(3)