SQL LEFT OUTER JOIN – Null handling: Indicator Variables
I am using SQL Left Outer Join in an SQLRPGLEI Declare Cursor statement. I need indicator variables of SMALLINT type to handle my null returns in FETCH statements. How and where do these have to be defined? There are no SMALLINT fields in the tables I am joining. Thank you in advance for your consideration.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 16, 2005 12:35 PM
UPDATED:
May 16, 2005 5:42 PM
RELATED QUESTIONS
- SQL Left Join unmatched null handling.
- SQL Update Set: Higlight Customers without Invoices, Update and join Tables?
- Need help with max function within a left outer join
- MySql Select multiple columnsfrom distinct rows based on one column
- Alter proc to fetch a table structure from SQL Server 2005 database
Answer Wiki:
I have this working now. Needed to define the indicator variables in RPG thus:| D ISET# ~ S ~ 3I 0 Inz |
and then pair them with the potential nulls in the FETCH statement: FETCH INTO :SET#:ISET#, etc. Values of the indicator variables are -1 when the fetched value is null.
Thanks again to Ludith for putting me on track.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
