DB2 CLI terminology question

Posted on 2011-10-25
Medium Priority
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
  • 2
LVL 46

Accepted Solution

Kent Olsen earned 1000 total points
ID: 37024498

Hi Greensburo,

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

LVL 37

Assisted Solution

momi_sabag earned 1000 total points
ID: 37024524

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

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

569 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