Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
What is the data type of that field?
The book says the column type is Longvar.
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.
Thank you.