Re: DSPFD QAFDBASI (QWHFDBAS)

[Buck <kc2hiz@xxxxxxxxx>]

Tom Liotta wrote:

>  > refresh table SRCFLIST
>
> But this has me wondering about how a REFRESH might affect any INSERTs 
> that were previously done. Are the INSERTs needed after every REFRESH? 
> (And if not, how's that work? Heh.)

Right.  REFRESH TABLE wipes the table clean and starts over, so your 
inserts/updates/deletes are no longer present.  I'd guess that if you 
were to modify the table after a REFRESH it'd be table-driven:

refresh table srcflist

insert into srcflist (select table,lib,'S','M' from MY_INTERNAL_MENU_DRIVER)

delete srcflist where system_table_name in (select table from 
FILES_FROM_A_VENDOR)

Programmers always see a tool in stuff like this :-)