Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Quick Reference: Common DB2 Command Line Processor (CLP) Commands

Paul Yip (ypaul@ca.ibm.com), DB2 Consultant, IBM Toronto Software Lab
Author photo
Paul Yip is a consultant from the IBM Toronto Lab. He specializes in assisting business partners port their database applications from competitor's platforms to DB2. He has authored over a dozen technical articles and has co-authored three books.

Summary:  A crisis hits, you need to issue commands, and the syntax escapes your mind. This handy deskside reference, although not complete, can help you remember most of the commonly used commands, especially if you are new to DB2.

Date:  11 Jul 2005 (Published 31 Oct 2002)
Level:  Introductory

Activity:  10911 views
Comments:  

A crisis hits, you need to issue commands, and the syntax escapes your mind. This handy deskside reference, although not complete, can help you remember most of the commonly used commands, especially if you are new to DB2.


Download

DescriptionNameSizeDownload method
Article in PDF formatclpquickref.pdf25 KBFTP|HTTP

Information about download methods          Get Adobe® Reader®


Biography

Author photo

Paul Yip is a consultant from the IBM Toronto Lab. He specializes in assisting business partners port their database applications from competitor's platforms to DB2. He has authored over a dozen technical articles and has co-authored three books.

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=161666
SummaryTitle=Quick Reference: Common DB2 Command Line Processor (CLP) Commands
publish-date=07112005
author1-email=ypaul@ca.ibm.com
author1-email-cc=

My developerWorks community

IBM SmartCloud trial. No charge.

IBM PureSystems on a kaleideoscope background

Unleash the power of hybrid cloud computing today!


Special offers