Alias Creation

[Nikki]

Hi All,

In our Framework Manager model, we used Account_Address as querysubject and its having STATE queryitem. When i created the reports using this STATE column and generated the SQL and its shows  alias as STATE4.

why it is happened. Is STATE as like any data type like DATE ....
I also seen when we used for DAY,DATE,YEAR as query items.

Its happend both Framwork manager and Report studio queries (Native/IBM cognos SQL).

whether it has cognos default behaviour or what ? Is there any proof document regarding this, Please share with us.

Thanks in advance.
Nikki

[blom0344]

You probably should ignore this, as Cognos may quite often generate temp sets / inline views producing it's own names as aliasses. Question is whether the right data is returned. If so, let it be..

[MFGF]

The other possibility is that these may be reserved words (Day, Date, Year etc) in the SQL dialect, so it is aliasing them to prevent issues?

MF.

[Nikki]

Thanks for your reply !

You are correct  :)
My generated SQL (Native /IBM cognos) has returned data correctly. Concern is only for STATE alias creation. As you said it might be reserved word.

If anyone has different opinion, Please share with me.

Nikki