SQL question
This is a discussion on SQL question within the Informix forums, part of the Database Server Software category; --> Hi all, I want to upshift a certain field in my table. update table-name set field-name = upshift(field-name) how ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 04:03 PM
| |||
| |||
 Re: SQL question Danny De Koster wrote: > I want to upshift a certain field in my table. > update table-name set field-name = upshift(field-name) > how can I do this? You mean a "shift-left-1-bit"? SET c1 = c1 * 2 This ranks as one of the more esoteric SQL requests I have seen... Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab      |
|
04-20-2008, 04:03 PM
| |||
| |||
| Re: SQL question On Wed, 2007-07-18 at 08:21 -0400, Serge Rielau wrote: > Danny De Koster wrote: > > I want to upshift a certain field in my table. > > update table-name set field-name = upshift(field-name) > > how can I do this? > You mean a "shift-left-1-bit"? > SET c1 = c1 * 2 > > This ranks as one of the more esoteric SQL requests I have seen... Are you being facetious or are you actually unaware of the meaning of upshift in I4GL? -- Carsten Haese http://informixdb.sourceforge.net |
|
04-20-2008, 04:03 PM
| |||
| |||
| Re: SQL question Carsten Haese wrote: > On Wed, 2007-07-18 at 08:21 -0400, Serge Rielau wrote: >> Danny De Koster wrote: >>> I want to upshift a certain field in my table. >>> update table-name set field-name = upshift(field-name) >>> how can I do this? >> You mean a "shift-left-1-bit"? >> SET c1 = c1 * 2 >> >> This ranks as one of the more esoteric SQL requests I have seen... > > Are you being facetious or are you actually unaware of the meaning of > upshift in I4GL? Can I use a life-line? Anyway now I learned a new word as well as some I4GL trivia. I can sleep through the rest of the day. So the OP is after: http://publib.boulder.ibm.com/infoce...c/sqls1038.htm ? Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab |
|
04-20-2008, 04:04 PM
| ||||
| ||||
| Re: SQL question On Jul 18, 5:14 am, "Danny De Koster" <d...@fidelity-soft.be> wrote: > Hi all, > > I want to upshift a certain field in my table. > > update table-name set field-name = upshift(field-name) > > how can I do this? > Thanks any answers. Serge-bashing aside, you can but the SQL function is UPPER(). See the Guide to SQL Syntax manual. Art S. Kagel |
Linear Mode
