| DataGate® 16.0 for SQL Server Reference Guide
|
Join Considerations
The following table details important considerations for joins when converting or communicating between DataGate® for IBM i, DataGate® for SQL Server, and the core DataGate® program.
|
Item |
DG/400 |
DSS |
DataGate |
|
Supports Use Default for Joins by: |
DDS Keyword JOINDFLT When a record is not found in the secondary file, logical fields whose base is that file will be populated with the default values specified in the physical file definition. |
Creating a Left Outer Join instead of an Inner Join. From SQL Docs: LEFT JOIN or LEFT OUTER JOIN The result set of a left outer join includes all the rows from the left table specified in the LEFT OUTER clause, not just the ones in which the joined columns match. When a row in the left table has no matching rows in the right table, the associated result set row contains null values for all select list columns coming from the right table. |
Yes |
|
Supports 'Join Duplicates By' |
DDS Keyword JDUP |
Not supported. Duplicate rows in the 'secondary' tables may be returned in random order. |
Yes |