Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] case sensitive search
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] case sensitive search
 Login/Join
 
Guru
posted
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
 
Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6132 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Did you try : putting &ALEN.EVAL

-SET &LNSRCH=UPCASE(&ALEN, &LAST_NAME, 'A&ALEN.EVAL');
 
Posts: 11 | Location: Information Builders France | Registered: May 22, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
I will try that..Thanks


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
 
Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010Reply With QuoteReport This Post
<JG>
posted
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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] case sensitive search

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.