In IBM Sterling B2B Integrator 5263 and higher, a new column called CREATION_DATE was added to TRANS_DATA. If you upgrade to 5263, all the old records in TRANS_DATA will have the CREATION_DATE set to the date of the upgrade. The following SQL query (oracle and db2) will give you TRANS_DATA monthly distribution based on the […]