03-11-2010
Formatting Oracle sqlplus output
a job extracts orcle data into unix as flat file.
a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records.
(its not single record in two line. but its single record into record. ie., \n come into picture)
can you tell me what would be the problem? how can i make them single record.?
Last edited by radoulov; 03-11-2010 at 10:17 AM..
Reason: Title fixed.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all,
Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell.
What is the standard procedures to be taken care.
Any help would be useful for me.
Thanks in advance,
Ganapati. (2 Replies)
Discussion started by: ganapati
2 Replies
2. UNIX and Linux Applications
Hi,
I want to use sqlplus from server1
sqlplus usr1/pass1@dns1
and I want to connect to an Oracle database from a server2.
Unfortunately the database was created on the server1 and on server2.
So when I use the command just like that...it connects to the database from the server2. ... (2 Replies)
Discussion started by: AngelMady
2 Replies
3. Shell Programming and Scripting
Hello,
This may not be the right place to ask for help for this problem but i might be because i'm using Java & SqlPlus in alot of Kshell scripts.
Just to give a high level picture, i'm basically using Java to control each SqlPlus execute command, by reading a flat file that contains the run... (2 Replies)
Discussion started by: bobk544
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies
5. Shell Programming and Scripting
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies
6. Shell Programming and Scripting
So, I would like to run differen select queries on multiple databases..
I made a script wich I thought to be called something like..
./script.sh sql_file_name out.log
or to enter select statement in a command line..
(aix)
and I did created some shell script wich is not working..
it... (6 Replies)
Discussion started by: bongo
6 Replies
7. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
8. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
9. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
10. Shell Programming and Scripting
Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file
in a unix location. I want... (7 Replies)
Discussion started by: amvip
7 Replies
LEARN ABOUT DEBIAN
opendkim-atpszone
opendkim-atpszone(8) System Manager's Manual opendkim-atpszone(8)
NAME
opendkim-atpszone - DKIM ATPS zone file generation tool
SYNOPSIS
opendkim-atpszone [-A] [-C address] [-E secs] [-h hash] [-N ns[,...]] [-o file] [-r secs] [-R secs] [-S] [-t secs] [-T secs] [-v]
[dataset]
DESCRIPTION
opendkim-atpszone generates a file suitable for use with named(8) to publish a set of domains authorized as third-party signers for a local
domain.
The dataset parameter should specify a set of data as described in the opendkim(8) man page. It can currently refer to flat files, Sleepy-
cat databases, comma-separated lists, LDAP directories or SQL databases. The keys in the named database are assumed to comprise a set of
domains that are to be advertised using the experimental Authorized Third-Party Signers protocol as permitted to sign mail using DKIM on
behalf of the local domain. Values in the database are not used.
OPTIONS
-A Adds a "._atps" suffix to records in the zone file.
-C contact
Uses contact as the contact information to be used when an SOA record is generated (see -S below). If not specified, the userid of
the executing user and the local hostname will be used; if the executing user can't be determined, "hostmaster" will be used.
-E secs
When generating an SOA record (see -S below), use secs as the default record expiration time. The default is 604800.
-h hash
Specifies which SHA hash algorithm to use. Must be one of "none", "sha1" and "sha256", with "sha256" being the default if it is
available.
-N nslist
Specifies a comma-separated list of nameservers, which will be output in NS records before the TXT records. The first nameserver in
this list will also be used in the SOA record (if -S is also specified) as the authority hostname.
-o file
Sends output to the named file rather than standard output.
-r secs
When generating an SOA record (see -S below), use secs as the zone refresh time. The default is 10800.
-R secs
When generating an SOA record (see -S below), use secs as the zone retry time. The default is 1800.
-S Asks for an SOA record to be generated at the top of the output. The content of this output can be controlled using the -E, -r, -R,
-T options. The serial number will be generated based on the current time of day.
-t ttl Puts a TTL (time-to-live) value of ttl on all records output. The units are in seconds.
-T secs
When generating an SOA record (see -S below), use secs as the default record TTL time. The default is 86400.
-v Increases the verbosity of debugging output written to standard error.
VERSION
This man page covers the version of opendkim-atpszone that shipped with version 2.6.8 of OpenDKIM.
COPYRIGHT
Copyright (c) 2011, 2012, The OpenDKIM Project. All rights reserved.
SEE ALSO
opendkim(8), opendkim.conf(5)
The OpenDKIM Project opendkim-atpszone(8)