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
 
Date in IMS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Fri Apr 30, 2010 3:32 pm    Post subject: Date in IMS
Reply with quote

HI All,
In my shop, we are using IMS databases but almost all
databases date fields are in the format YMMDD why this so
and how to diffrentiate this date I.E if it is 91212 year is 2009,1999,1989..
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Fri Apr 30, 2010 3:52 pm    Post subject: Reply to: Date in IMS
Reply with quote

since we do not belong to Your organization we cannot tell!
ask Your peers or get hold of the application documentation
Back to top
View user's profile Send private message
Nanda Krishna

New User


Joined: 30 Nov 2005
Posts: 19
Location: Bangalore

PostPosted: Fri Apr 30, 2010 4:10 pm    Post subject: Reply to: Date in IMS
Reply with quote

Looking strange ... i suggest you to cross check once, if the date format is YMMDD (or) YYDDD (YY - Year, DDD- Day of the year).
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Apr 30, 2010 4:33 pm    Post subject:
Reply with quote

That is something specific to your shop, it might be a standard at your shop to use Julian date (as Enrico has said), such as in this new shop I'm at, they use a Julian date of the form CCYYDDD, e.g. 2009111.

Actually, IMS has no data types - so dates etc will probably be in character format (with many invalid dates - at least we have in our IMS databases). On the other hand, probably because, as IMS is in use since around 1966, probably no one has thought about Y2K at that time and an obvious choice must have been Julian dates (for a four-digit year) instead of gregorian so that you can right away know what day of year you are at...just a thought. However, the dates you show have only 2-digits year - most probably there had been some work around in programs dealing with these dates.

Quote:
how to diffrentiate this date I.E if it is 91212 year is 2009,1999,1989..

A segment may be defined with a size of some bytes(say 40) but only define one field that as a key field that you can use to find the segment when performing queries. IMS will retrieve and save all 40 bytes as directed by a program but may not understand (or care) what the other bytes represent. In practice, often all data in a segment may map to a COBOL copybook and that where yo understand what date it is.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Apr 30, 2010 4:35 pm    Post subject:
Reply with quote

Your date is NOT specific to IMS - your date is specific to your organization as per Enrico.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Validate the Date girishb2 DFSORT/ICETOOL 9 Tue Sep 19, 2017 1:12 am
No new posts Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm

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