Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Dynamic Decimal validation
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19254
Location: Inside the Matrix

PostPosted: Wed Mar 27, 2013 1:05 am    Post subject:
Reply with quote

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
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2247
Location: NY,USA

PostPosted: Wed Mar 27, 2013 1:59 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19254
Location: Inside the Matrix

PostPosted: Wed Mar 27, 2013 2:07 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Convert Numeric to Packed decimal and... anand1204 DFSORT/ICETOOL 5 Thu Aug 08, 2019 3:53 am
No new posts Alphanumeric to Packed Decimal Conver... Vijay_Sirisha COBOL Programming 2 Mon May 27, 2019 2:52 am
No new posts Compare fields with decimal chandan.inst SYNCSORT 6 Thu Apr 04, 2019 5:29 pm
No new posts Build Dynamic Sort output and limit '... balaji81_k DFSORT/ICETOOL 3 Sat Feb 02, 2019 4:40 am
No new posts Comparing Signed Packed decimal and p... Virendra Shambharkar SYNCSORT 2 Wed Nov 14, 2018 9:37 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us