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  Rules, Regulations, and FAQs    joinin on field using TRIM FUNCTION
Go
New
Search
Notify
Tools
Reply
  
joinin on field using TRIM FUNCTION
 Login/Join
 
Member
posted
Good afternoon all,

New to webfocs. Trying to take sql code that joins two tables using the TRIM function and convert to FOCUS. It looks like FOCUS does not allow it (FUNCTIONS included in the join clause). Is there another approach? Here is the SQL code:

SELECT BAN_ID, BAN_LAST_NAME, BAN_FIRST_NAME, SHP_FILTER
FROM BAN_SPRIDEN, SHP_USER_MST

WHERE TRIM(BAN_ID) = TRIM(SHP_ACCESS_ID

AND BAN_CHANGE_IND IS NULL
AND SHP_FILTER <> 'STU'
ORDER BY SHP_FILTER;

Thanks,

Douglas Dodd
douglas.dodd@tamuc.edu


8.10.5M
Linux 64-bit
 
Posts: 3 | Location: Webfocus 8.10.5M | Registered: October 03, 2016Reply With QuoteReport This Post
Gold member
posted Hide Post
Do you have an error message?

(or use a closing bracket after SHP_ACCESS_ID ?)


WebFOCUS 7.6, 7.7
Windows, All Output formats
 
Posts: 90 | Location: Stuttgart | Registered: October 20, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Try Something Like this

SET KEEPDEFINES=ON
DEFINE FILE JOBFILE
JCODE/A20 = TRIM('L', JCODE, 20, '$', 1, 'A20');
JOBID/A4 = JCODE|EDIT(JOBCODE,'$99');
END

JOIN FILE JOBFILE AT JOBID WITH JOBCODE TO ALL
FILE EMPFULL AT JOB_ID TAG M1 AS JW1
WHERE JOBCODE LIKE 'A__';
END


WebFOCUS 8.1
Windows, PPT
 
Posts: 19 | Registered: June 26, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Rules, Regulations, and FAQs    joinin on field using TRIM FUNCTION

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