|
Send RPG400-L mailing list submissions to
rpg400-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
rpg400-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
rpg400-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of RPG400-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. Returning a result set from an RPG stored procedure (David Gibbs)
2. Re: Returning a result set from an RPG stored procedure
(dmosley@xxxxxxxxxx)
3. AW: Returning a result set from an RPG stored procedure
(Birgitta Hauser)
4. Re: Dates in Excel (sjones@xxxxxxxxxxxxxxx)
----------------------------------------------------------------------
message: 1
date: Sun, 08 Jan 2012 14:16:16 -0600
from: David Gibbs <david@xxxxxxxxxxxx>
subject: Returning a result set from an RPG stored procedure
Folks:
Can someone clarify something for me ...
As I understand it, in order to return a result set from a stored
procedure written in RPG, you have to return a multi-occurrence data
structure OR another result set.
In the case of a result set, is it possible to return a result set from a
query on a file in QTEMP?
Thanks!
david
--
IBM i on Power -- For when you can't afford to be out of business.
------------------------------
message: 2
date: Sun, 8 Jan 2012 16:20:06 -0500
from: dmosley@xxxxxxxxxx
subject: Re: Returning a result set from an RPG stored procedure
Yes, you can use QTEMP files. We use them all the time, as well as
multi-occur DS..
David L. Mosley, Jr.
Technical Solutions Architect | 919.379.3730
Dancik International | www.dancik.com
www.facebook.com/dancikinternational
David Gibbs <david@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/08/2012 03:16 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc
Subject
Returning a result set from an RPG stored procedure
Folks:
Can someone clarify something for me ...
As I understand it, in order to return a result set from a stored
procedure written in RPG, you have to return a multi-occurrence data
structure OR another result set.
In the case of a result set, is it possible to return a result set from a
query on a file in QTEMP?
Thanks!
david
--
IBM i on Power -- For when you can't afford to be out of business.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
------------------------------
message: 3
date: Mon, 9 Jan 2012 06:59:02 +0100
from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: AW: Returning a result set from an RPG stored procedure
Sure, you simply have to declare a cursor and open it (and do not close it
before ending the program).
Mit freundlichen Gr??en / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Urspr?ngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
Im
Auftrag von David Gibbs
Gesendet: Sunday, 08. January 2012 21:16
An: RPG programming on the IBM i / System i
Betreff: Returning a result set from an RPG stored procedure
Folks:
Can someone clarify something for me ...
As I understand it, in order to return a result set from a stored procedure
written in RPG, you have to return a multi-occurrence data structure OR
another result set.
In the case of a result set, is it possible to return a result set from a
query on a file in QTEMP?
Thanks!
david
--
IBM i on Power -- For when you can't afford to be out of business.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
------------------------------
message: 4
date: Mon, 9 Jan 2012 09:09:20 -0500
from: sjones@xxxxxxxxxxxxxxx
subject: Re: Dates in Excel
What I ended up doing is:
NumDate s like(jdouble)
NewDate s d
NumDate = HSSFCell_getNumericCellValue(cell);
NewDate = ss_xls2date(NumDate);
The HSSFCell_getNumericCellValue(cell); & ss_xls2date(NumDate); are from
Scott Klements HSSF routines.
Thanks for everyone's help
Steve Jones
From: "Peter Clifford, ariadne software"
<peter.clifford@xxxxxxxxxxxxxxxxxxxxx>
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>,
Date: 01/06/2012 10:03 PM
Subject: Re: Dates in Excel
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Dates in Excel spreadsheets are held in numeric cells (floats or RK
numbers) as a day count since (and including) 1st Jan 1900, but with the
added quirk that Excel thinks 19800 was a leap year!
They are shown on screen as human-readable dates by applying a format
string to them.
Hope this helps.
Pete
On 6 January 2012 14:35, <sjones@xxxxxxxxxxxxxxx> wrote:
I am trying to read a date from an excel spreadsheet using HSSF. Ifound
Scott Klements Parsing An Excel Spreadsheet, Part 2: Handling Dates butin
the page is no longer valid.
Can someone post how to handle dates? The date in the spread sheet is
mm/dd/yy format.list
Thanks
Steve Jones
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
To post a message email: RPG400-L@xxxxxxxxxxxx--
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
------------------------------
--
This is the RPG programming on the IBM i / System i (RPG400-L) digest list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
End of RPG400-L Digest, Vol 11, Issue 14
****************************************
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
