case insensitive

[laxmi_etl]

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

[Nageshsunkoji]

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.

[laxmi_etl]

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.

Where can i find that case sensitive option

[Nageshsunkoji]

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.

Where can i find that case sensitive option

First thing is, which stage your using Sort,Rmd or join ??

If you make right click on the key properties, you are able to see the options like Case Sensitive or Insensitive.

[laxmi_etl]

we are using lookup stage

[Nageshsunkoji]

we are using lookup stage

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.

[thebird]

we are using lookup stage

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.

Check the datatype for your keys and also the case sensitive/insensitive check box.

[laxmi_etl]

I did that but still its not working

[thebird]

I did that but still its not working

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.

For Eg: a case sensitive sort for a numeric field.

Do you have something like this in your job?

[laxmi_etl]

Yes,I am getting error on lookup stage.

I dont have this tab and I am using 7.5.2 edition on Unix.

And the datatype is also correct as table structure in database.