Running simple SQL

[cyclogenisis]

Hello,

Looking to run two groom statements against tables.

GROOM TABLE schema.sometable1 RECORDS ALL;
GROOM TABLE schema.sometable2 RECORDS ALL;

How can I run these commands? No data will be coming back so not sure if it is possible to use Netezza connector stage on its own or if I need some sort of dummy stage.

Thanks in advance.

[chulett]

Typically one could run something like that in either the "Before SQL" area or the "Open Command" area, depending on the stage, and they would execute before any actual target SQL was performed. I typically trigger these with a 'dummy' source that doesn't actually select any records as that is enough to trigger any "before" action.

And by dummy I mean something like this in Oracle:

Code: Select all

select 1 from DUAL where 1=2;

[cyclogenisis]

Thanks.