Following is some code that I am using for various reports purposes. It seems that if a student does not have one of the email types populated, it will pull a value from another student in order to put values in blank spaces. I have been struggling with this report for quite some time trying to get it to work the way I want and output all on 1 row.

Any suggestions?

Thanks!
JOIN
LEFT_OUTER CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN
CSPRDSC_ADM_APPL_DATA TO MULTIPLE
CSPRDSC_SCC_NAMES_QVW.CSPRDSC_SCC_NAMES_QVW.EMPLID IN CSPRDSC_SCC_NAMES_QVW
TAG J4 AS J4
END
JOIN
LEFT_OUTER CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN
CSPRDSC_ADM_APPL_DATA TO MULTIPLE
CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMPLID IN CSPRDSC_SCC_EMAIL_QVW
TAG J5 AS J5
END
DEFINE FILE CSPRDSC_ADM_APPL_DATA ADD
CSCSTU/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'CSCC' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
CSCPER1/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER1' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
CSCPER2/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER2' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
END
TABLE FILE CSPRDSC_ADM_APPL_DATA
SUM
'J4.CSPRDSC_SCC_NAMES_QVW.NAME_TYPE' NOPRINT
'J4.CSPRDSC_SCC_NAMES_QVW.LAST_NAME'
'J4.CSPRDSC_SCC_NAMES_QVW.FIRST_NAME'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ACAD_CAREER'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADMIT_TYPE'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT'
'J3.CSPRDSC_PERSON_ADDRESS.ADDRESS_TYPE'
'J3.CSPRDSC_PERSON_ADDRESS.ADDRESS1'
'J3.CSPRDSC_PERSON_ADDRESS.ADDRESS2'
'J3.CSPRDSC_PERSON_ADDRESS.CITY'
'J3.CSPRDSC_PERSON_ADDRESS.STATE'
'J3.CSPRDSC_PERSON_ADDRESS.POSTAL'
'J5.CSPRDSC_SCC_EMAIL_QVW.CSCSTU'
'J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER1'
'J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER2'
BY 'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID'
ON TABLE SUBHEAD
"Chadron State College - Student Information System"
HEADING
"eaglemail_notify.fex"
"For Creation Date: <+0>&DATEtrMDYY <+0> "
"App Date GE: &ADM_APPL_DT "
"List of new applicants that need EagleMail accounts created"
FOOTING
"Run Date: <+0>&DATEtrMDYY <+0> "
"Page WHERE ( CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.INSTITUTION EQ 'CSC01' );
WHERE CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT GE &ADM_APPL_DT.(OR(FIND ADM_APPL_DT,CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT IN CSPRDSC_ADM_APPL_DATA)).App Date GE.;
WHERE J3.CSPRDSC_PERSON_ADDRESS.ADDRESS_TYPE EQ 'PERM';
WHERE J4.CSPRDSC_SCC_NAMES_QVW.NAME_TYPE EQ 'PRI';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K

This message has been edited. Last edited by: Malinda,

WebFOCUS 7.6.11
Windows
all output (Excel, HTML, PDF)

Have you turned SQL tracing on to ensure there are no errors in the JOIN statements?

I ALWAYS use SQL traces:

-*-- Set up SQL tracing ----------------------------------------------
-*-- Deactivate SQL tracing --------------------------------
SET TRACEOFF = ALL
-*-- Enable Trace for the SQL Translator -------------------
SET TRACEON = SQLTRANS
-*-- Show SQL statements -----------------------------------
SET TRACEON = STMTRACE//CLIENT
-*-- Show Optimization information -------------------------
SET TRACEON = SQLAGGR//CLIENT
-*-- Disable the trace stamp (Date/Time etc) ---------------
SET TRACESTAMP = OFF
-*-- Set trace line wrapping - # of characters -------------
SET TRACEWRAP = 78
-*-- Activate SQL tracing ----------------------------------
SET TRACEUSER = ON
-RUN

-*-- Turn off data retrieval (for testing purposes) --------
SET XRETRIEVAL=OFF
-RUN

Run Faster

I put in the trace code and here is what I get:

