10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
2. Shell Programming and Scripting
Input.txt
NOTE1|VALUE1|HMM|UPSTR|
NOTE2||HMP|UPSTR|
NOTE3|VALUE3|HML|UPSTR|
NOTE4||HMD|UPSTR|
NOTE5|VALUE5|HMS|UPSTR|
NOTE6|VALUE6|HSD|UPSTR|
NOTE7||HSS|UPSTR|
NOTE8|VALUE8|HEE|UPSTR|
NOTE9|VALUE9|HER|DOWNSTR|
NOTE50|VALUE1|HEE|DOWNSTR|
I am trying to read field 1, 2 and 3 from the... (4 Replies)
Discussion started by: Joselouis
4 Replies
3. UNIX for Advanced & Expert Users
I am having a file called variable_info.ksh in that file I am having following global variable information like…
EMAIL_PATH=/var/mail
TMP_PATH=/home/tmp
And we are having another temporary parameter file abcd.txt, in that file we are having the following information like…
EMAIL|EMAI_PATH
I... (4 Replies)
Discussion started by: mesahammad
4 Replies
4. Shell Programming and Scripting
Hi, I'm a it stuck on the below code where a variable is pulled from sqlplus and used in awk. It runs with no errors but still pulls back all records in the input file.
It should pull the max reference from sql plus and then only print those records where the reference value in column 1 is... (4 Replies)
Discussion started by: jonathanb30
4 Replies
5. Shell Programming and Scripting
Hi,
I am trying to fetch the different values in an xml file by searching with the same variable in AIX Server.
<name>SharedResources/Shared/JNDI/Username</name>
<value>admin</value> <name>SharedResources/Shared/JNDI/Username</name>
... (1 Reply)
Discussion started by: tejastrikez
1 Replies
6. UNIX for Dummies Questions & Answers
Hi Guys,
I have written a script that declares all the variables and its values in a conf file.
Now i use a variable whose value i need to change it in one of the sub-file that is used in the script.
In the startup file i want to print or check its value.
The value get changed and printed... (5 Replies)
Discussion started by: Swapna173
5 Replies
7. Shell Programming and Scripting
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Discussion started by: Anaramkris
5 Replies
8. Shell Programming and Scripting
Hi,
I am trying to execute this command
if ; then
but getting error .Some problem with reteriving the value of $exception_info.
Please help.Its urgent.
thanks (4 Replies)
Discussion started by: khushboo
4 Replies
9. Shell Programming and Scripting
Hi,
I want to get the value of the first field till space in a variable.
e.g x=323 /test/personel/logs/File1
I want to get the first field till space i.e 323 in another variable ,lets say y.
echo $x|cut -d' ' -f1 gives 323
but when I'm trying y=`echo $x|cut -d' ' -f1 its giving... (3 Replies)
Discussion started by: autosys_nm
3 Replies
10. Shell Programming and Scripting
Hello,
I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is... (11 Replies)
Discussion started by: MadHatter
11 Replies