Using Java Types and Methods in SQL

BEGIN

DECLARE to_be_searched java.lang.String;

DECLARE search_for java.lang.String;

DECLARE last_index INTEGER;

SET to_be_searched

= NEW java.lang.String ( '56785678' );

SET search_for

= NEW java.lang.String ( '5678' );

SET last_index

= to_be_searched.lastIndexOf

( search_for );

MESSAGE 'test: last_index = ', last_index;

END

Previous slide

Next slide

Back to first slide

View graphic version

The lastIndexOf() method is part of the JDK (Java Development Kit) that comes with ASA. Unlike ASA's own CHARINDEX() function, lastIndexOf() finds the position of the last occurrence of a search string inside another string. This example shows how lastIndexOf() can be called directly from a Watcom SQL script run via DBISQL. It displays "test: last_index = 4" on the ASA server console. Note that Java starts counting at 0 when it comes to character positions in strings.