FOC2510 - FOCUS-MANAGED JOIN SELECTED FOR FOLLOWING REASON(S):
FOC2551 - PRESENCE OF FST. OR LST. IN MULTI-PATH REQUEST
FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2592 - RDBMS-MANAGED JOIN HAS BEEN DISABLED
SELECT T1."EMPLID",T1."ACAD_CAREER",T1."STDNT_CAR_NBR",
T1."ADM_APPL_NBR",T1."INSTITUTION",T1."ADMIT_TYPE",
T1."ADM_APPL_DT" FROM SYSADM.PS_ADM_APPL_DATA T1 WHERE
(T1."ADM_APPL_DT" >= TO_DATE('22-09-2009','DD-MM-YYYY')) AND
(T1."INSTITUTION" = 'CSC01') ORDER BY T1."EMPLID" DESC ,
T1."ACAD_CAREER" DESC ,T1."STDNT_CAR_NBR" DESC ,
T1."ADM_APPL_NBR" DESC ;
SELECT T2."OPRCLASS",T2."OPRID" FROM SYSADM.PS_ADM_APPL_SCTY
T2 WHERE (T2."ADM_APPL_NBR" = :0001) AND (T2."EMPLID" = :0002)
AND (T2."INSTITUTION" = :0003) AND (T2."ACAD_CAREER" = :0004)
AND (T2."OPRID" = '60552831') AND (T2."OPRCLASS" =
'CS_NBA_CC_PARTIAL_MASK');
SELECT T3."E_ADDR_TYPE",T3."EMAIL_ADDR" FROM
SYSADM.PS_SCC_EMAIL_QVW T3 WHERE (T3."EMPLID" = :0001);
SELECT T4."NAME_TYPE",T4."LAST_NAME",T4."FIRST_NAME" FROM
SYSADM.PS_SCC_NAMES_QVW T4 WHERE (T4."EMPLID" = :0001) AND
(T4."NAME_TYPE" = 'PRI');
SELECT T5."ADDRESS_TYPE",T5."ADDRESS1",T5."ADDRESS2",T5."CITY",
T5."STATE",T5."POSTAL" FROM SYSADM.PS_PERSON_ADDRESS T5 WHERE
(T5."EMPLID" = :0001) AND (T5."ADDRESS_TYPE" = 'PERM');
...RETRIEVAL KILLED
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
ACCESS LIMITED BY PASSWORD


What do these mean?

malinda

I'm not sure what the DEFINE columns are, as they seem to have the same names as columns referenced in the TABLE FILE:

DEFINE FILE CSPRDSC_ADM_APPL_DATA ADD
CSCSTU/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'CSCC' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
CSCPER1/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER1' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
CSCPER2/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER2' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
END

'J5.CSPRDSC_SCC_EMAIL_QVW.CSCSTU'
'J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER1'
'J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER2'

I would start by commenting-out all retrieval of the DEFINE columns.

The reason for that was that from my email table, the email field can have multiple values for each student. And I wanted to get these to output all on 1 row, so I did a define to define each type, then list those in my columns. I tried commenting out those fields in my table file and it still gave me the same errors.

Malinda

OK.

Next try commenting out this:

WHERE CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT GE &ADM_APPL_DT.(OR(FIND ADM_APPL_DT,CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT IN CSPRDSC_ADM_APPL_DATA)).App Date GE.;

There must be something missing after that GE, though I am not familiar with FIND.

Debugging this will have to be a process of elimination. I hope someone else jumps in with a suggestion for a problem I can't see...

I think the error may be caused by the existence of two separate paths with multiple records per EMPLID in each path and WHERE clauses that hit both paths. This query may need to be split into two.

Let me ask this - if you wanted to return student records from an admission app table and from a names, addr, and email table all in 1 row per student how would do go about it? Keep in mind that the email needs to be allowed to list in multiple columns if the student has listed mulitple email addresses. I have tried joining to the email table 3 different types, and then instead of doing a define I just pull the email type and email fields from each of the 3 joins and specify the type in my where statement. It seems to behave similar to this problem.

Malinda

Malinda, something else I don't understand is why none of the tables mentioned in your code appear in the SQL trace. Are all of the JOIN objects views?

Yes (if I understand what you are asking). All the tables that are my cross-reference tables are actually query view tables. My parent table though is not a view.

Malinda

quote:

I think the error may be caused by the existence of two separate paths with multiple records per EMPLID in each path and WHERE clauses that hit both paths. This query may need to be split into two.

Dan,

My names, addr and email tables all multiple entries - or could have. I am using more of a tree structured (join table1 --> table2, table1-->table3, table1-->table4) join. I have tried just pulling the 3 email types putting those in a hold file and then joining to my others but still doesn't give me what I want.

Malinda

Your approach of moving the e-mail address to different columns in the same row should work. However, there are a couple of problems with your code. For example, you have references to tag j3, which doesn't exist in your JOINs. You have tag and table references attached to your DEFINEd fields, when none should be there. You should probably be using the MAX prefix with the DEFINEd columns in your TABLE request to obtain the highest value instead of the last value for each EMPLID. Finally, the whole effort is further complicated by the presence of DB views and/or complex ACX files that we cannot see. The SQL trace you provided shows the worst possible situation where data is being returned to WebFOCUS separately from multiple tables (all rows in some cases) for processing. As Francis suggested, you need to start with a single JOIN and no DEFINEs and slowly add to the query. With each step you need to check the SQL trace to ensure the JOINs and filtering and sorting are performed by the database and not by WebFOCUS. In the end, you may find that you must split your query into two or three optimized queries and then perform the final JOIN(s) and data manipulation in WebFOCUS ... or resort to pass-thru SQL to get a single, optimized query. Sorting this all out will not be an easy task for anyone.

It attacheded the tag names when I created the GUI must be how WebFoucs is built? How would I get rid of these without it affecting anything? How would I use the max prefix with my defines then? I don't think emails are effective dated.

Malinda

I don't use the GUI so I can't help you there. But the GUI should be smart enough to make any necessary changes to the tags when you open and then save a fex, so I wouldn't worry too much about that. Regarding the use of the MAX prefix with your DEFINEs, you should also be able to add that in the GUI. When done correctly, your code would look something like this:

TABLE FILE ...
SUM ...
.
.
MAX.CSCSTU
MAX.CSCPER1
MAX.CSCPER2
.
.
END

I think before with my code I didn't get it all copied, which is why you were not seeing all the joins. I have added the max in and it still seems to fill in with incorrect information. Here is the code again.

JOIN
LEFT_OUTER CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN
CSPRDSC_ADM_APPL_DATA TO MULTIPLE
CSPRDSC_PERSON_ADDRESS.CSPRDSC_PERSON_ADDRESS.EMPLID IN CSPRDSC_PERSON_ADDRESS
TAG J3 AS J3
END
JOIN
LEFT_OUTER CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN
CSPRDSC_ADM_APPL_DATA TO MULTIPLE
CSPRDSC_SCC_NAMES_QVW.CSPRDSC_SCC_NAMES_QVW.EMPLID IN CSPRDSC_SCC_NAMES_QVW
TAG J4 AS J4
END
JOIN
LEFT_OUTER CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN
CSPRDSC_ADM_APPL_DATA TO MULTIPLE
CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMPLID IN CSPRDSC_SCC_EMAIL_QVW
TAG J5 AS J5
END
DEFINE FILE CSPRDSC_ADM_APPL_DATA ADD
CSCSTU/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'CSCC' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
CSCPER1/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER1' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
CSCPER2/A70=IF J5.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER2' THEN J5.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR;
END
TABLE FILE CSPRDSC_ADM_APPL_DATA
SUM
'J4.CSPRDSC_SCC_NAMES_QVW.NAME_TYPE' NOPRINT
'J4.CSPRDSC_SCC_NAMES_QVW.LAST_NAME'
'J4.CSPRDSC_SCC_NAMES_QVW.FIRST_NAME'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ACAD_CAREER'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADMIT_TYPE'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT'
'J3.CSPRDSC_PERSON_ADDRESS.ADDRESS_TYPE'
'J3.CSPRDSC_PERSON_ADDRESS.ADDRESS1'
'J3.CSPRDSC_PERSON_ADDRESS.ADDRESS2'
'J3.CSPRDSC_PERSON_ADDRESS.CITY'
'J3.CSPRDSC_PERSON_ADDRESS.STATE'
'J3.CSPRDSC_PERSON_ADDRESS.POSTAL'
'MAX.J5.CSPRDSC_SCC_EMAIL_QVW.CSCSTU'
AS 'MAX,J5.CSPRDSC_SCC_EMAIL_QVW.CSCSTU'
'MAX.J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER1'
AS 'MAX,J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER1'
'MAX.J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER2'
AS 'MAX,J5.CSPRDSC_SCC_EMAIL_QVW.CSCPER2'
BY 'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID'
ON TABLE SUBHEAD
"Chadron State College - Student Information System"
HEADING
"eaglemail_notify.fex"
"For Creation Date: <+0>&DATEtrMDYY <+0> "
"App Date GE: &ADM_APPL_DT "
"List of new applicants that need EagleMail accounts created"
FOOTING
"Run Date: <+0>&DATEtrMDYY <+0> "
"Page WHERE ( CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.INSTITUTION EQ 'CSC01' );
WHERE CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT GE &ADM_APPL_DT.(OR(FIND ADM_APPL_DT,CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT IN CSPRDSC_ADM_APPL_DATA)).App Date GE.;
WHERE J3.CSPRDSC_PERSON_ADDRESS.ADDRESS_TYPE EQ 'PERM';
WHERE J4.CSPRDSC_SCC_NAMES_QVW.NAME_TYPE EQ 'PRI';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K

WebFOCUS 7.6.11
Windows
all output (Excel, HTML, PDF)

I might have gotten it to work - in my defines, with the last code I posted I added an ESLE ' ' to each one. It did not fill incorrectly and did list all the email addresses. I am going to test the efficiency of ot with the code Francis provided earlier.

Thanks again for all the help and answering my stupid questions!

Malinda

Here is the trace code that is generated which is the same as before so I guess it really didn't "fix" much yet. What exactly do these error messages mean?

FOC2510 - FOCUS-MANAGED JOIN SELECTED FOR FOLLOWING REASON(S):
FOC2551 - PRESENCE OF FST. OR LST. IN MULTI-PATH REQUEST
FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2592 - RDBMS-MANAGED JOIN HAS BEEN DISABLED
SELECT T1."EMPLID",T1."ACAD_CAREER",T1."STDNT_CAR_NBR",
T1."ADM_APPL_NBR",T1."INSTITUTION",T1."ADMIT_TYPE",
T1."ADM_APPL_DT" FROM SYSADM.PS_ADM_APPL_DATA T1 WHERE
(T1."ADM_APPL_DT" >= TO_DATE('20-04-2010','DD-MM-YYYY')) AND
(T1."INSTITUTION" = 'CSC01') ORDER BY T1."EMPLID" DESC ,
T1."ACAD_CAREER" DESC ,T1."STDNT_CAR_NBR" DESC ,
T1."ADM_APPL_NBR" DESC ;
SELECT T2."OPRCLASS",T2."OPRID" FROM SYSADM.PS_ADM_APPL_SCTY
T2 WHERE (T2."ADM_APPL_NBR" = :0001) AND (T2."EMPLID" = :0002)
AND (T2."INSTITUTION" = :0003) AND (T2."ACAD_CAREER" = :0004)
AND (T2."OPRID" = '60552831') AND (T2."OPRCLASS" =
'CS_NBA_CC_PARTIAL_MASK');
SELECT T3."E_ADDR_TYPE",T3."EMAIL_ADDR" FROM
SYSADM.PS_SCC_EMAIL_QVW T3 WHERE (T3."EMPLID" = :0001);
SELECT T4."NAME_TYPE",T4."LAST_NAME",T4."FIRST_NAME" FROM
SYSADM.PS_SCC_NAMES_QVW T4 WHERE (T4."EMPLID" = :0001) AND
(T4."NAME_TYPE" = 'PRI');
SELECT T5."ADDRESS_TYPE",T5."ADDRESS1",T5."ADDRESS2",T5."CITY",
T5."STATE",T5."POSTAL" FROM SYSADM.PS_PERSON_ADDRESS T5 WHERE
(T5."EMPLID" = :0001) AND (T5."ADDRESS_TYPE" = 'PERM');
...RETRIEVAL KILLED
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
ACCESS LIMITED BY PASSWORD

This message has been edited. Last edited by: Malinda,

As another option, I reworked the code. Following is my new code and my new trace messages.

