Hi
i have a strange thing i have made a script to retrieve the result of an SQL command with sqlplus and if i do an echo to my variable it displays well.
But when i tried to do an update in my oracle table there is a special character at the beginning of my variable.
here is how i have detected in unix the strange char
Code:
sed -n l date_file.txt
2012-02-25 01:05:27 +0100$
2012-02-25 01:05:27 +0100$
dt_extract_leads_bf=`sqlplus -s $UID/$PSWD@$SID <<++
set heading off
set feedback off
select value from cleadm.tbpamtecle where name='lastFDWHLDate';
exit;
++`
tr -d '\r' < $dt_extract_leads_bf > date_file.txt
result=`sqlplus -s $UID/$PSWD@$SID <<++
set heading off
set feedback off
UPDATE CLEADM.TBPAMTECLE SET VALUE = '${dt_extract_leads_bf}' where name = 'lastFDWHLDate';
exit;
++`
./test_udpate.sh
A file or directory in the path name does not exist.
test_udpate.sh[19]: ^J^J2012-02-25 01:05:27 +0100: 0403-016 Cannot find or open the file.
can you help me please ?
thanks
ade05fr
---------- Post updated at 05:34 AM ---------- Previous update was at 05:10 AM ----------
thanks i have already solved my problem like that
Code:
temp_dt_extract_leads_bf=`sqlplus -s $UID/$PSWD@$SID <<++
set heading off
set feedback off
select TRIM(value) from cleadm.tbpamtecle where name='lastFDWHLDate';
exit;
++`
dt_extract_leads_bf=`echo $temp_dt_extract_leads_bf | tr -s "\n" ""`
Hi 2 all,
i have had AIX 7.2
:/# /usr/IBMAHS/bin/apachectl -v
Server version: Apache/2.4.12 (Unix)
Server built: May 25 2015 04:58:27
:/#:/# /usr/IBMAHS/bin/apachectl -M
Loaded Modules:
core_module (static)
so_module (static)
http_module (static)
mpm_worker_module (static)
... (3 Replies)
Hello.
System : opensuse leap 42.3
I have a bash script that build a text file.
I would like the last command doing :
print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt
where :
print_cmd ::= some printing... (1 Reply)
How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address
and column 3 contains “cc” e-mail address to include with same email.
Sample input file, email.txt
Below is an sample code where... (2 Replies)
logs:
"/home/abc/public_html/index.php"
"/home/abc/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
how to use "cut" or "awk" or "sed" to get the following result:
abc
abc
xyz
xyz
xyz (8 Replies)
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
been a while so i'm a bit rusty and need a little help. writing a script that needs to compare $EXECHOST(a number) against a numerical range and then set a value. below isn't working but should give you folks an idea of my goal:
if ; then
echo "This is a 32B machine, exiting..."
if ;... (4 Replies)
Dear friends, following is the output of a script from which I want to remove spaces and new-line characters.
Example:-
Line1 abcdefghijklmnopqrstuvwxyz
Line2 mnopqrstuvwxyzabcdefghijkl
Line3 opqrstuvwxyzabcdefdefg
Here in above example, at every starting line there is a “tab” &... (4 Replies)
Hi Friends,
Can any of you explain me about the below line of code?
mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`
Im not able to understand, what exactly it is doing :confused:
Any help would be useful for me.
Lokesha (4 Replies)
