convert to text

[Anonymous]

This is my load:

REQUIREMENT:

LOAD ROWID,

    WORKORDER_TYPE,

    WORKORDER_BASE_ID,

    WORKORDER_LOT_ID,

    WORKORDER_SPLIT_ID,

    WORKORDER_SUB_ID,

    OPERATION_SEQ_NO,

    PIECE_NO,

    TYPE,

    BITS,

    BITS_LENGTH;

SQL SELECT *

FROM .dbo.REQUIREMENT;

There is an i next to the bits not sure what that means:

This is in the sql select window.

This is what is loaded when I don't make any changes:

What should be in the bits column is below:

it should read "WTG DATA" or something like that. 

I'm not sure how to make this conversion to a legible text line. 

Any help would be much appreciated.  Thank you!

[Anonymous]

What is the data type of that field?

[Anonymous]

The book says the column type is Longvar.

[Anonymous]

I'm guessing this is actually a BLOB/CLOB then. I would cast/convert it to varchar2 on the database side before bringing it into QV and see what happens.

[Anonymous]

Thank you.