• 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