DEFINE FILE CSPRDSC_SCC_EMAIL_QVW
CSCSTU/A70=IF CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'CSCC' THEN CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR ELSE ' ';
CSCPER1/A70=IF CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER1' THEN CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR ELSE ' ';
CSCPER2/A70=IF CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.E_ADDR_TYPE EQ 'PER2' THEN CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMAIL_ADDR ELSE ' ';
END
TABLE FILE CSPRDSC_SCC_EMAIL_QVW
PRINT
'CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.CSCSTU'
'CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.CSCPER1'
'CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.CSCPER2'
BY 'CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMPLID'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS EMHOLD2 FORMAT FOCUS INDEX 'CSPRDSC_SCC_EMAIL_QVW.CSPRDSC_SCC_EMAIL_QVW.EMPLID'
END
JOIN
CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN CSPRDSC_ADM_APPL_DATA
TO MULTIPLE CSPRDSC_SCC_NAMES_QVW.CSPRDSC_SCC_NAMES_QVW.EMPLID
IN CSPRDSC_SCC_NAMES_QVW TAG J0 AS J0
END
JOIN
CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN CSPRDSC_ADM_APPL_DATA
TO MULTIPLE CSPRDSC_PERSON_ADDRESS.CSPRDSC_PERSON_ADDRESS.EMPLID
IN CSPRDSC_PERSON_ADDRESS TAG J1 AS J1
END
JOIN
CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID IN CSPRDSC_ADM_APPL_DATA
TO MULTIPLE EMHOLD2.SEG01.EMPLID IN EMHOLD2 TAG J2 AS J2
END
TABLE FILE CSPRDSC_ADM_APPL_DATA
SUM
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ACAD_CAREER'
'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADMIT_TYPE'
'J0.CSPRDSC_SCC_NAMES_QVW.NAME_TYPE' NOPRINT
'J0.CSPRDSC_SCC_NAMES_QVW.LAST_NAME'
'J0.CSPRDSC_SCC_NAMES_QVW.FIRST_NAME'
'J1.CSPRDSC_PERSON_ADDRESS.ADDRESS_TYPE' NOPRINT
'J1.CSPRDSC_PERSON_ADDRESS.ADDRESS1'
'J1.CSPRDSC_PERSON_ADDRESS.CITY'
'J1.CSPRDSC_PERSON_ADDRESS.STATE'
'J1.CSPRDSC_PERSON_ADDRESS.POSTAL'
'MAX.J2.SEG01.CSCSTU' AS 'MAX,J2.SEG01.CSCSTU'
'MAX.J2.SEG01.CSCPER1' AS 'MAX,J2.SEG01.CSCPER1'
'MAX.J2.SEG01.CSCPER2' AS 'MAX,J2.SEG01.CSCPER2'
BY 'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.EMPLID'
BY 'CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.ADM_APPL_DT'
HEADING
""
FOOTING
""
WHERE CSPRDSC_ADM_APPL_DATA.CSPRDSC_ADM_APPL_DATA.INSTITUTION EQ 'CSC01';
WHERE J0.CSPRDSC_SCC_NAMES_QVW.NAME_TYPE EQ 'PRI';
WHERE J1.CSPRDSC_PERSON_ADDRESS.ADDRESS_TYPE EQ 'PERM';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML

FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2594 - AGGREGATION IS NOT APPLICABLE TO THE VERB USED
SELECT T1."EMPLID",T1."E_ADDR_TYPE",T1."EMAIL_ADDR" FROM
SYSADM.PS_SCC_EMAIL_QVW T1 ORDER BY T1."EMPLID";
...RETRIEVAL KILLED
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
FOC2510 - FOCUS-MANAGED JOIN SELECTED FOR FOLLOWING REASON(S):
FOC2551 - PRESENCE OF FST. OR LST. IN MULTI-PATH REQUEST
FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2592 - RDBMS-MANAGED JOIN HAS BEEN DISABLED
SELECT T1."EMPLID",T1."ACAD_CAREER",T1."STDNT_CAR_NBR",
T1."ADM_APPL_NBR",T1."INSTITUTION",T1."ADMIT_TYPE",
T1."ADM_APPL_DT" FROM SYSADM.PS_ADM_APPL_DATA T1 WHERE
(T1."INSTITUTION" = 'CSC01') ORDER BY T1."EMPLID" DESC ,
T1."ACAD_CAREER" DESC ,T1."STDNT_CAR_NBR" DESC ,
T1."ADM_APPL_NBR" DESC ;
SELECT T2."OPRCLASS",T2."OPRID" FROM SYSADM.PS_ADM_APPL_SCTY
T2 WHERE (T2."ADM_APPL_NBR" = :0001) AND (T2."EMPLID" = :0002)
AND (T2."INSTITUTION" = :0003) AND (T2."ACAD_CAREER" = :0004)
AND (T2."OPRID" = '60552831') AND (T2."OPRCLASS" =
'CS_NBA_CC_PARTIAL_MASK');
SELECT T4."ADDRESS_TYPE",T4."ADDRESS1",T4."CITY",T4."STATE",
T4."POSTAL" FROM SYSADM.PS_PERSON_ADDRESS T4 WHERE (T4."EMPLID"
= :0001) AND (T4."ADDRESS_TYPE" = 'PERM');
SELECT T5."NAME_TYPE",T5."LAST_NAME",T5."FIRST_NAME" FROM
SYSADM.PS_SCC_NAMES_QVW T5 WHERE (T5."EMPLID" = :0001) AND
(T5."NAME_TYPE" = 'PRI');
...RETRIEVAL KILLED
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
ACCESS LIMITED BY PASSWORD