Order Date Change -- SQL Needed ?
- 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