|
needs).
Hi, Alan,
That's what I was thinking when I defined a table (with DDS) where the
fields were all null capable (ALWNULL). In the program(s) which load
the data structure and then insert that data structure into the data
queue, the null 'status' of each field is not 'propagated' to the
program which reads the data queue and uses the same externally
defined data structure to subdefine the data queue entry.
I like your method of qualified data structures to define and name the
null indicator array for the file's fields. I've been using includes
to define all the null indicator fields and the required array (which SQL
I'll try your technique in my next application where it's needed.null.
In any case, since I'm using the data queue, I'll have to figure out
some way to add a user defined array to the end of the queue entry to
convey programmatic null indicator equivalent values.
Thanks
Tom
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Thursday, September 06, 2012 2:39 PM
To: Midrange Systems Technical Discussion
Subject: Re: data queues and null indicators
You are correct. Nulls are only supported in RPG in external described
tables. You must define a array of indicators to hold true or false to
--
i use qualified data structures to do this. See my document at
www.think400.dk/downloads.htm on RPG and Nulls.
On Thu, Sep 6, 2012 at 1:08 PM, Thomas Garvey <tgarvey@xxxxxxxxxx> wrote:
I've been using data queues to funnel data into several programs. I--
am using the typical method (I suppose) of using data structures to
define the data values in the data queue entries. This particular
data structure is externally defined.
Now I have need to be able to determine if individual field values
in the data queue entry are null. That is, the data placed there by
the originating program(s) is properly setting the field's null
value using the %nullind function.
The externally defined data structure has the fields defined as null
capable, but I'm thinking that passing the null settings for each
field is beyond the capability of data queues, no matter how you
define the data contained in them.
Has anyone else been in this situation? Short of adding an array of
flags to the end of the data structure to contain the null
indicators for each field, anybody got any ideas?
TIA,
Thomas Garvey
--
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.
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.
--
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.
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.