Hello,
I want to use DB mirror to reflect the changes from one server to another.But, i dont want all replication at a same time.I just want to select everything in one server database table with some conditions and replicate to another table of next server.
How it can be done.
Any ideas or suggestion is expected as i dont know much abt DB Mirror
regards,
Suman.
User Profile
Collapse
-
How to pass Javascript Value to a Jsp
Hello everybody,
As i get a value from javascript , i am in need of posting that to a jsp codes,
my code snippet is as............
Code:<html> <script type="text/javascript" src="gears_init.js"></script> <script type="text/javascript"> var db = google.gears.factory.create('beta.database'); db.open('database-demo'); var
-
how to unmount / , /usr partition
Hello evrybody!!!,
iam in need to unmonut /usr and also / partition so that i can make the image of that partition with partiamge, but when i try that it says the device is busy .....
so how to proceed also can it be possible with booting with single user mode or any other way....
any help will be highly appreciable,,,
thanks in advance,
Creeds -
Hello
i tried with both these...
but it shows error as it doesnt get $rad_no value when passed to select fn_deleteradno( )
so i wanted to concat the strings and $rad_no value, but ur suggestion is not matching with my output,
any suggestion
creeds -
how to concate strings and value
Helllo guys,
i am not able to concate teh strings evn though i got lots of explaination reagding that in intrnet
my problem is that..
i read a value from a console and concat that with other strings like
read rad_no
echo '$rad_no'
var= echo 'select fn_deleteradno( '
var2= $rad_no
var3= echo ')'
$echo "[${var}]+[${var2}]${var3}"
echo "$test"
... -
regarding shell scripts and database function.
hello,
i have a problem regarding following scenario,
------------------
#!/bin/sh
read $no
output=$(/usr/local/pgsql/bin/psql -d hrcurrency -t -c "select fn_deleteradno( no)")
echo $output
-----------------
My problem is how to pass the value read from the console to the function
fn_deleteradno( no)
if i straight away give the number... -
Using Shell Scripts for Database Operation
Hello ,
I am thinking of performing databse operation using shell scripts , for example i am in need to delete sum number from database very often so if i just run a shell scripts and give that number and if it gets deleted, it will be a quiter easy. thinking that i am trying to do shuch scripts, i am looking in the net and now can perform sum query thru scripts,
if any one has more idea regarding that, it will be a great help if... -
Hello
Thanks for suggestion ,
now i cud solve my problem but with a lengthy process by sendign value to a file and getting its value from there..it was lengthy but i cud do my work now still it gave me sum headache
--------------------------------
do
echo $line
V= echo $line |awk 'BEGIN{FS="|"} {print length($3)}' > /home/postgres/v.txt
#echo "THE V IS:"$V
#echo "THE...Leave a comment:
-
hello
yeah i already did that, but i again got strucked with
if [ "$V" -gt "$X" ]
the error shows unary operator expected,
i tried with all combination like "" or "$x" or "10" etc etc,
but shows error like interger expected or unary operator error...
so hw to solve this basic problem???
with regards,
sumanLeave a comment:
-
Problems while reading each lines and performing operations in each line
Hello !!
i have a text file, from where i have to perform an operation such as awk for every lines.
i can count the number of lines with cat filename | wc -l , no problem with that.
my scenario:
i take a input from a file, i count the length ofcertian paramater with substring and do the if else condition.
but i have to perform this action in every line....
a code snippet...
... -
[QUOTE=ashitpro][QUOTE=creeds][QUOTE=ashitpro]
hey buddy
thanks that was clear n clever logic
regards,
creeedsLeave a comment:
-
[QUOTE=ashitpro][QUOTE=creeds]
sorry yar,
i got ur answer and the pattern in the very first reply so no problem with any field being limited to 13 or 14 wotsever...
its understandable,
but inthe last post i wanted to count 14 from the last,
i mean +00977984136612 8 i want to remove + 00 as i limit my parameter to 14 from last....so how to proceed,
just sort my problem out man,
with regards, ...Leave a comment:
-
[QUOTE=ashitpro]
thanks for the solution..
yeah i also cud dothat using substr(), so that i can count 14, but if i want to cout 14 from the last , what patterns i have to apply ...
how to modify the following lines which limits 4th file dto first 14th limit
awk -F"|" '{printf "%s|%.14s|%s|3| %s\n" ,$1,$2,$3,$4}'
with regards,
CreedsLeave a comment:
-
shell scripts relating removing leading characters
hello,
I have some problems regarding trimming the leading character
awk -F"|" '{print $1"|"$2"|"$3"|3 |"$4}' /home/postgres/$File-9898.txt.edt > /home/postgres/edt1/$File-9898.txt.edt1
After getting the file $File-9898.txt.edt1, i am in need to limit the $4 parameter to 14 length so i want to trim everything if that extends more than 14.
so, how can i proceed, ...
No activity results to display
Show More
Leave a comment: