DOC_TYPE and FIXED_VIEW fields Value from ARSAPP table

[yousuf_gani]

Hi,
I need to Query(Oracle Ondemand table ) for the following info
- APPLICATIONs DOC_TYPE and the
- Format (EXTENSION=) from FIXED_VIEW filed if "USER-DEFINED" is Doc_type

I tried from the ARSAPP table I see the DOC_TYPE has the HEX_CODE and FIXED_VIEW is CLOB type

Any Conversion / SELECT query routine to get the Actual DOC_TYPE and EXTENSION detail from this Tables fields.?

Please do the needful help...

[Norbert Novotny]

Hi Yousuf,
This is not a complete answer to your question but could help:

Code: [Select]

ARSAPP.DOC_TYPE
--------------------
41 = AFP
4C = line
42 = BMP
47 = GIF
50 = PCX
54 = TIFF
52 = PDF
4A = JFIF/JPEG
51 = PNG
4D = Metacode
55 = User defined
4E = None
Reading CLOB you can just select with cast, most of CMOD CLOB are relatively small in size.
Parsing the CLOB read the ORACLE reference for regex.

Hope this helps,
 N.

[yousuf_gani]

Thanks you so much Norbert...
I will try with the SQL to get required Data from the OD - Oracle Table based on the mapping HEX code.

[Justin Derrick]

Check out the wiki if you want to learn about IBM CMOD database tables... https://cmod.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables

-JD.