Skip to Content
0

Selecting SQL server varchar(max) into datawindow?

Jan 11, 2017 at 07:37 PM

206

avatar image

Can you exceed the 32k max for a character column? I've seen reference to select blob... but I'd like an example. :)

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Chris Pollach Jan 11, 2017 at 08:31 PM
0

Hi Matt;

Have you looked int using the new DW's TableBLOB feature for this that was introduced into the newer PB Versions?

Regards ... Chris

Share
10 |10000 characters needed characters left characters exceeded
Matt Balent Feb 02, 2017 at 08:10 PM
0

Well I handled my situation like this.

I am selecting information from a SQL Server database which has a varchar(max) column. Creating a datawindow in PB converts these into a char(8000). For probably 90% of the time this is sufficient. For the other times I save the data into another table, use a second datastore to select against the same record set but looking for fields where the varchar(max) column exceeds the 8000 limit, then I loop through these records and create a dynamic cursor for each and select the varchar(max) field into a string variable. I then update the corresponding record with the string variable.

Share
10 |10000 characters needed characters left characters exceeded
Aron Cox Feb 07, 2017 at 01:56 PM
0

I believe I have retrieved 1,000,000 chars before, it does slow down though. You can create the datawindow then edit the source and change the length of the field to whatever you want (I think, it's been a while!)

Share
10 |10000 characters needed characters left characters exceeded