|
View previous topic :: View next topic
|
| Author |
Message |
Manshadi
New User
.jpg)
Joined: 31 Aug 2005
Posts: 82
|
|
|
|
Hi,
Is there any way to use Editproc for changing data during query from table?
Regards
Manshadi |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| What do the manuals say, try the very first link here. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Manshadi,
What is that you are really looking for ?
Editproc's are used for Compression/De-compression or Encryption/Decryption stuff like that....
Sushanth |
|
| Back to top |
|
|
Manshadi
New User
Joined: 31 Aug 2005
Posts: 82
|
|
|
|
Sushanth,
I am looking for changing some characters when users use query on table.
For example in our table we have & in our data. I want to change & to - when user use select to fetch the data.
Regards
Manshadi |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Manshadi,
Here You Go!!!!
In DB2 V9 manual, see Chapter Functions(scalar functions), the function translate() wants to say hi! especially to you.
Sushanth |
|
| Back to top |
|
|
|
|
