Is there anyway to use an ALTER FRAGMENT statement with a SQL stored procedure and have a host variable as part of the statement.

ex..
ALTER FRAGMENT ON TABLE fact_orders MODIFY
bbuorders013 TO snapshot_seq = 3
AND snapshot_date_seq = ws_date
bbuorders013;

ws_date would the host variable containing a value such as '2004-11-15'

I receive a -873 when I try this.


Thanks for any help

Hi,

Please test:

Remember define DBDATE=Y4MD-.
ALTER FRAGMENT ON TABLE fact_orders MODIFY
bbuorders013 TO snapshot_seq = 3 ,
snapshot_date_seq = extend(ws_date,year to day) in bbuorders013;

Gustavo.

Thanks but I got the same error message.