SQL question
Danny De Koster asked how to upshift a field with an UPDATE using upshift(field). Serge Rielau first read it as a bit shift, and Carsten Haese explained upshift as an I4GL function. Serge then pointed to the IDS 10 SQL documentation; Ian Michael Gumby remarked that UPPER and LOWER are standard. No definitive command was posted in the thread.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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. Danny
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
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
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/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls1038.htm ? Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab
>From: Serge Rielau <srielau@ca.ibm.com> > >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/infocenter/idshelp/v10/topic/com.ibm.sqls.doc/sqls1038.htm >? > >Cheers >Serge This is kind of weird since upper/lower are pretty standard not only for databases but also some of the scripting languages too. I mean, you get some old data from the mainframe which is all caps. So you lower() the data and then upshift the starting character. I mean Ian looks much nicer than IAN. -G _________________________________________________________________ http://liveearth.msn.com