postscript filter question

[pjb]

Opentext recently sent out a security alert regarding postscript filters supplied my Stellent. The first question our peoplle had was do we use postscript type files? Is there any way for me to find that out?

 

[appnair]

the filetype and mimetype field in your dversdata table should tell you whether you have postscript.Add a post script file in your livelink,note its dataid.Now run this

select * from dversdata where docid in <substitute the datid you got>

.Look at the filetype and mimetype field.Now you can run it on your whole datbase like

select docid,mimetype,filetype form dversdata
where filetype like 'the exact string represention you got form the earlier excercise' and mimetype like '<you know>'

If this is a large number database extract it with rownum clauses or contact your dba to see if there are any indexes on the table you could use

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

there were typos in my databse statement form is catully from.I am not very good in typing.I assume you know how to write select statements

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937