Sef
VIP Member
I know this issue has been discussed in some shape or form before, but I could not find a satisfactory answer in the forum's history.
One of my clients is about to upgrade from B7322 (SP 12.4 on NT, SQL 7) to ERP8.
We are trying to record all current versions with their respective processing options. Unfortunately B732.2 does not have a tool to do this. R98306 / B9200030 does not exist and even retrofitting the UBE and BSFN doesn't work because of the new NID API's. Does anybody know of a work around or has anybody developped a tool here?
I found some information from a while back on 'manually interpreting BLOBs' and I am aware of the tables where all relevant data is stored. I just would love to know if anybody has succeeded in writing a simple app to extract all this info.
By the way, the following SQL at least lists all objects and versions and all the processing option text. It's the actual values that are missing. For somebody to actually manually populate all (in our case) 39000 settings is going to take an eternity.
select VRPID, SIMD, VRVERS, VRJD,PTOBNM, PTITNUM, PTPOTX from prodb732.f983051, prodB732.F98306, OBJB732.F9860 where VRPID = SIOBNM AND VRDSTNM = PTOBNM AND PTPOTP = '1' order by vrpid, vrvers, PTITNUM
Your help would be greatly appreciated.
Rgds,
One of my clients is about to upgrade from B7322 (SP 12.4 on NT, SQL 7) to ERP8.
We are trying to record all current versions with their respective processing options. Unfortunately B732.2 does not have a tool to do this. R98306 / B9200030 does not exist and even retrofitting the UBE and BSFN doesn't work because of the new NID API's. Does anybody know of a work around or has anybody developped a tool here?
I found some information from a while back on 'manually interpreting BLOBs' and I am aware of the tables where all relevant data is stored. I just would love to know if anybody has succeeded in writing a simple app to extract all this info.
By the way, the following SQL at least lists all objects and versions and all the processing option text. It's the actual values that are missing. For somebody to actually manually populate all (in our case) 39000 settings is going to take an eternity.
select VRPID, SIMD, VRVERS, VRJD,PTOBNM, PTITNUM, PTPOTX from prodb732.f983051, prodB732.F98306, OBJB732.F9860 where VRPID = SIOBNM AND VRDSTNM = PTOBNM AND PTPOTP = '1' order by vrpid, vrvers, PTITNUM
Your help would be greatly appreciated.
Rgds,