You're absolutely right and I believe I got the exact cause behind this problem. The XML for even one record in the table is so large that it's not spooling into the file completely. To give an example, the first row of the table contained
But it's getting spooled into the file as
Is there any limit to the file size in Unix ?
---------- Post updated at 12:54 PM ---------- Previous update was at 12:14 PM ----------
Hi All,
I think this problem is resolved. Before spooling the file from the query, I just set the LONG and LONGCHUNKSIZE to their maximum values, and the script is working fine now. I just don't know what will happen in case the production data gets more massive in future !!!
Thanks to Robin & Chubler_XL.
Chubler_XL, your script is very clean and efficient !! Thanks again !!
Hi,
I'm having a xml file with multiple xml header. so i want to split the file into multiple files.
Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix.
eg :
<?xml version="1.0" encoding="UTF-8"?>
<ml:individual... (3 Replies)
Hi Everyone,
I'm new here and I was checking this old post:
/shell-programming-and-scripting/180669-splitting-file-into-several-smaller-files-using-perl.html
(cannot paste link because of lack of points)
I need to do something like this but understand very little of perl.
I also check... (4 Replies)
Hello All ,
Please help me with below requirement
I want to split a xml file based on tag.here is the file format
<data-set>
some-information
</data-set>
<data-set1>
some-information
</data-set1>
<data-set2>
some-information
</data-set2>
I want to split the above file into 3... (5 Replies)
I will simplify the explaination a bit, I need to parse through a 87m file -
I have a single text file in the form of :
<NAME>house........
SOMETEXT
SOMETEXT
SOMETEXT
.
.
.
.
</script>
MORETEXT
MORETEXT
.
.
. (6 Replies)
HI All,
I have to split a xml file into multiple xml files and append it in another .xml file. for example below is a sample xml and using shell script i have to split it into three xml files and append all the three xmls in a .xml file. Can some one help plz.
eg:
<?xml version="1.0"?>... (4 Replies)
I am trying to update an older program on a small cluster. It uses individual files to send jobs to each node. However the newer database comes as one large file, containing over 10,000 records. I therefore need to split this file. It looks like this:
HMMER3/b
NAME 1-cysPrx_C
ACC ... (2 Replies)
Hi Experts,
I have to split huge file based on the pattern to create smaller files. The pattern which is expected in the file is:
Master.....
First...
second....
second...
third..
third...
Master...
First..
second...
third...
Master...
First...
second..
second..
second..... (2 Replies)
I need to write a shell script for below scenario
My input file has data in format:
qwerty0101TWE 12345 01022005 01022005 datainala alanfernanded 26
qwerty0101mXZ 12349 01022005 06022008 datainalb johngalilo 28
qwerty0101TWE 12342 01022005 07022009 datainalc hitalbert 43
qwerty0101CFG 12345... (19 Replies)
Hello gurus,
I am new to "awk" and trying to break a large file having 4 million records into several output files each having half million but at the same time I want to keep the similar key records in the same output file, not to exist accross the files.
e.g. my data is like:
Row_Num,... (6 Replies)
XML(3pm) User Contributed Perl Documentation XML(3pm)NAME
CGI::XML - Perl extension for converting CGI.pm variables to/from XML
SYNOPSIS
use CGI::XML;
$q = new CGI::XML;
# convert CGI.pm variables to XML
$xml = $q->toXML;
$xml = $q->toXML($root);
# convert XML to CGI.pm variables
$q->toCGI($xml);
DESCRIPTION
The CGI::XML module converts CGI.pm variables to XML and vice versa.
CGI::XML is a subclass of CGI.pm, so it reads the CGI variables just as CGI.pm would.
METHODS
$q = new CGI::XML
creates a new instance of CGI::XML. You also have access to all of the methods in CGI.pm.
$q->toXML([$root])
where $root is an optional parameter that specifies the root element. By default, toXML will not return a root element.
$q->toCGI($xml)
where $xml is the XML you would like to convert to CGI.pm parameters. Values in the XML will overwrite any existing values if they
exist.
NOTE
CGI::XML does not currently handle multiple selections passed from HTML forms. This will be added in a future release.
AUTHOR
Jonathan Eisenzopf <eisen@pobox.com>
CONTRIBUTORS
David Black <dblack@candle.superlink.net>
SEE ALSO perl(1), XML::Parser(3).
perl v5.8.8 2004-12-05 XML(3pm)