How to convert ASCII value to Character in PI OLEDB view?
For example, in SQL I use Char (value) function to return ASCII value.
Could you explain more about the environment you are using?
Are you using a Linked server configuration for PI OLEDB Provider?
If so, could you try with Pass-through query? Or try casting strings first.
PI OLEDB Provider User guide
PI OLEDB doesnt not support all the functions from MS SQL.
However , there can be 2 options to achieve this:
Option 1 : Do the ASCII to Char conversion in AF using Analysis (CHAR(number)) and use this attribute in the PI OLEDB View
Option 2 : Use Linked Server concept of MS SQL and write the view using MS SQL where you can use all the function available in SQL. More details about setting up a Linked Server can be found in the below link.
Actually we have implemented in SQL. But I was looking to find way we can construct query in PI OLEDB view itself. That way I can troubleshoot issue quickly by looking at PI OLEDB data and not to rely on SQL every time.
Retrieving data ...