By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Select column user via clp without getting token user

P: n/a
Hi,
select user from table
will return the token user
what can I do to get the information from the column user

Thanks
Klemens

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Ian
Klemens wrote:
Hi,
select user from table
will return the token user
what can I do to get the information from the column user

select a.user from table as a

Nov 12 '05 #2

P: n/a
Ian wrote:
Klemens wrote:
Hi,
select user from table
will return the token user
what can I do to get the information from the column user


select a.user from table as a

... or select "USER" from table

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

P: n/a
I was sure that I had tried this, but now it works.

Thanks
Klemens

"Serge Rielau" <sr*****@ca.ibm.com> schrieb im Newsbeitrag
news:3j************@individual.net...
Ian wrote:
Klemens wrote:
Hi,
select user from table
will return the token user
what can I do to get the information from the column user


select a.user from table as a

.. or select "USER" from table

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #4

P: n/a
Klemens wrote:
I was sure that I had tried this, but now it works.


Did you include the double-quotes exactly as Serge set them?

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #5

P: n/a
Now I see, it was the command window where it didn't work
But using the qualified columnname will work.

Thanks
Klemens
"Klemens" <me@privacy.net> schrieb im Newsbeitrag
news:3j************@individual.net...
I was sure that I had tried this, but now it works.

Thanks
Klemens

"Serge Rielau" <sr*****@ca.ibm.com> schrieb im Newsbeitrag
news:3j************@individual.net...
Ian wrote:
Klemens wrote:

> Hi,
> select user from table
> will return the token user
> what can I do to get the information from the column user

select a.user from table as a

.. or select "USER" from table

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.