Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Datawindow error when created from a SQL Server stored procedure with binary(max) column

  1. How-to
0
Votes
Undo
  1. Marcos Bolonha
    Marcos Bolonha
  2. PowerBuilder
  3. Wednesday, 14 February 2024 14:39 PM UTC

Hi,

I'm trying create a DW from a MSSQL Server stored procedure that returns a varbinary(max) column.

The error message is attached file.

Any ideia how can I solve this problem?

 

One more info: the stored procedure returns some columns. The varbinary(max) is one of them.

 

I'm using PB 2022 R2 - Build 2819

MS SQL Server 2019 - 15.0.2000.5

Thanks in advanced.

Marcos

Attachments (1)
DW-Error-Binary-Column.png DW-Error-Binary-Column.png
question about CVE-2024-0056 vulnerability
Served Licensing question for 12.6
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 14 February 2024 16:14 PM UTC
  2. PowerBuilder
  3. # 1

Hi Marcos;

  Yes, a VarBinary (MAX) is considered a BLOB column that is not supported in any DWO's standard SQL processing. The alternatives are:

  1. Use the SelectBlob inline SQL command to retrieve that data.
  2. Configure the DWO to use the TableBlob feature (see PB help).

HTH

Regards ..> Chris

Comment
Marcos Bolonha
  1. Marcos Bolonha
  2. Wednesday, 14 February 2024 17:46 PM UTC
Hi Chris,



Thank you for your reply. I'll try your suggestions.



Regards.

Marcos
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.