Okay Focal Pointers; I can not for the life of me figure out why my casing is not working. Here I only have the LAST_NAME code. Thought I would take out the first name and vnum until I got the last name working. Trying to get the input UPPER CASE to compare to UPPER CASE define field. Please help!!! Thank you in advance.
-SET &ALEN=ARGLEN(&LAST_NAME.LENGTH, &LAST_NAME, 'I2');
-SET &LNSRCH=UPCASE(&ALEN, &LAST_NAME, 'A&ALEN');
JOIN
PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.PIDM IN PEOPLE_FACULTY_DIM TO MULTIPLE
FACULTY_ASSIGNMENT_FACT.FACULTY_ASSIGNMENT_FACT.PIDM IN FACULTY_ASSIGNMENT_FACT
TAG J15 AS J15
END
JOIN
J15.FACULTY_ASSIGNMENT_FACT.COURSE_HISTORY_KEY IN PEOPLE_FACULTY_DIM
TO MULTIPLE COURSE_HISTORY_DIM.COURSE_HISTORY_DIM.COURSE_HISTORY_KEY
IN COURSE_HISTORY_DIM TAG J16 AS J16
END
JOIN
J16.COURSE_HISTORY_DIM.COURSE_HISTORY_KEY IN PEOPLE_FACULTY_DIM TO MULTIPLE
STUDENT_REGISTRATION_FACT.STUDENT_REGISTRATION_FACT.COURSE_HISTORY_KEY
IN STUDENT_REGISTRATION_FACT TAG J17 AS J17
END
JOIN
J17.STUDENT_REGISTRATION_FACT.PIDM IN PEOPLE_FACULTY_DIM TO MULTIPLE
PEOPLE_DIM.PEOPLE_DIM.PIDM IN PEOPLE_DIM TAG J18 AS J18
END
DEFINE FILE PEOPLE_FACULTY_DIM
currentDate/HYYMDS=HGETC(10, currentDate);
PhoneOUT/A15V=
IF PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.PHONE EQ 'NA'
OR PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.PHONE EQ ''
THEN 'na'
ELSE PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.PHONE;
altPhoneOUT/A15V=
IF PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ALTERNATE_PHONE EQ 'NA'
OR PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ALTERNATE_PHONE EQ ''
THEN 'na'
ELSE PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ALTERNATE_PHONE;
VMOUT/A15V=
IF PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VOICEMAIL_PH EQ 'NA'
OR PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VOICEMAIL_PH EQ ''
THEN 'na'
ELSE PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VOICEMAIL_PH;
VMEXTOUT/A10V=
IF PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VOICEMAIL_EXT EQ 'NA'
OR PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VOICEMAIL_EXT EQ ''
THEN 'na'
ELSE PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VOICEMAIL_EXT;
RoomOUT/A15V=
IF PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ROOM EQ 'NA'
OR PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ROOM EQ ''
THEN 'na'
ELSE PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ROOM;
UC_LN/A30=UPCASE(30, J18.PEOPLE_DIM.LAST_NAME, UC_LN);
END
TABLE FILE PEOPLE_FACULTY_DIM
BY 'J16.COURSE_HISTORY_DIM.COURSE_TITLE' AS 'Course Title'
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.FULL_NAME' AS 'Instructor Name'
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.PhoneOUT' AS 'Phone'
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.altPhoneOUT' AS 'Alt Phone'
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VMOUT' AS 'Voicemail '
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.VMEXTOUT' AS 'Voicemail,Extention'
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.RoomOUT' AS 'Room'
BY 'PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.EMAIL' AS 'Email'
WHERE PEOPLE_FACULTY_DIM.PEOPLE_FACULTY_DIM.ACTIVE_FLAG EQ 1;
WHERE J16.COURSE_HISTORY_DIM.ACTIVE_FLAG EQ 1;
WHERE J17.STUDENT_REGISTRATION_FACT.ACTIVE_FLAG EQ 1;
WHERE (( currentDate GE J16.COURSE_HISTORY_DIM.COURSE_BEGIN_DATE ) AND ( currentDate LE J16.COURSE_HISTORY_DIM.COURSE_END_DATE ));
WHERE ((J18.PEOPLE_DIM.VNUM EQ '&VNUM') OR ((J18.PEOPLE_DIM.UC_LN EQ '&LNSRCH') AND (J18.PEOPLE_DIM.FIRST_NAME EQ '&FIRST_NAME'))) ;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
This message has been edited. Last edited by: Kerry,
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
March 10, 2011, 05:53 PM
Waz
Do you get the same problem from one of the sample files ?
e.g.
-SET &UCNAME = UPCASE(&name.LENGTH,&name,'A&name.LENGTH') ;
TABLE FILE CAR
PRINT COUNTRY
WHERE COUNTRY EQ '&UCNAME'
END
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 11, 2011, 09:01 AM
MAdams1
Waz,
The car file example works. So what am I doing wrong?
Thank you
Michelle
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
March 11, 2011, 09:09 AM
MAdams1
SOLVED----Sort of.
I'm not sure why the UPCASE or LOCASE wouldn't work, but my data is in lowercase word format so I just did LCWORD for the input field and it works. If you happen to see what I was doing wrong, I would love to know. Thanks for helping.
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
WebFOCUS Server 8.1.05 Windows 2008 Server WebFOCUS AppStudio 8.1.05 Windows 7 Professional IE 11 and Chrome Version 43.0.2357.124 m. Mostly HTML, PDF, Excel, and AHTML
March 14, 2011, 04:20 PM
<JG>
Turn on the client side tracing and see exactly what is being passed to the SQL server.
If the test is not being passed to the SQL server then you need to add a cast to the where clause so that it is correctly processed by WebFOCUS