skamat
26th August 2005, 09:19
Hi All,

Whenever we take any seq dump of any Company using ttaad4226m000 , we also give name of an error file . for e.g taking seq dump of an employee table(tc com001) of Co 100 , I gave filename as emperr100.txt.
It created the dump properly .
Below are the contents of the sample error file.
It shows
Table RowCount Messages
----------- -------- ----------------------------
tccom001100  100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000 4100 4200 4300 4400 4500 4600 4700 4800 4900 5000 5100 5200 5300 5400 5500 5600 5700 5800 5900 6000 6100 6200 6300 6400 6500 6600 6700 6800 6900 7000 7046

What is the meaning of these numbers and the rectangles ? Can someone explain ? [ Does it mean there are total 7046 rows in that table ?]

Regards
skamat

en@frrom
26th August 2005, 09:28
This output is an output which does not show any errors. It shows the number of rows dumped, for each 100, and at the end the total number (i.e. 7046) of records dumped. I would appreciate if anyone told me about more information you can take out of this file, but I doubt it.

What I do when I dump a table: I look at the total number of records dumped, then make a count on the table (or count the selected range of records in the table), and validate that they match. I think only of it goes wrong, there will be more information in the file...

Regards,
En

victor_cleto
26th August 2005, 15:18
The error file contains the screen output of the bdbpre command.
If you are doing an import it is the screen ouput of a bdbpost and read below export as import.

Each certain ammount of rows Baan writes the nr. of rows exported (writes a nr., then writes backspaces and writes the new nr., and so on; on UNIX a cat of the file displays this correctly and you see the same nr. increasing, on Windows I don't think it handles properly the backspace character).
The last write it is the nr. of rows that were exported.

If all went ok, this last nr. is = count(*) [rows] of the table, and no warning or error message is written in that file.