× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Maybe this helps:
SELECT CAST
(REPLACE ( CHAR(DATE(CURRENT_DATE)), '-', '' )
AS DECIMAL(8,0)) AS CURYYYYMMDD
FROM SYSIBM/SYSDUMMY1

You should be able to run the statement above from STRSQL,
so this shows how to convert CURRENT_DATE to an 8 digit decimal.

Your output should be something like:

....+....1..
CURYYYYMMDD
20,130,520


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports
Sent: Monday, May 20, 2013 4:35 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: MIDRANGE-L Digest, Vol 12, Issue 1085

Booth, its decimal 8




________________________________
From: "midrange-l-request@xxxxxxxxxxxx" <midrange-l-request@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Monday, May 20, 2013 6:28 PM
Subject: MIDRANGE-L Digest, Vol 12, Issue 1085


Send MIDRANGE-L mailing list submissions to
    midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
    midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
    midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

  1. Re: MIDRANGE-L Digest, Vol 12, Issue 1084 (Crystal Reports)
  2. Re: include current date in logical file (Booth Martin)
  3. RE: MIDRANGE-L Digest, Vol 12, Issue 1084 (Gary Thompson)


----------------------------------------------------------------------

message: 1
date: Mon, 20 May 2013 15:22:46 -0700 (PDT)
from: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
subject: Re: MIDRANGE-L Digest, Vol 12, Issue 1084

How do you refer to current date in DDS logical file?




________________________________
From: "midrange-l-request@xxxxxxxxxxxx" <midrange-l-request@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Monday, May 20, 2013 6:12 PM
Subject: MIDRANGE-L Digest, Vol 12, Issue 1084


Send MIDRANGE-L mailing list submissions to
??? midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
??? http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
??? midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
??? midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

?  1. RE: massive document storage in the IFS - how to handle Mimix
? ? ? (Dan Kimmel)
?  2. Re: include current date in logical file (Booth Martin)
?  3. Re: include current date in logical file (Raul A. Jager W.)
?  4. RE: include current date in logical file (Paul Therrien)
?  5. RE: include current date in logical file (Raymond B. Dunn)
?  6. Erros compiling a logical file (Crystal Reports)
?  7. RE: massive document storage in the IFS - how to handle Mimix
? ? ? (Dan Kimmel)
?  8. RE: include current date in logical file (Gary Thompson)


----------------------------------------------------------------------

message: 1
date: Mon, 20 May 2013 17:01:06 -0500
from: Dan Kimmel <dkimmel@xxxxxxxxxxxxxxx>
subject: RE: massive document storage in the IFS - how to handle Mimix

Sorry. There's a link about halfway down the page to another page that talks about unix-like file systems not having those properties.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzamv/rzamvifsrootfiles.htm

I see what you see in wrklnk, but I think those properties are inherited from the udfs definition or from the mounted-over link. Did you try changing them?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S Waterbury
Sent: Monday, May 20, 2013 4:40 PM
To: Midrange Systems Technical Discussion
Subject: Re: massive document storage in the IFS - how to handle Mimix

Hi, Dan:

Where did you get the idea that QOpenSys and UDSFS "doesn't have *OBJMGT, *OBJEXIST, *OBJALTER and *OBJREF"? =-O

I just looked at the link you provided, and I don't see anything there that says THAT! :-\

Also, just issue WRKLNK '/*' and issue a "9" against any files or directories, and you can plainly see the "Exist Mgt Alter and Ref"
columns displayed, with an "X" under them,. for those users with that authority.? (You might need to do this from a profile with *ALLOBJ or you might not be authorized to see that.)

Just sayin'? ...

Mark

On 5/20/2013 5:12 PM, Dan Kimmel wrote:
Has anyone tried a user defined subsystem to manage the problem Joe
had with ownership? UDFS, like QOpenSys, doesn't have *OBJMGT,
*OBJEXIST, *OBJALTER, and *OBJREF, while root does. Here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzamv/rzam
vplanifssec.htm

I wonder if this difference also keeps the object ownership from being added to the user profile. If so, it might also make UDFS a good place to keep millions and millions of little document files.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.





------------------------------

message: 2
date: Mon, 20 May 2013 17:00:24 -0500
from: Booth Martin <booth@xxxxxxxxxxxx>
subject: Re: include current date in logical file

What sort of a field is OHORDT?? Is it a 6 or 8 digit, alpha or numeric
field or a true date field?

On 5/20/2013 4:47 PM, Crystal Reports wrote:
I want to create a logical file which would only
include dates current

this does not compile:

I? ? OHORDT? ? COMP(EQ UDATE)



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.