Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    4

    Unanswered: Alter table fragmentation with stored proc

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

  3. #3
    Join Date
    May 2004
    Posts
    4
    Thanks but I got the same error message.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •