Compare Tool - Processing Options?

DBohner-(db)

Legendary Poster
Howdy, Yes, it is snowing again in Idaho... but you don't want to know the
informal stuff...

I have been paying GREAT attention to the comments regarding Custom Objects
referencing the Processing Options of JDE (BASE) Object Versions with Like
Names.... With particular interest to P4210 customized to P564210. I, too,
can confirm that Versions specific to the P564210 must be replicated with
'like named' versions to the P4210! Thank you so much for the input.

Now... is there a way to compare Versions and Processing Options? I realize
this is a long-shot question... but I have to ask. If we have several dozen
(hundred) versions for the P564210 - how do we make sure that they have
matching 'like named' versions on the P4210 and that the Processing Options
are the same?

Where are the Version Names kept?

Where are the Values for the Processing Options Kept?

If it is as simple as comparing records in tables - I'd like to build and
post the logic. The first step is to compare if there is a like named Base
Version for each version of a copied/modded object. That I know is stored
in tables OL? What I don't know is if there is a place that stores



the Processing Options and Values for each version..

Thanks!



Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x
 
If I'm not mistaken the short answer is NO. (please someone tell me I'm
wrong)

Version specs are stored in a BLOB (binary large object) field in the
F983051 (Oracle/SQL). This is where data selection, security, output queue
and all the other version options are stored in a binary format. You can use
the TAM Browser to view other Blob fields for other specs but I don't know
of any way to view the BLOB's in the F982051. Unless you're good at reading
binary you might just be out of luck. (I really hate the BLOB field
especially when I want to move a report from the QB7332 queue to a FINBATCH
or PAYBATCH queue).

Processing options are stored in the F98306.

If you every figure this out I'd be very interested in the answer.



Colin


Colin Dawes
City of Guelph (somewhere near Toronto, somewhere in Canada)
B733.2 SP17.1_B1, Intel/NT/Oracle 8.1.7.1 FAT & TSE
 
R98306 would be great for our documentation, but it appears to print out only your processing option choices, not the actual values being used in the version. Am I missing something?

Xe, SP 15.1, Update 2, ES=AS/400 V4R5, CO=AS/400, Deployment=AS/400 INS Card, Thick & Citrix Clients
 
If you run the UBE R98306 locally instead of on the server, you should get the processing option values for your selected versions. I have been able to do this in past versions of Xe. I am not sure what the release level was at that time but it was in early 2001.
 
Thank you. This worked fine, once I ran it locally, and I will be using it
as a standard part of our documentation.



Xe, SP 15.1, Update 2, ES=AS/400 V4R5, CO=AS/400, Deployment=AS/400 INS Card, Thick & Citrix Clients
 
Back
Top