Re: How to retrieve PeopleCode (long raw data type)?

["Ivory, Wayne" <wivory@WSL.COM.AU>]

Yuwen,

I have previously asked PeopleSoft for a method for decoding this
information.  The response was that it was proprietary info.

Sorry.

Wayne Ivory
Information Services
Westralian Sands Limited


-----Original Message-----
From: WANG_YUWEN [mailto:SQR-USERS@list.iex.net]
Sent: Wednesday, 12 May 1999 23:58
To: SQR-USERS@list.iex.net; WANG_YUWEN@SMC.EDU
Subject: Re: How to retrieve PeopleCode (long raw data type)?


Thanks for the tips. We are using version 7.5 here. Basically my original
question was how to retrieve Long Raw data. I need to retrieve the
PeopleCode only for particular customized Records. And the requirement is to
retrieve it from the database, instead of using the Application Designer or
other peopletools.

I know the PeopleCode is stored in the peopletools table PSPCMPROG. The data
type of that particular column is LONG RAW. The problem is that whenever I
use select statement to retrieve this column, I get the error message
'inconsistent datatype'. It seems to me that there is no way to retrieve the
long raw data using 'select'.

Any idea, why and how?

Thanks.

- Yuwen