Re: Query/400

If we have to add a field to an old query we don't generally rewrite the
code/technique. Any new excel spreadsheet requests are always just written
directly as a CSV from RPG/SQL or whatever language we are using to extract
the data.

I recently tried to write an XSLX natively but didn't get very far. I'd
have to search out a simple example in Python to help me get started.

On Tue, Nov 16, 2021 at 2:47 PM Rob Berendt <rob@xxxxxxxxx> wrote:

Time, not timestamp.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Larry "DrFranken" Bolhuis
Sent: Tuesday, November 16, 2021 2:43 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>;
John Yeung <gallium.arsenide@xxxxxxxxx>
Subject: Re: Query/400

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


Cool, 86400 rows per day and I sell disk. :-)
Now, anybody need ms?
- DrF

On 11/16/2021 1:30 PM, John Yeung wrote:

On Tue, Nov 16, 2021 at 12:19 PM Rob Berendt <rob@xxxxxxxxx> wrote:

It's still a technique being pushed today for use everywhere and not

just Query/400.

https://db2ibmi.blogspot.com/2021/08/speed-dating-your-legacy-dates.html

Yeah. I pushed it on another thread just a few days ago.

However, OP is asking for times, not dates. You could still use the
same approach, creating a table with one row per second (given that
the field in question is 6 digits).

If this is an issue that comes up a lot, it still would be worth
considering. Doesn't introduce any new technology, and doesn't require
any learning if you've already done multifile queries before.

John Y.

--
IBM Champion for Power Systems

www.iInTheCloud.com - Commercial IBM i and Power System Hosting
www.iDevCloud.com - Personal IBM i Hosting
www.Frankeni.com - IBM i and Power Systems Consulting.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com