well folks I think I found my problem.
If I start RBW then do Unload all, everything is OK. Then I run SET ZERO ON SET WRITECHK ON SET CLEAR ON and the output file is smaller and I loose the rows. Then I set writechk off and did another unload all and it worked fine. It seems that writechk on will not allow all of the rows to be written to the output file and it appears to be the tables with dates. Am I crazy or is this possible? marc --- Bill Downall <[EMAIL PROTECTED]> wrote: > Marc, > > Actually, you have the optimum settings here. The > "format" is the usual > output. the "sequence" is the expected input. If > you had YYYY in your > sequence, you would be forcing data entry to type > all four digits all the time, > otherwise the years would be stored as 0003, 0004, > 0005, etc, instead of > 2003, 2004, 2005. > > I'm quite certain this doesn't have anything to do > with your problem. > > Bill > > On Fri, 8 Aug 2003 07:58:36 +0100, Alastair Burr > wrote: > > >Marc, > > >I don't know if it will cause any problems but your > date sequence contains > >only 2 characters for the year and the format > contains all 4. > > >As the format tries to display what's in the > sequence you may not be > seeing > >everything. > > >The only other thing that might be causing a > problem is that your NULL > >statement is near the end and not at the start when > begin to define the > >pairs of settings. If you have some weird null to > start with - unlikely, but > >not impossible - then you might be getting some odd > effect. > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
