10-28-2005
unix script errors
#!/bin/ksh
sqlplus -s user/passwd@remoteserver << EOF > errors2.log
set pagesize 0 feedback off verify off heading off echo off
select directory_nm || '/' || file_nm || '|' ||venue_id || '|' || time_id from file_control;
EOF
The output of this script is;
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|
28991|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|
25881|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.20050711210100|
25881|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.20050711210100|
28991|1130198400
The desired output is: the directory_nm, filename,venueid and timeid must be in the same line.
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|28991|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|25881|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.20050711210100|25881|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.2005071121010028991|1130198400
Can you tell me why the output from the korn script is printing in 2 lines instead of single line. I tried to debug it could not.
can anyone hep me please.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
ok, i have a script which i use to search my process' for specific keywords and kill any process containing them. there is a prompt to enter a keyword for searching and another prompt for which user you want to search the process' of. i want the script to have something that if you entered a search... (1 Reply)
Discussion started by: Blip
1 Replies
2. Programming
Hi all,
I have created a post-C (PC) script OrdItmpopulate.pc. When I am compiling this using the “Make” command I am getting the following error. My “make” command looks like this:
make -f $ORACLE_HOME/precomp/demo/proc/demo_proc.mk build EXE=OrdItmpopulate8.exe OBJS="OrdItmpopulate8.o"... (1 Reply)
Discussion started by: musavir19
1 Replies
3. UNIX for Advanced & Expert Users
Hi all, I have major errors on entering the shell. On login I get:
-bash: dircolors: command not found
-bash: tr: command not found
-bash: fgrep: command not found
-bash: grep: command not found
-bash: grep: command not found
-bash: id: command not found
-bash: #
root@host # pwd
/bin... (0 Replies)
Discussion started by: wcmmlynn
0 Replies
4. Shell Programming and Scripting
hi all,
how to handle sql loader errors in unix shell
??
thanks in advance
gemini (3 Replies)
Discussion started by: gemini106
3 Replies
5. Shell Programming and Scripting
Hello;
I'm trying to write a script to capture any hardware error from logs/syslog on my SUSE 10 servers so i can be notified if we have any hardware issues such a bad fan or battery, etc..
Thanks in advance for any help (2 Replies)
Discussion started by: Katkota
2 Replies
6. Shell Programming and Scripting
hey watsup guys
i am new in the shell script world. so i need help fom you guys, i have written these two codes and they both give the same errors( expr : syntax error).
Code 1 :
#! /bin/sh
# count1 appends an increment to a file 200 times
# note that a file called numbers must be... (5 Replies)
Discussion started by: surubi_abada
5 Replies
7. Shell Programming and Scripting
solution found....
Please use tags for scripts, listings, and console output (2 Replies)
Discussion started by: audiolord
2 Replies
8. UNIX for Dummies Questions & Answers
I have a simple script that processes files. Here's a simplified example of what I'm doing:
foreach t (web.*)
mv $t dnw$t:e.log
end
foreach t (card.*)
mv $t card$t:e.log
end
The problem is that sometimes there is no web.* file. In that case, I get an error "foreach: No match" and... (4 Replies)
Discussion started by: software5723
4 Replies
9. Shell Programming and Scripting
#!/bin/ksh
number1="20"
if
then
number1=$1
fi
number2="1"
while ]
do
if ]
then
print "FizzBuzz"
elif ]
then
print "Fizz"
elif ]
then
... (3 Replies)
Discussion started by: bjhum33
3 Replies
10. Shell Programming and Scripting
Hi Guys,
I wanted to create an Unix Shell Script that should fetch a particular string from a text file on a particular date.
We all know Oracle generates alert logs for each and every day for every actions in the database.
I have an alert log file now where it contains for about a months... (4 Replies)
Discussion started by: raja_dba
4 Replies
LEARN ABOUT REDHAT
i2d_dsaprivatekey
d2i_DSAPublicKey(3) OpenSSL d2i_DSAPublicKey(3)
NAME
d2i_DSAPublicKey, i2d_DSAPublicKey, d2i_DSAPrivateKey, i2d_DSAPrivateKey, d2i_DSA_PUBKEY, i2d_DSA_PUBKEY, d2i_DSA_SIG, i2d_DSA_SIG - DSA
key encoding and parsing functions.
SYNOPSIS
#include <openssl/dsa.h>
DSA * d2i_DSAPublicKey(DSA **a, const unsigned char **pp, long length);
int i2d_DSAPublicKey(const DSA *a, unsigned char **pp);
DSA * d2i_DSA_PUBKEY(DSA **a, const unsigned char **pp, long length);
int i2d_DSA_PUBKEY(const DSA *a, unsigned char **pp);
DSA * d2i_DSAPrivateKey(DSA **a, const unsigned char **pp, long length);
int i2d_DSAPrivateKey(const DSA *a, unsigned char **pp);
DSA * d2i_DSAparams(DSA **a, const unsigned char **pp, long length);
int i2d_DSAparams(const DSA *a, unsigned char **pp);
DSA * d2i_DSA_SIG(DSA_SIG **a, const unsigned char **pp, long length);
int i2d_DSA_SIG(const DSA_SIG *a, unsigned char **pp);
DESCRIPTION
d2i_DSAPublicKey() and i2d_DSAPublicKey() decode and encode the DSA public key components structure.
d2i_DSA_PUKEY() and i2d_DSA_PUKEY() decode and encode an DSA public key using a SubjectPublicKeyInfo (certificate public key) structure.
d2i_DSAPrivateKey(), i2d_DSAPrivateKey() decode and encode the DSA private key components.
d2i_DSAparams(), i2d_DSAparams() decode and encode the DSA parameters using a Dss-Parms structure as defined in RFC2459.
d2i_DSA_SIG(), i2d_DSA_SIG() decode and encode a DSA signature using a Dss-Sig-Value structure as defined in RFC2459.
The usage of all of these functions is similar to the d2i_X509() and i2d_X509() described in the d2i_X509(3) manual page.
NOTES
The DSA structure passed to the private key encoding functions should have all the private key components present.
The data encoded by the private key functions is unencrypted and therefore offers no private key security.
The DSA_PUBKEY functions should be used in preference to the DSAPublicKey functions when encoding public keys because they use a standard
format.
The DSAPublicKey functions use an non standard format the actual data encoded depends on the value of the write_params field of the a key
parameter. If write_params is zero then only the pub_key field is encoded as an INTEGER. If write_params is 1 then a SEQUENCE consisting
of the p, q, g and pub_key respectively fields are encoded.
The DSAPrivateKey functions also use a non standard structure consiting consisting of a SEQUENCE containing the p, q, g and pub_key and
priv_key fields respectively.
SEE ALSO
d2i_X509(3)
HISTORY
TBA
0.9.7a 2002-10-09 d2i_DSAPublicKey(3)