Thanks for the info.
So, if I have a table with 100 rows and export them and then count D
records with IXFDRID='001', the number I get is never less than 100, right?
Less because you say there can be XMl columns, ....
Best regards,
Kovi
Jan M. Nelken pravi:
Gregor Kovač wrote:
>I have a file TABLE1.IXF and want to know how many rows are in there.
How to do it?
Simplest way is to import into temporary table and select count(*) from
that table :-)
If you review IXF format descibed in online documentation available at:
http://publib.boulder.ibm.com/infoce...v9r5/index.jsp
for example this topic:
http://publib.boulder.ibm.com/infoce.../r0004668.html
and read IXF file counting 'D' records with IXFDRID='001' you *may* get
a good approximation on number of rows in the IXF file.
Keep in mind that LOG locator columns, XML columns have their D records
as well (there is one or more 'D' records per row).
Jan M. Nelken
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-