MQSeries.net :: View topic - Querying a defined series in the Environment area

sessionsa · Posted: Mon Jun 11, 2007 5:44 am Post subject:

The following is a structure that I am trying to query from. If I use CS_RELATED_INDV_ID = '3300096696' I get the proper result, but if I use the param below, I donâ€™t. I believe it is due to the IndvRelation list. Two of the parameters of the query are in the IndvRelation list of the EDGIndv list.

How would I properly query this list within a list structure?
Do I need to declare a reference and perform looping?
Is the a direct query method I am missing?

Thanks.

Test Code:

DECLARE vTest BOOLEAN;
SET vTest = EXISTS(SELECT A.* FROM Environment.Variables.SourceMessageTree.ProgEDG.EDGIndv[] AS A WHERE A.IndvRelation.CS_RELATED_INDV_ID = '3300096711'AND A.IndvRelation.CS_RELATIONSHIP_CD = 'MO' AND A.IN_HOME_IND = 'Y');

IF vTest = TRUE THEN
SET Environment.Variables.MyCheck = 'Y';
ELSE
SET Environment.Variables.MyCheck = 'N';
END IF;

Data:

Environment =
(
(0x01000000):Variables = (
(0x01000000):SourceMessageTree = (
(0x01000000):ProgEDG = (
(0x03000000):CASE_EDG_GRANTEE = '3300096622'
(0x03000000):PROGRAM_STATUS_CD = '01'
(0x03000000):PROGRAM_TYPE_CD = 'TF'
(0x03000000):TYPE_OF_ASSISTANCE = 'TP01'
(0x01000000):EDGIndv = (
(0x03000000):ELIGIBILITY_STATUS = 'E'
(0x03000000):INDV_ELIGIBILITY_EFF_BEGIN_DT = '20070501'
(0x03000000):INDV_ELIGIBILITY_EFF_END_DT = '0'
(0x03000000):IV_A_INDIVIDUAL_ID = '3300096622'
(0x03000000):DOB = '19670214'
(0x03000000):ETHNICITY = 'NH'
(0x03000000):GENDER_CD = 'F'
(0x03000000):IN_HOME_IND = 'Y'
(0x03000000):IVA_INDIVIDUAL_ID = '3300096622'
(0x03000000):IVA_INDV_FIRST_NAME = 'Granny'
(0x03000000):IVA_INDV_LAST_NAME = 'Hollicheck'
(0x03000000):IVA_INDV_MIDDLE_NAME = ''
(0x03000000):IVA_INDV_SUFFIX_NAME = ''
(0x03000000):RACE_CD = 'WH'
(0x03000000):SSN = '135236412'
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096696'
(0x03000000):CS_RELATIONSHIP_CD = 'MO'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096711'
(0x03000000):CS_RELATIONSHIP_CD = 'GM'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096936'
(0x03000000):CS_RELATIONSHIP_CD = 'GM'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300097361'
(0x03000000):CS_RELATIONSHIP_CD = 'MO'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300097530'
(0x03000000):CS_RELATIONSHIP_CD = 'GM'
)
)
(0x01000000):EDGIndv = (
(0x03000000):ELIGIBILITY_STATUS = 'E'
(0x03000000):INDV_ELIGIBILITY_EFF_BEGIN_DT = '20070501'
(0x03000000):INDV_ELIGIBILITY_EFF_END_DT = '0'
(0x03000000):IV_A_INDIVIDUAL_ID = '3300096696'
(0x03000000):DOB = '19910415'
(0x03000000):ETHNICITY = 'NH'
(0x03000000):GENDER_CD = 'F'
(0x03000000):IN_HOME_IND = 'Y'
(0x03000000):IVA_INDIVIDUAL_ID = '3300096696'
(0x03000000):IVA_INDV_FIRST_NAME = 'Brianna'
(0x03000000):IVA_INDV_LAST_NAME = 'Hollicheck'
(0x03000000):IVA_INDV_MIDDLE_NAME = 'Uma'
(0x03000000):IVA_INDV_SUFFIX_NAME = ''
(0x03000000):RACE_CD = 'WH'
(0x03000000):SSN = '139913185'
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096622'
(0x03000000):CS_RELATIONSHIP_CD = 'DA'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096711'
(0x03000000):CS_RELATIONSHIP_CD = 'MO'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096936'
(0x03000000):CS_RELATIONSHIP_CD = 'AU'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300097361'
(0x03000000):CS_RELATIONSHIP_CD = 'SI'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300097530'
(0x03000000):CS_RELATIONSHIP_CD = 'AU'
)
)
(0x01000000):EDGIndv = (
(0x03000000):ELIGIBILITY_STATUS = 'E'
(0x03000000):INDV_ELIGIBILITY_EFF_BEGIN_DT = '20070501'
(0x03000000):INDV_ELIGIBILITY_EFF_END_DT = '0'
(0x03000000):IV_A_INDIVIDUAL_ID = '3300096711'
(0x03000000):DOB = '20070401'
(0x03000000):ETHNICITY = 'NH'
(0x03000000):GENDER_CD = 'F'
(0x03000000):IN_HOME_IND = 'Y'
(0x03000000):IVA_INDIVIDUAL_ID = '3300096711'
(0x03000000):IVA_INDV_FIRST_NAME = 'Ema'
(0x03000000):IVA_INDV_LAST_NAME = 'Hollicheck'
(0x03000000):IVA_INDV_MIDDLE_NAME = ''
(0x03000000):IVA_INDV_SUFFIX_NAME = ''
(0x03000000):RACE_CD = 'WH'
(0x03000000):SSN = '000000000'
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096622'
(0x03000000):CS_RELATIONSHIP_CD = 'GD'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096696'
(0x03000000):CS_RELATIONSHIP_CD = 'DA'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300096936'
(0x03000000):CS_RELATIONSHIP_CD = 'CO'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300097361'
(0x03000000):CS_RELATIONSHIP_CD = 'NI'
)
(0x01000000):IndvRelation = (
(0x03000000):CS_RELATED_INDV_ID = '3300097530'
(0x03000000):CS_RELATIONSHIP_CD = 'CO'
)
)