On Tuesday 23 December 2008 6:43:56 am Herouth Maoz wrote:
>
> Well, every time this happens, I re-run the procedure, with all the
> lines in the data files up to the given table deleted. And it works.
> Then I restore the original data file. And the next day it works. It
> only happens once in a
Adrian Klaver wrote:
> On Sunday 21 December 2008 1:49:18 am Herouth Maoz wrote:
>
>> Adrian Klaver wrote:
>>
>>>
>>>
>>> Are you sure the problem is not in "$datefield" = "*" . That the script
>>> that formats the data file is not correctly adding "*" to the right file.
>>> Seems almost
On Sunday 21 December 2008 1:49:18 am Herouth Maoz wrote:
> Adrian Klaver wrote:
> >
> >
> > Are you sure the problem is not in "$datefield" = "*" . That the script
> > that formats the data file is not correctly adding "*" to the right file.
> > Seems almost like sometimes the second CMD is being
(Sorry for the forward, I forgot to CC the list)
On Wed, Dec 17, 2008 at 9:38 AM, Herouth Maoz wrote:
> and for non-transaction tables (ones that have records that might
> change but don't accumulate based on time) it's DELETE without WHERE.
In that case, you are better off using TRUNCATE instea
Adrian Klaver wrote:
>
>
> Are you sure the problem is not in "$datefield" = "*" . That the script that
> formats the data file is not correctly adding "*" to the right file. Seems
> almost like sometimes the second CMD is being run against the table that the
> first CMD should be run on. In ot
On Wednesday 17 December 2008 12:38:40 am Herouth Maoz wrote:
> I have a strange situation that occurs every now and again.
>
> We have a reports system that gathers all the data from our various
> production systems during the night, where we can run heavy reports on
> it without loading the produ
I have a strange situation that occurs every now and again.
We have a reports system that gathers all the data from our various
production systems during the night, where we can run heavy reports on
it without loading the production databases.
I have two shell scripts that do this nightly transfe
