Registered tables and String length

Hiya,

We are developing some custom dfc code to read and extract from a registered table to allow us to import docs into the repository.

One of the attributes in the table will be a 64b Binary string representing the content ( a pdf file). The column is set as [DocB64] [varchar](max) in the creation statement. How do I translate that when registering the table?

The attribute is registered as as String which needs a length defined for it, and it doesn't appear to like the key word MAX.

Any ideas?

Thanks

Hoo

Find more posts tagged with

Comments

lastnitescurry

You do not need to be accurate with column names and types when registering a table. I register mine with one int column

andreacg

Did you have any luck? We are facing the exact same problem right now and wondering about going down the route of JDBC to get the data out instead of registered tables.

Thanks for your help!