What is it - Alias, view, table or something else?

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
User avatar
Atif Alam
Registered Member
Posts: 10
Joined: Fri Jan 17, 2014 2:05 pm

What is it - Alias, view, table or something else?

Post by Atif Alam »

Hi,

In the following SQL

Code: Select all

SELECT A.bonus, emp_name from (SELECT DISTINCT BONUS FROM EMP) A 
where some condition
In above what will the "A" be? Should it be a VIEW, ALIAS or something else.
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: What is it - Alias, view, table or something else?

Post by zprogrammer »

A ==> Is a correlation name
zprogrammer
User avatar
Atif Alam
Registered Member
Posts: 10
Joined: Fri Jan 17, 2014 2:05 pm

Re: What is it - Alias, view, table or something else?

Post by Atif Alam »

Is not it a symbolic name? I was searching for the documentation to din it but in vain.

I'll search again and if could find a document will let you know, in case if you have it with you..please share.
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: What is it - Alias, view, table or something else?

Post by zprogrammer »

zprogrammer
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”