|
View previous topic :: View next topic
|
| Author |
Message |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
I would say yes, there could be harm . . . But not merely for performance reasons. To do what i believe you would try to implement, you would have some rather strange code in many places to accomodate various requirements.
Almost everywhere i've supported has a common date valadition routine and a common numeric validation routine (as well as many other "common routines". These are called from whatever application code needs the functionality. The code is not scattered all over the system.
| Quote: |
| We can use cast,decimal,char,replace fuctions over sysdummy1 and formats the data |
There is simply no reason to code these via sql for a non-SQL need. |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| Quote: |
I would say yes, there could be harm . . . But not merely for performance reasons. To do what i believe you would try to implement, you would have some rather strange code in many places to accomodate various requirements.
Almost everywhere i've supported has a common date valadition routine and a common numeric validation routine (as well as many other "common routines". These are called from whatever application code needs the functionality. The code is not scattered all over the system. |
Perfectly said, but currently I am new to this shop and I don't see they follow this type routines but earlier shop had.
| Quote: |
| There is simply no reason to code these via sql for a non-SQL need. |
Indeed, but if it is going to be a COBOL-DB2 program then I think this is better than COBOL fuctions. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
It sounds like what you think is more important to you than the comments from multiple proven experts - as yet you are a promising beginner.
If you are determined to just do what you want (even if it is the poorer choice), you will, so this topic should soon be closed. . .
| Quote: |
| and I don't see they follow this type routines but earlier shop had. |
No good reason that this cannot be started. |
|
| Back to top |
|
|
|
|
