Blob or VARCHAR(2048) FOR BIT DATA in DB2

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
I'm trying to run a stored procedure with Blob or VARCHAR(2048) FOR BIT
DATA. When the procedure get the input variable it looks like data is
being cut when there is 0 although it is not a string.

In the client program we use DBTYPE_BYTES that should match both types
(blob and varchar for bit data).

The DB2 version we use is 8.

Thanks,
Gilad.

.

Relevant Pages

  • Re: BLOB storage ADO.NET
    ... Inserting a blob value into the database never seems ... I am sure i ma using the correct syntax....I am using Oracle ... Oracle stored procedure ... dataParameter.Value = blobValue; ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Calling DB2 Stored Procedures through DBD::ODBC
    ... > connecting to DB2 ... The short answer is you need the ODBC syntax wrapped around it. ... > The second thing is if I can run the stored procedure through ...
    (perl.dbi.users)
  • Re: errors calling linked oleDB server stored procedures
    ... The remote database is not DB2, ... So I am not sure whether the provider you used could support ... would you please try to call a stored procedure without dynamic ...
    (microsoft.public.sqlserver.programming)
  • SQL Paging with VS2005
    ... I don't know why All my stored Procedure which provide custom pageing don't ... @WhereCriteria varchar = NULL, ... DECLARE @WHEREWord varchar ... IF @PageIndex!= 0 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Listing and viewing forms with DB2/AS400
    ... I work as a programmer in a call center. ... What I want to do is open a form, enter some data and update the DB2. ... With STRSQL (iSeries/Navigator SQL ... I am unable to run a stored procedure with question mark. ...
    (comp.sys.ibm.as400.misc)