Re: Ways to clear a lookup table.

[*Haixiang Yee <hyee@SMTPGW.ARMS.OHIO-STATE.EDU>]

After digging into this problem, I discovered that my problem is not related
to clearing the lookup table.  After a few trials, the lookup table DOES
clears
each time your rebuild it.

My problem is that I embeded the variable $sysdate in the string of the
where clause.  So it reads  effdt <=$sysdate instead of effdt
<='07-JAN-2000'
as it should.

But I still don't understand why the load lookup table did not catch the
problem the first time it builds the table.

Thanks to everyone,
-Hai




> ----------
> From:         Juan Enrique Muņoz[SMTP:enrique_munoz@KAIZEN.COM.MX]
> Sent:         Saturday, January 08, 2000 11:51 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: Ways to clear a lookup table.
>
> Then, there isnt way to clear the lookup table with a sqr command or with
> a
> option in some sqr command?
>
> -----Mensaje original-----
> De: KBLUMEN@SEARS.COM <KBLUMEN@SEARS.COM>
> Para: SQR-USERS@list.iex.net <SQR-USERS@list.iex.net>
> Fecha: Viernes, 07 de Enero de 2000 10:53 a.m.
> Asunto: Re: Ways to clear a lookup table.
>
>
> >
> >
> >You could create a unique lookup table name within the loop with each
> iteration
> >by doing something like this:
> >let #num = 0
> >while 1
> >
> >        do Get-Lookup-Where-Clause
> >        do Build-LookupTable-ABC (in this procedure concate the lookup
> table
> >name with num)
> >        do Other-Things
> >        add 1 to num
> >end-while
> >
> >
> >
> >
> > (Embedded
> > image moved   *Haixiang Yee <hyee@SMTPGW.ARMS.OHIO-STATE.EDU>
> > to file:      01/07/2000 10:01 AM
> > pic32406.pcx)
> >
> >
> >
> >
> >Please respond to sqr-users@list.iex.net
> >
> >To:   SQR-USERS@list.iex.net
> >cc:    (bcc: Kimberly Blumenberg)
> >Subject:  Ways to clear a lookup table.
> >
> >
> >
> >
> >Hi,
> >
> >I have a program that builds a lookup table through each
> >iteration under different criteria.  Apparently, the table
> >does not get cleared each time you rebuild it based
> >on different criteria.  In fact, it produces an error
> >if I try to build it a second time.  Its there ways to get
> >around this?
> >
> >For example:
> >
> >while 1
> >        do Get-Lookup-Where-Clause
> >        do Build-LookupTable-ABC
> >        do Other-Things
> >end-while
> >
> >It would error out during the second iteration of the loop.
> >
> >Thanks,
> >-Hai
> >
> >
>