Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    Order Date Change -- SQL Needed ?

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Is it possible to change the open date, order date, and status date for a single order record (66216-1) from 20060901 to 20060831. If this can be done via sql could you provide me with the code?

    Resolution:
    Here is the SQL:

    SQL> update z68 set Z68_OPEN_DATE = '20060901', Z68_ORDER_DATE = '20060901', Z68_ORDER_STATUS_DATE_X = '20060901' where z68_order_number = '66216-1';

    You should get a response "1 row updated".

    If you are going to use this for multiple records, be sure to run p_file_03 to back up the z68 table before doing so.

    Jerry

    • Article last edited: 10/8/2013