Unable to retrieve data(using dql) from a documentum registered table with varchar(max)

blessbk

Hi,

We have the following sql database table.

CREATE TABLE [dbo].[EmailActivityReport](
...

[Event] [datetime] NOT NULL,
[ActivityDesc] [nvarchar](max) NOT NULL,

[ActivityName] [varchar](50) NOT NULL,
[Created] [datetime] NOT NULL
) ON [PRIMARY]
GO

We have registed it by running the following dql

Register table dbo.EmailActivityReport (..,Event TIME, ActivityDesc STRING(5000), ActivityName CHAR(50), Created TIME)

The registration was successfull.

Select * From dbo.EmailActivityReport

When we try to run DQL query to retrieve data from the table, it returns data for all the fields, except ActivityDesc column. We wonder is it because the 'ActivityDesc' field length is too long. Do you have any idea why the dql doesn't return value for ActivityDesc field, eventhouh it has value in the table and it returns values for all other fields.

username	userdisplayname	event	activitydesc	activityname	created
john	jojn	9/12/2010 8:00 AM		ryinhfkdng	9/12/2010 8:00 AM

Please help us

Thanks in advance

With Regards

bless

Miller-zzMST

Hi!

May the problem really is the length of the string? Look at the DQL Reference Manual, chapter "Character string literals":

"The maximum length of a character string literal is determined by the maximum allowed by the
underlying RDBMS, but in no case will the maximum length exceed 1999 bytes."

Regards, Konstantin