Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Comparison of signed numeric with alphanumeric

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
sunilmvs

New User


Joined: 29 Oct 2006
Posts: 1

PostPosted: Sun Oct 29, 2006 2:57 am    Post subject: Comparison of signed numeric with alphanumeric
Reply with quote

I had a very unusal scenario. We had a date comparison logic in our program in which we compared the current date with the date in the db2 table. In the comparison we copied the current date in the signed numeric field and the table date in alphanumeric field. The logic was if the current date > table date then a flag has to be set.

In the testing it worked fine , but when we moved the code to the production it failed can you explain the reason for this.
Back to top
View user's profile Send private message

UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 757
Location: Germany

PostPosted: Mon Oct 30, 2006 1:42 pm    Post subject: Re: Comparison of signed numeric with alphanumeric
Reply with quote

Hi !

The reason could depend on different aate formats between test and
produktion environment or simply that your testing dates fits the comarison and in produktion not.

For a correct date comparison coded yourself, the both dates must have format JJJJMMTT. So transform bothe dates to that format and then code you IF-Comparison.

Regards, Umeysan
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts Validate if a Value from the file is ... balacsv2 COBOL Programming 8 Mon Jun 19, 2017 11:52 pm

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