MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 4 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: SQL Challenge - II
mummanen

Replies: 8
Views: 14252

PostForum: Mainframe Challenge   Posted: Wed Aug 24, 2005 12:09 pm   Subject: SQL Challenge - II
I didn't realize that you are talking about only DB2 SQL's.
  Topic: SQL Challenge - II
mummanen

Replies: 8
Views: 14252

PostForum: Mainframe Challenge   Posted: Tue Aug 23, 2005 4:09 pm   Subject: SQL Challenge - II
The below SQL will work for differance between two dates:

select round(months_between(to_date('2005-01-03', 'YYYY-MM-DD'),to_date('2004-05-01', 'YYYY-MM-DD')))
from dual;
  Topic: How to convert numeric number to roman number?
mummanen

Replies: 4
Views: 3642

PostForum: Application Programming   Posted: Mon Feb 02, 2004 4:29 pm   Subject: How to convert numeric number to roman number?
Did anybody have some example code for converting numeric number to roman number?

I did through the SQL query embedded into my cobol program

select to_char(11,'RN') from dual;
  Topic: How to convert numeric number to roman number?
mummanen

Replies: 4
Views: 3642

PostForum: Application Programming   Posted: Mon Feb 02, 2004 2:55 pm   Subject: How to convert numeric number to roman number?
How to convert numeric number to roman number in MF COBOL?

Do we have any function for this?

EX: 1 = I, 2 = II, 3 = III ... 10 = X etc...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group