Home > Archive > PowerBuilder > May 2004 > Using Sybase image data type in PB 9.x datawindow?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using Sybase image data type in PB 9.x datawindow?
|
|
|
| A user asked me the other day if PB 9.x would support the image datatype
they had in one of their Sybase 11 DBs. Being Oracle oriented (8i), I told
them I hadn't a clue, but I'd try to play with it and see. In my limited
time, I found no documentation on it, so I tried to throw together a DW to
access the datatype. PB gives me an error saying that an embedded SQL
statement must be used to access this datatype.
Can anyone shed light on how to set this up? Just looking to show the image
at this point - proof of concept stuff.
Thanks
Gary
| |
| Jim Douglas 2004-05-12, 9:11 pm |
| You can't access data types of type "text" from a stored procedure, you must
use embedded SQL. Is that the datatype you were trying to access?
"Gwood" <sorry@nothere.com> wrote in message
news:2gd3fgF1ecfbU1@uni-berlin.de...
> A user asked me the other day if PB 9.x would support the image datatype
> they had in one of their Sybase 11 DBs. Being Oracle oriented (8i), I
told
> them I hadn't a clue, but I'd try to play with it and see. In my limited
> time, I found no documentation on it, so I tried to throw together a DW to
> access the datatype. PB gives me an error saying that an embedded SQL
> statement must be used to access this datatype.
>
> Can anyone shed light on how to set this up? Just looking to show the
image
> at this point - proof of concept stuff.
>
> Thanks
> Gary
>
>
| |
|
| No. The datatype actually shows as 'Image'. When the DW painter accesses
the table definition, I see all the column attributes as usual. Being a
Sybase table, I see descriptions like
Contact_name varchar(60)
Contact_id int
bill_image image
etc...
When I attempt to select the bill_image column for the DW, a pop-up tells me
"This columns data type requires the use of an embedded SQL statement."
"Jim Douglas" <james.douglas@genesis-software.com> wrote in message
news:Gbxoc.35282$z06.5529785@attbi_s01...
> You can't access data types of type "text" from a stored procedure, you
must
> use embedded SQL. Is that the datatype you were trying to access?
|
|
|
|
|