case insensitive
Moderators: chulett, rschirm, roy
case insensitive
Hi-
Error when checking operator: Unrecognized type-specific format properties: {case=insensitive}; on key "column"
Error when checking operator: Unrecognized type-specific format properties:
What is this error? any idea on this one
Thanks
Error when checking operator: Unrecognized type-specific format properties: {case=insensitive}; on key "column"
Error when checking operator: Unrecognized type-specific format properties:
What is this error? any idea on this one
Thanks
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive.
Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
Where can i find that case sensitive optionNageshsunkoji wrote:Hi,
Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive.
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
First thing is, which stage your using Sort,Rmd or join ??laxmi_etl wrote:Where can i find that case sensitive optionNageshsunkoji wrote:Hi,
Here the problem is, your using a CHAR as a Key column and your checking the case sensitive or insensitive. Just check the key fields and select the option case sensitive and try out the result. Your key has a unspecific format. Just check the datatype and select the option of Case sensitive.
If you make right click on the key properties, you are able to see the options like Case Sensitive or Insensitive.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Please provide the full details, then only you will benefit from DSxchange. If you are using lookup, which version you are using. If it is 7.5.1, the check the datatype of both input and reference link. Both should be the same and check the condition for look up failure, whether it is Continue or fail.laxmi_etl wrote:we are using lookup stage
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
Inside the Look up stage - on the reference link tab you have a check box against each of the columns to define if you need a case sensitive look up or a case insensitive lookup against the keys.laxmi_etl wrote:we are using lookup stage
Check the datatype for your keys and also the case sensitive/insensitive check box.
On which stage is this error thrown?? Are you sure its in the Lookup stage. THis can also happen in the partitioning tab when you ask DS to do a case sensitive /insensitive sort on an incompatible data type.laxmi_etl wrote:I did that but still its not working
For Eg: a case sensitive sort for a numeric field.
Do you have something like this in your job?