IBM DB2 Set Chema and Create Schema

on



Set Schema default

$ db2 "SET SCHEMA APPCORE"

or if you have special char between schema

$ db2 "SET SCHEMA \"DELL-MACOSX\""


Create New Schema

$ db2 "CREATE SCHEMA APPCORE AUTHORIZATION appcore"


Source :

https://www.javatpoint.com/db2-schemas

Comments

Post a Comment