Hi Robin,

Thanks for the reply. Below are the information you asked for :

I'm running Linux kernel 2.6.39.

The script I'm trying to write is for bash. I'm comfortable working with Awk/sed etc.

The actual table that I'm querying is something like below

Code:

ID (PK, NUMBER)      URL (the queried column, XMLTYPE)

1		     <URL><A>v1</A><B>v2</B><C>v3</C></URL>
2		     <URL><A>x1</A><B>x2</B><C>x3</C></URL>
3		     <URL><A>y1</A><B>y2</B><C>y3</C></URL>
4		     <URL><A>z1</A><B>z2</B><C>z3</C></URL>

There are about 10K rows in this table, and only the URL column needs to be dumped into a file and sent to an FTP server. There should be a check if the file is more than 10MB in size, and if it is, the file needs to be splitted into smaller files, each of size 10MB or lower.
The structure of the output file will be just something simple like this:

Code:

<URL><A>v1</A><B>v2</B><C>v3</C></URL>
<URL><A>x1</A><B>x2</B><C>x3</C></URL>
<URL><A>y1</A><B>y2</B><C>y3</C></URL>
<URL><A>z1</A><B>z2</B><C>z3</C></URL>

In case the size exceeds 10MB, splitting this file will be easy with the SPLIT function, based on the size limit. But the problem is that each URL XML is extremely large, and the output file has got it's limit on the length of a single line, so the output file is being generated as something like below

Code:

<URL><A>v1</A><B>v2</B>
<C>v3</C></URL>
<URL><A>x1</A><B>x2</B>
<C>x3</C></URL>
<URL><A>y1</A><B>y2</B>
<C>y3</C></URL>
<URL><A>z1</A><B>z2</B>
<C>z3</C></URL>

I found it tricky to split this file, since the SPLIT function won't understand XML tags.

I have been successfully splitting file with sample data in my table where the XML length is much smaller. As in the above example, my script works perfectly. However, it's the Production data that's causing the problem.



Thanks a lot Chubler_XL. I'll surely try out your idea. It looks good to me. I've found that in my version of Linux, the STAT command is available. I'll try this out and let you know.

Thanks again,

- Avik