Service Manager / Service Center Practitioners Forum

Mining Structured arrays in BLOBs

Andy Plant
Frequent Contributor.

Mining Structured arrays in BLOBs

This isn't a question it is a bit of knowledge that I just gleaned out of HP after 3 months of bashing on the door I finally got throught to R&D. If you want to use a toolset like Crystal reports and the like to mine data stored in structured arrays inside SM7 there is a quick fix that works a treat. In quotes is the response from HP.
"I have checked this with one of our lead engineers and he has told me of the following process where you can map fields in the labor structure to a new table and you can then run your reports off that instead of the probsummary table.

Go to database dictionary and bring up the probsummary table. Double click on the labor structure which will open a popup window where you can enter a Attribute file name and unique Attribute. Add a file name in both fields, eg: laborattribute and laborunique. Click OK and OK again to exit the dbdict.
The laborattribute table will have the fields in a normal scalar fashion, ie: text, date/time, number etc. Not a blob/clob.
You can then report off of the new table from the rdbms. The unique id is also included in the new table, so you will have the ticket number."
Outstanding Contributor.

Re: Mining Structured arrays in BLOBs

Just wanted to raise this - great tip by Andy Plant. If you need to make reports by making queries to SQL database, this is essential to get data out from for example "clocks" table. We're tracking how long different assingment groups are holding the tickets...

To get good answers, ask good questions.