LONG RAW issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am
LONG RAW issue
Hi,
My job :
oracle connector stage-> transformer -> teradata connector stage
in source DDL there is a column as data. datatype is LONG RAW. while imporing into oracle connector stage it is takeing as longvarbinary.
my target column data type is varchar(4000).
but while I am compileing my job I am getting compilation error in transformer. I did not use any conversion function for this column.
error:
Error in output column derivation expression for column DATA in link out_CSPRO_OPP_EMF. Invalid conversion requested from a raw to a ustring.
Please help me.
My job :
oracle connector stage-> transformer -> teradata connector stage
in source DDL there is a column as data. datatype is LONG RAW. while imporing into oracle connector stage it is takeing as longvarbinary.
my target column data type is varchar(4000).
but while I am compileing my job I am getting compilation error in transformer. I did not use any conversion function for this column.
error:
Error in output column derivation expression for column DATA in link out_CSPRO_OPP_EMF. Invalid conversion requested from a raw to a ustring.
Please help me.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You are too hasty in using the term "junk". This raw string contains your client's real data - not rubbish. Not every character in a raw string is necessarily printable. This does not preclude valid data being stored.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am
we asked the sample data for the long raw column. But sample data contains more than 4000 characters. If I am trying insert into long raw column it is throwing error.it is allowing me up to 4000 characates.
sample data:
0400060000001200000026020B0000004561726C79204461746573080000004163746976697479170000004B53435F4E6F6E5F437269745F4E6F6E5F4D535F464C5400000000080005000300D20F26020B0000004561726C7920446174657308000000437269746963616C120000004B53435F437269745F4E6F5F4D535F464C5400000000080002000300D20F26020A00000053756270726F6A6563740B00000053756D6D617279204261720A00000053756270726F6A65637402001500170006000700D60F26020800000050726F67726573730800000050726F67726573731A0000004B53435F4E6F745F506C616E6E65645F4E6F6E5F4D535F464C5400000000000006000700D60F26020A000000546578745F4461746573000000000E0000004B5
I have to insert sample data. please help me.
sample data:
0400060000001200000026020B0000004561726C79204461746573080000004163746976697479170000004B53435F4E6F6E5F437269745F4E6F6E5F4D535F464C5400000000080005000300D20F26020B0000004561726C7920446174657308000000437269746963616C120000004B53435F437269745F4E6F5F4D535F464C5400000000080002000300D20F26020A00000053756270726F6A6563740B00000053756D6D617279204261720A00000053756270726F6A65637402001500170006000700D60F26020800000050726F67726573730800000050726F67726573731A0000004B53435F4E6F745F506C616E6E65645F4E6F6E5F4D535F464C5400000000000006000700D60F26020A000000546578745F4461746573000000000E0000004B5
I have to insert sample data. please help me.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 32
- Joined: Tue Dec 20, 2011 8:03 am
Why would you think you could insert 'sample data' that is > 4000 into a field with a precision of 4000?
Of course, you could trucate the string to 4000 and load it. You may also run into an issue with BYTE semantics - your target column may hold 4000 bytes which does not always equal 4000 characters.
Of course, you could trucate the string to 4000 and load it. You may also run into an issue with BYTE semantics - your target column may hold 4000 bytes which does not always equal 4000 characters.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers