I'm trying to use the CHR function. Using the syntax:
I get an error message "SELECT Failed 3706: Syntax error: expected something between '(' and the integer '66'.
I assume there is some sort of configuration issue involved, but I have no idea how to begin to diagnose where the problem is.
This quesry is running fine at my end both at Bteq and SQL Assistant, and I have checked it at bother versions (13.10 & 14).
Can you please paste the actual query you are trying to run in your script?
further, You can refer to this post, it might help you: http://forums.teradata.com/forum/database/tab-in-column
My apologies to those who responded to my query. I was relying on the forum's email notification funtion to tell me someone had responded to my question. I didn't receive an email on this post.
Now I don't even remember where I was running into the problem. I know I've addressed the issue, but I don't remember what my solution was. Sorry.