Hi,
I wonder why BMC chose a proprietary compression mechanism. I don't see
the benefit, really. Except possibly if BMC programmers has developed a
more efficient mechanism than exists elsewhere.
Why not publish the code for it?
My point of view is to use the API anyway.
To quote a recent post from Doug Mueller: "As someone has already
mentioned, other than for your amusement and amazement, it is bad practice
to access the T tables directly..."
I would think that this would include the B-tables as well ;-)
Best Regards - Misi, RRR AB, http://rrr.se
> Attachments are stored in a proprietary compression format so you cannot
> retrieve them without using the API to decompress them.
>
> Since you are on SQL you could possibly use the ARS ODBC to pull the
> attachment (but I have not tried that)
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Sharp
> Sent: Thursday, August 16, 2012 5:06 PM
> To: arslist@ARSLIST.ORG
> Subject: Retrieving Attachments from ARS DBs ?
>
> **
> Hi All -
>
> Our SQL DBA is looking for best practice advice on how to retrieve
> attachments in INC and CRQ records/work info entries. On page 37 of the
> DB ref guide, it tells what table(s) to find the attachment images, which
> we have found.
>
> Goal: To retrieve documentation files that are part of work info entries,
> and are in the ARS attachment data tables.
>
> Environment: ARS 7.02 and SQL 2K8
>
> Has anyone done this in the past ? Do you have an example of the SQL
> statement ? The field element in the B/C tables indicates the attachments
> are "imaged" types.
>
> Thanks in advance very much !
>
> Rick
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
