Allow more than 1 level of qualified datastructures in SQLRPGLE

The following RFE has been closed as a duplicate of this RFE:
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=151158

IBM will use this request as input to planning but no commitment is made or implied. This request will be updated in the future if IBM implements it.

IBM has received the requirement and is evaluating it. IBM will provide a response after evaluation is complete.

I hope this will also include the ability to fully qualify complex data-structures in an SQL predicate.
Example:
Select column from table_name where column1 = :ds_name.sub_ds.sub_ds.sub_field

Another example is in the use of a service program with multiple procedures where the procedures share prototypes of templated complex data-structures.
The SQL pre-compiler will not be able to distinguish the sub-data-structures if they cannot be fully qualified because of the naming scheme used across the procedures.
Example:
dcl-ds data_key_template template;
key1 char(10);
key2 char(10);
key3 char(10);
end-ds;

dcl-ds Get_Data qualified;
data_key likeds(data_key_template);
p_date date;
p_user char(10);
end-ds;

dcl-ds Update_Data qualified;
Get_Data likeds(Get_Data);
new_value char(10);
end-ds;

dcl-proc Get_Data;
dcl-pi *n char(2);
INPUT likeds(Get_Data) const;
end-pi;

EXEC SQL
SELECT P_DATE, P_USER
INTO :INPUT.p_date, :INPUT.p_user
FROM LIB.TABLE
WHERE KEY1 = :INPUT.data_key.key1
AND KEY2 = :INPUT.data_key.key2
AND KEY3 = :INPUT.data_key.key3;

return '00';
end-proc;

dcl-proc Update_Data;
dcl-pi *n char(2);
INPUT likeds(Update_Data) const;
end-pi;

EXEC SQL
update LIB.TABLE
set P_USER = :INPUT.new_value
WHERE KEY1 = :INPUT.Get_Data.data_key.key1
AND KEY2 = :INPUT.Get_Data.data_key.key2
AND KEY3 = :INPUT.Get_Data.data_key.key3;

return '00';
end-proc;

The CAAC has reviewed this requirement and recommends that IBM view this as a high priority requirement that is important to be addressed. Knowledge Center has info about RPG qualified data structures in the LIKEDS keyword -- see
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzasd/rpgrelv7r4post.htm. Due to this extended support, we believe that SQLRPGLE should support this as well.

Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual RFEs on the broader IBM i community, and has therefore reviewed your RFE.

For more information about CAAC, see www.common.org/caac

For more details about CAAC's role with RFEs, see http://www.ibmsystemsmag.com/Blogs/i-Can/May-2017/COMMON-Americas-Advisory-Council-%28CAAC%29-and-RFEs/

Nancy Uthke-Schmucki - CAAC Program Manager

Due to processing by IBM, this request was reassigned to have the following updated attributes:
Brand - Servers and Systems Software
Product family - Power Systems
Product - IBM i
Component - Db2 for i
Operating system - IBM i
Source - Client

For recording keeping, the previous attributes were:
Brand - Servers and Systems Software
Product family - Power Systems
Product - IBM i
Component - Application Development
Operating system - IBM i
Source - Client