User Profile

Collapse

Profile Sidebar

Collapse
jasonswett
jasonswett
Last Activity: Apr 10 '07, 10:18 PM
Joined: Mar 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • jasonswett
    started a topic Data type: FOR BIT DATA?
    in DB2

    Data type: FOR BIT DATA?

    Could someone please explain the concept of types being "FOR BIT DATA" to me? Here's the particular problem I'm having:

    I have a SELECT statement that's something like this:
    "SELECT col FROM table"
    Where "col" is of type CHAR () FOR BIT DATA. If I run this query, I get some results. Let's say one of the results is "100".

    If I then try to do this:
    "SELECT...
    See more | Go to post

  • jasonswett
    started a topic Mystery SELECT Statement
    in DB2

    Mystery SELECT Statement

    I'm looking at a C++ program written by someone else that has the following line:

    sql.replace( "select name(char51) into :name: from group where tech_id=" );

    The SQL statement has a value appended later to make the statement complete. My question is what is the "name(char5 1)" part? "name" is not a function, but a column in the "group" table.
    See more | Go to post
No activity results to display
Show More
Working...