handling character datatyes using dynamic SQL

Database
N/A

handling character datatyes using dynamic SQL

Hi,

I want to know what happens when we use dynamic SQL in Teradata to retrieve character data.
If we retrieve a Char(12) or a Varchar(12) field to a C variable of type char, does the data contain a null-termination?

What should be the length of my host variable and will it contain a C style null-termination, '\0', if valid data is returned (i.e. data on database is not NULL)?

Any help would be great.

1 REPLY

Re: handling character datatyes using dynamic SQL

till today, I havent seen null termination as you mention it. maybe there are but i dont know any in the case u mention