DB2 CLI terminology question

Posted on 2011-10-25
Last Modified: 2012-05-12
I read on the following site:

that DB2 is simply SQL without cursors and is not precompiled.

Does that mean that when people refer to CLI they really mean CLP and using the db2 command to execute SQL statements ?

Question by:Los Angeles1
    LVL 45

    Accepted Solution


    Hi Greensburo,

    Yep.  The terms "Command Line Interface" and "Command Line Processor" are often interchanged.  They mean the same thing.

    LVL 37

    Assisted Solution


    The CLI and CLP are two different things
    CLP is the command line processor, an interface that is executed from a command / shell window and lets you interactively send sql statements to db2 and have them executed

    The CLI (call level interface is a DB2 API for the C and C++ programming language)

    LVL 37

    Expert Comment

    and by the way, unless you are running version 8, i would not look at the version 8 documentation

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now