I am trying to spool data from database into a file on solaris through ksh.
Data is getting fetched but the problem is record is getting split in to multiple lines.
excerpt from sql is
Code:
whenever sqlerror exit 1;
set define on
set echo off
set feed off
set head off
set trimspool on
set verify off
set linesize 150
set newpage 0
set pagesize 0
set space 0
select * from &2;
SPOOL OFF;
quit;
Table data is (below each field separated by space):
Code:
D 11 120822FX400000046 208101981802950 33602205271 63080 G 01 20120713120718 466 01 01 FRAXX
The output I am getting is :
Code:
D 11 120822FX400000046 208101981802950 33602205271 63080 G 01 20120713120718 466 01 01
FRAXX
Kindly help..I don know why it is happening??
Moderator's Comments:
Please use code tags next time for your code and data.
hi,
can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file ..
right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed..
... (2 Replies)
Hi,
I am trying to do this
For i in *.txt
do
sed 'some pattern checking' $i
done
>file
These text files are spool files.And when i find error in these spool files I want to append the text file contents to error.log file.
Or is there any option that I do this sed for only files that... (12 Replies)
HI
Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.
Getting error: SP2 0308: cannot close spool file.
Any thoughts?
sqlplus -s user/pwd << EOF
set term off
set head off
set trims on
set pages 0
set... (1 Reply)
Dear Gurus,
Tried searching for some clues in this forum but dont seem to be able to find my answer. :confused:
Anyway i have a quick question:
Today I have produced a messages generated from a application and placed them on the print queue. Before this I had stopped the printer queue, so... (2 Replies)
Hi,
Iam a newbie. When I give the below query at SQL prompt.
SQL> select col1||'`ß`'||col2 from tablename where rownum<2;
1-J7WGX`ß`1-7OKC-23
Iam getting ß within appostropies...... If I remove appostropies and give the query it is throwing an error.
If I give the same query in spool as... (1 Reply)
hi all,
am trying to write a ksh script which will take a username, password, db instance as input arguments and login to the database using sqlplus and select some data via sql and spool to a file.
problem is that i am using "sqlplus -s" in order to hide the username/password and it doesnt... (8 Replies)
Hi All,
I have one Question, that is it possible to check the spool output?
What i mean to say is "spool the file only if data exists"
I am trying to fetch data from a sql query, and want to generate a file, on a condition that the file should be generated, only if the output of the sql... (5 Replies)
Hi All,
I have a problem with the column heading while spooling the data from the database. Since i want the column header, therefore i am not using SET HEADING OFF, and i am getting the header, but for the longer column name, some of the character from the column name is missing.
for... (7 Replies)
Hi,
I have a requirement of
Connecting to sqlplus from unix
Execute the package. The output of package is stored in a table
Need to query the table and move to txt file.
The problem iam facing is, when I try to spool the file. I get the sql query also along with the output.... (6 Replies)
Hello,
I have a shell script through which I am executing .sql file and spooling the result of Query from .sql . I want to spool the result in ascending order. Is there any parameter to be set to print result in ascending or descending order.
Thanks in advance. (4 Replies)
Discussion started by: Aparna.N
4 Replies
LEARN ABOUT DEBIAN
data::amf::packet
Data::AMF::Packet(3pm) User Contributed Perl Documentation Data::AMF::Packet(3pm)NAME
Data::AMF::Packet - serialize / deserialize AMF message packet
SYNOPSIS
use Data::AMF::Packet
my $packet = Data::AMF::Packet->deserialize($data);
my $data = $packet->serialize;
DESCRIPTION
Data::AMF::Packet provides to serialize/deserialize AMF Packet.
AMF Packet is an extended format of AMF, and is used for Flash's HTTP based Remote Procidure Call (known as Flash Remoting).
SEE ALSO
Data::AMF, Catalyst::Controller::FlashRemoting
METHODS
serialize
Serialize Data::AMF::Packet object into AMF Packet data.
deserialize($amf_packet)
Deserialize AMF Packet, and return Data::AMF::Packet object.
ACCESSORS
version
return AMF Packet version.
headers
return AMF Packet header objects. (ArrayRef of Data::AMF::Header)
messages
return AMF Packet Message objects. (ArrayRef of Data::AMF::Message)
AUTHOR
Daisuke Murase <typester@cpan.org>
COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
perl v5.12.4 2010-07-21 Data::AMF::Packet(3pm)
09-11-2012
