CLPPlus



Command Line Processor Plus (CLPPlus) is a command-line user interface which can be used to connect databases and to define, edit, and run statements, scripts, and commands.

Starting CLPPlus
From command prompt:- To start CLPPLus execute clpplus from command prompt

$ clpplus CLPPlus: Version 1.0 Copyright (c) 2009, IBM CORPORATION. All rights reserved. SQL>

From Menu:- START -> All Programs -> IBM DB2 -> DB2 -> Command Line Tools -> Command Line Processor Plus

CLPPlus Commands
To get the list of commands supported by CLPPlus enter '''? index''' on CLPPlus prompt.

SQL> ? index INDEX --- Type 'HELP [topic]' for command line help. DEL              CHANGE            IMPORT            EXECUTE ACCEPT           EXIT              DESCRIBE          HOST BTITLE           SET               DISCONNECT        SPOOL GET_DB_CFG       GET_DBM_CFG       CURRENT_SCHEMA    CLEAR_BREAKS UNDEFINE         REMARK            UPDATE_DBM_CFG    QUIT START            BREAK             @                 UPDATE_DB_CFG EDIT             TTITLE            SAVE              LIST CLEAR_COMPUTES   SERVEROUTPUT      INDEX             GET COMPUTE          CLEAR             HELP              RESET_DBM_CFG DEFINE           APPEND            CONNECT           RESET_DB_CFG SHOW             PROMPT            COLUMN            CLPPLUS PRINT            JCCLOGMODE        LOAD              PASSWORD LIST_TABLES      LOGMODE           PAUSE             VARIABLE INPUT            EXPORT SQL>

CLPPlus Video

 * CLPPlus Video on ChannelDB2


 * CLPPlus video on YouTube