Hi,
Could any of you point me to where I can obtain basic information on JCM?
Thanks in advance!
Muskaan
***Most problems are nothing but lack of ideas***
Hi,
We recently migrated from Sun to AIX. On sun we used to convert a feed from Japanese characters to UTF-8 before loading the data into our databases. For this, the command was:
conv -f SJIS -t UTF-8 $datafile > "$datafile".utf8
Now, as SJIS converter is not available on AIX, I am trying to...
Hi,
We recently migrated from Sun to AIX. On sun we used to convert a feed from Japanese characters to UTF-8 before loading the data into our databases. For this, the command was:
conv -f SJIS -t UTF-8 $datafile > "$datafile".utf8
Now, as SJIS converter is not available on AIX, I am trying to...
Hi,
I am trying to send mail using utl_smtp from a pl/sql block. The message comes through fine but with no subject. Does anyone know how can I populate that ?
Here is the code I am using:
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn...
Thanks for your response Dave, I suppose I will try the other two options. The spooling option (if it had been possible) was far more simple though!
Thanks for your time!
Muskaan :)
***Most problems are nothing but lack of ideas***
Hi all,
I wanted to know if there was a way to spool to a single file in append mode ?
Say, my sql looks like:
---snip---
spool a
<do something1>
spool off
<do something, the output of which i do not want in file a>
spool a
<do something2>
spool off
---snip---
so the results of "do...
Hey I got the solution. For those who care:
set -A array_test $(echo "first,second,third" | tr ',' ' ')
***Most problems are nothing but lack of ideas***
Hi all, I have set an array in ksh using the "set -A" command when the set of values are space delimited, as follows:
set -A array_test $(echo "first second third")
is it possible to do something similarly simple in case my set of values is comma separated like so...
Hi dsanchez2, I could do that, only one would have to maintain the env table up to date. These env variables are anyway maintained for other shell scripts, they will now be parsed by pl/sql block from a flat file. Values for the flat file will be picked from env during every run, so there is no...
Thanks everyone, for your time and suggestions. I am implementing the utl_file solution. We do not have the 9i yet, but when that happens I will look at the solution that carp suggested.
thanks again
Muskaan
***Most problems are nothing but lack of ideas***
Hi Dima,
The task I need to perform involves invoking a pl/sql script on server side to read server(same) side environment variables. What I need to implement is quite complex but the simplified form of the problem is:
there is an environment variable age_in_months. I need to use the value of...
Hi parbhani,
I have a HUGE pl/sql block defined within a *.sql file, I cannot possibly move it to the shell script, nor can I pass so many variables as argument. Surely there must be a way ?
Thanks for your time!
Most problems are nothing but lack of ideas.
Hi all,
I am running a PL/SQL block in which I need the values of some environment variables. Does anyone know how this can be done ?
Thanks in advance,
Muskaan
Hi,
I wanted to know if there was a one-step command to determine the age of a file, something like months_between(DATE1,DATE2) in oracle. I need to write a purge script that can delete all log files older than 3 months. What is the best way to do that?
Thanks in advance!
Muskaan
No, what I mean is to be able to export value from a shell script, say set_user_name.sh to the session that ran it, like so;
---snip---
[dhcp80:~/verify_ut] muskaan% echo $SHELL
/bin/tcsh
[dhcp80:~/verify_ut] muskaan% cat set_user_name.sh
#!/bin/tcsh
setenv user_name muskaan
echo user_name is...
Hi all,
Has anyone worked on tcsh ? I wanted to know how one can export environment variables from child to parent. I tried using setenv but the value remains only in the child shell script. It becomes "undefined" when I try to echo its value from the parent terminal session. anyone...
Hi All,
I wanted to find out a way to get a return value of a command run by rsh. eg: rsh -l<login> <machine name> <command>
Is there a way to determine whether <command> running on remote machine returned 0 or 1 ?
I tried
$> rsh -l<login> <machine name> "<command>; echo $?"
but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.