|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Korn Shell and Oracle
Post 302286529 by jim mcnamara on Wednesday 11th of February 2009 11:12:30 AM
02-11-2009
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I'm attempting to populate an array in ksh using the following command:
set -A $(SELECT_INVOICE | sed '/^$/d')
SELECT_INVOICE is a function that executes the SQL query.
Problem: Some of the invoice numbers have alpha characters with spaces(example: OVEN MICRO). The Korn shell is treating... (1 Reply)
Discussion started by: kdst
1 Replies
2. UNIX for Dummies Questions & Answers
Can someone tell me how to execute an Oracle Stored Procedure from a Korn Shell Script.
Previously, I'm able to execute standard sql using the following:-
The_Output=`sqlplus................. << EOF
select count(*) from abc
/
... (3 Replies)
Discussion started by: Vinny_Mitchell
3 Replies
3. Shell Programming and Scripting
I want to be able to run a script on one server, that will spawn another shell which runs some commands on another server..
I have seen some code that may help - but I cant get it working as below:
spawn /usr/bin/ksh
send "telnet x <port_no>\r"
expect "Enter command: "
send "LOGIN:x:x;... (2 Replies)
Discussion started by: frustrated1
2 Replies
4. Shell Programming and Scripting
well i have this code here..and it works fine in kornshell..
#!/bin/ksh
home=c:/..../
input=$1
sed '1,3d' $input > $1.out
line=""
cat $1.out | while read a
do
line="$line $a"
done
echo $line > $1
rm $1.out
however...now i want it just in normal sh mode..how to convert this?... (21 Replies)
Discussion started by: forevercalz
21 Replies
5. UNIX for Advanced & Expert Users
Hi,
My Oracle Stored procedure returns sys_refcursor to shell script. I have to iterate through it in script and use those retrieved values further in my script. I am using K Shell Scrpting.
Stored Procedure is:
create or replace
PROCEDURE p_test(job_id IN VARCHAR2, c1 OUT SYS_REFCURSOR)... (0 Replies)
Discussion started by: rajeshorpu
0 Replies
6. Shell Programming and Scripting
Hi All
I have writing a Korn Shell script to execute it on many of our servers. But some servers don't have Korn Shell installed, they use Borne Shell.
Some operations like calculation don't work :
cat ${file1} | tail -$((${num1}-${num2})) > ${file2}
Is it possible to activate Korn Shell... (3 Replies)
Discussion started by: madmat
3 Replies
7. Shell Programming and Scripting
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies
8. Shell Programming and Scripting
Could some one tell me the difference btw Bourne shell and the Kshell? Which is more flexible and reliable in terms of portability and efficiency. When i type the following command ..
$ echo $SHELL
yields me
/bin/sh
Does this tells me that I am in Bourne shell. If yes, how can i get... (6 Replies)
Discussion started by: bobby1015
6 Replies
9. Shell Programming and Scripting
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
Discussion started by: jackmorgan2007
2 Replies
10. Programming
Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am doing .
VALUE=`sqlplus -silent username/password << END
set pagesize 0 feedback off verify off... (14 Replies)
Discussion started by: megha2525
14 Replies
LEARN ABOUT CENTOS
ucs2any
ucs2any(1) General Commands Manual ucs2any(1) NAME
ucs2any - generate BDF fonts containing subsets of ISO 10646-1 codepoints SYNOPSIS
ucs2any [ +d | -d ] source-name { mapping-file registry-encoding } ... DESCRIPTION
ucs2any allows one to generate from an ISO 10646-1 encoded BDF font other BDF fonts in any possible encoding. This way, one can derive from a single ISO 10646-1 master font a whole set of 8-bit fonts in all ISO 8859 and various other encodings. OPTIONS
+d puts DEC VT100 graphics characters in the C0 range (default for upright, character-cell fonts). -d omits DEC VT100 graphics characters from the C0 range (default for all font types except upright, character-cell fonts). OPERANDS
source-name is the name of an ISO 10646-1 encoded BDF file. mapping-file is the name of a character set table like those at <ftp://ftp.unicode.org/Public/MAPPINGS/>. These files can also typically be found installed in the /usr/share/X11/fonts/util directory. registry-encoding are the CHARSET_REGISTRY and CHARSET_ENCODING field values for the font name (XLFD) of the target font, separated by a hyphen. Any number of mapping-file and registry-encoding operand pairs may be specified. EXAMPLE
The command ucs2any 6x13.bdf 8859-1.TXT iso8859-1 8859-2.TXT iso8859-2 will generate the files 6x13-iso8859-1.bdf and 6x13-iso8859-2.bdf. FUTURE DIRECTIONS
Hopefully a future release will have a facility similar to ucs2any built into the server, and reencode ISO 10646-1 on the fly, because storing the same fonts in many different encodings is clearly a waste of storage capacity. SEE ALSO
bdftruncate(1) AUTHOR
ucs2any was written by Markus Kuhn. Branden Robinson wrote this manual page, originally for the Debian Project. X Version 11 font-util 1.3.0 ucs2any(1)