×
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.
In embedded SQL, what you actually do is create an array of one or several
16-bit (or two-byte) integers, *DIM*med the same as the number of columns
that could return NULL values.
DCL-S indNulls INT(5) DIM(NULL_COLS_COUNT) INZ;
If you are using a CURSOR, you would do this:
FETCH CURSOR_NAME INTO :yourDS :indNulls FROM YOUR_TABLE WHERE....
If your SQLCODE is not an error, then you would test every element of
indNulls like:
IF indNulls(1) > -1;
// this column returned a non-NULL value
ELSE;
// this column did return a NULL value
ENDIF;
and then you would take actions for the NULL values instances.
JS.
message: 4
date: Tue, 4 Aug 2020 12:43:05 -0400
from: Raul Alberto Jager Weiler <raul.jager@xxxxxxxxx>
subject: Null capable sub field
How can I declare a sub field that is null capable in a DCL_DS?
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
