Rows in IXF file

[=?ISO-8859-2?Q?Gregor_Kova=E8?=]

Hi!

I have a file TABLE1.IXF and want to know how many rows are in there.
How to do it?

Thanks and best regards,
Kovi

--
_______________ _____________
|http://kovica.blogspot .com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

[Jan M. Nelken]

Re: Rows in IXF file

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/infocenter/db2luw/v9r5/index.jsp

for example this topic:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.dm.doc/doc/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

[=?ISO-8859-2?Q?Gregor_Kova=E8?=]

Re: Rows in IXF file

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/infocenter/db2luw/v9r5/index.jsp

>
for example this topic:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.dm.doc/doc/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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-