%NoUppercase meta-SQL element

Syntax

%NoUppercase

Description

When processing a SQL statement, the system automatically casts all field names and possibly record names to uppercase when processing a SQL statement. When processing records from a third party, fields that are lowercase are cast into uppercase, which can create a runtime issue on case-sensitive platforms.

To prevent this, use the %NoUppercase meta-SQL statement at the beginning of the SQL statement.

Parameters

None.

Note there are not parameters, as well as no parenthesis, for this meta-SQL.

Returns

None.

Example

%NoUppercase  
INSERT INTO PS_RM_APP_ENG_LOG (MAP_ID  
, RECNAME  
, FIELDNAME  
, MESSAGE_SET_NBR  
, MESSAGE_NBR  
, LANGUAGE_CD)  
SELECT %Bind(MAP_ID)  
, %Bind(RECNAME)  
, ' '  
,17834  
, 1116  
, %Bind(LANGUAGE_CD)  
FROM %SelectDummyTable  
WHERE EXISTS (  
SELECT 'X'  
FROM SW_OPPORTUNITY SW_OPPORTUNITY  
, SW_PERSON SW_PERSON  
, SW_CUSTOMER SW_CUSTOMER  
, SW_SALES_TEAM_VW SW_SALES_TEAM_VW  
WHERE SW_OPPORTUNITY.SWCUSTOMERID = SW_CUSTOMER.SWCUSTOMERID  
AND SW_OPPORTUNITY.SWSALESTEAMID = SW_SALES_TEAM_VW.SWPROVIDERGRPID  
AND SW_SALES_TEAM_VW.SWPERSONID = SW_PERSON.SWPERSONID  
GROUP BY SW_OPPORTUNITY.SwOpportunityId  
HAVING COUNT(*) > 1)