View previous topic :: View next topic
|
Author |
Message |
chan2004
New User
Joined: 28 Mar 2007 Posts: 16 Location: India
|
|
|
|
hi
I have a query like this in a program
update table A
set
(
right(name,1)
where
uuid = :uuid;
the name field declared in copybook is of char(1)
the field is being populated into a variable of char(4) in db2 table
what will the right(name,1) do?
this program is not written by me. so, i want to know why is the developer using this
also, is there any function like this - right() |
|
Back to top |
|
|
chan2004
New User
Joined: 28 Mar 2007 Posts: 16 Location: India
|
|
|
|
one update
just realised that the query is like this
update table A
right(name,1)
values
(name)
where
uuid = :uuid;
will this sql work
what does it do explicitly cause even if we are not using the right() function, it will insert a char(1) variable into char(4). |
|
Back to top |
|
|
Help-Me-Out
New User
Joined: 09 Dec 2006 Posts: 56 Location: Pune
|
|
|
|
Hi,
There is right function. If you type QW RIGHT at ur shop u will get all the details.
[/code] |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
chan2004,
what does you sql look like?
Code: |
update table A
right(name,1)
values
(name)
where
uuid = :uuid
|
even your second post sucks. where is the SET keyword?
top of the page are links to manuals. suggest you get acquainted with them; you are never going to get very far if you can not even copy sql. as a result, you are only going to get guesses.
right is a db2 function. RTFM.
Quote: |
The RIGHT function returns a string consisting of the specified number of rightmost integer characters of string-expression. If string-expression is a character or binary string, a character is a byte. If string-expression is a graphic string, a character is a DBCS character.
|
hy have you not tested this sql in qmf/spufi?
# |
|
Back to top |
|
|
|