• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Datawindow error when created from a SQL Server stored procedure with binary(max) column

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.