Archives of the TeradataForum

Message Posted: Sat, 25 Sep 2004 @ 10:39:28 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Function "Monthname" in SQL Assistant

From:		Victor Sokovin

Michael,

Since Monthname is not even a Teradata function and being interpretted by SQL SA, I would try giving it an alias or a (title '<title name>') just like any other column. If you use the title option make sure that you have configured SQL SA to use title in the answer set option of the tools menu selection.

I'm afraid I don't see how the TITLE clause is going to help translate months into French.

I think the question comes from Oracle background where one can set one's own NLS settings for the client and get the SQL results customized to them (days, months, first day of the week, even SQL error messages, etc).

I did not do any special research on this particular function in the Teradata ODBC driver (that's where month names come from) but my guess would be that the standard driver can't produce translations into local languages. There is no language setting in the driver itself. The only place where it could potentially take the language setting from is the client OS but I don't think it does that. It is probably good that it does not take them from the client OS as any change there might lead to changes in the applications.

Perhaps there are some localized drivers available for download from NCR? I seem to recall that there used to be a Japanese one, for example, but I am not quite sure about this.

Alternative solutions:

1. reference table with all French data in it;

2. CASE construct in the SQL statement.

These alternatives completely eliminate the need to use the ODBC function.

Regards,

Victor


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference