DB2/400 SQL : Does the "USE" statement exist under DB2/400?

Question

On MySQL or SQL Server database, the USE statement allows me to work in the right schema.

Is there on DB2/400 SQL the equivalent command?

I do not want to work with the command CHGCURLIB because our schema names often exceed 10 characters.

thanks for your advices

Answer 1

SET CURRENT SCHEMA = 'xxxxxxxx'

see V7R3 documentation about unqualified names