GitHub

db2-on-azure /tests /SQL

SELECT id, str1, SUBSTRING(str1,12,1) concat '-' concat str1 as str2 from t10k UNION ALL SELECT 10000 + id, str1, SUBSTRING(str1,13,1) concat '-' concat str1 as str2 from t10k UNION ALL SELECT 20000 + ...
GitHub

ph36071_readme.md

This PTF for APAR PH36071 adds a new Db2 subsystem parameter in DSN6SPRM called SUBSTR_COMPATIBILITY that specifies whether the Db2 SUBSTR built-in function always ...
The Earth Institute Columbia University

SQL Reference

The SUBSTR function returns a substring of a string. If string is a character string, the result of the function is a character string represented in the code page of its first argument. If it is a ...
The Earth Institute Columbia University

Call Level Interface Guide and Reference

The following example extracts the "Interests" section from the Resume CLOB column of the EMP_RESUME table. Only the substring is transferred to the application. /* From CLI sample lookres.c */ /* ...