Stack Overflow
Stack Overflow

Questions tagged [clpplus]

CLPPlus is a reporting tool in DB2 LUW

This is a CLPPlus included with DB2 LUW, and its purpose is to provide the same functionality of SQL*Plus

13 questions
1
vote
1 answer

How to get all history of CLPPLUS SQL command?

I am using CLPPlus: Version 1.6 to connect my IBM Db2 on cloud. I have written several sql queries back long ago. And I am willing to refer my queries which I had fired that time. So basically I want the history of my clpplus terminal.
Abneet Wats
  • 13
  • 3
1
vote
2 answers

db2 export data to remote location

I am trying to connect to db2 database (server2) to export data from table to a csv file, for this I am using clpplus from the local server (server1) (which I want to export the csv to), the reason I want the CSV file to be on server1 is that I want…
Elias Ghali
  • 823
  • 1
  • 13
  • 29
0
votes
1 answer

Start DB2 CLPPLUS Tool from linux server

I'm trying to start CLPPLUS from a linux server (I'm using MobaXterm to connect remotly to the Linux server) but it does not work (either the CLPPLUS tool is started nor an error is thrown). I can start DB2 CLP on Server using the following line of…
Elmo N'diaye
  • 29
  • 1
  • 4
0
votes
1 answer

CLPPLUS login failing

I am trying to login to remote DB2 using clpplus but can't login as password contains @. clpplus -nw user/p@sswd@145.xx.xx.212:60000/Dbname but it fails saying: [jcc][t4][10380][11951][4.27.25] Required property "sswd@145.xx.xx.212" is unknown…
curious_nustian
  • 596
  • 2
  • 7
  • 22
0
votes
1 answer

How to access table values in command line processor plus of db2?

I have recently installed db2 in my system and created the sample database which has 47 tables. I tried to retrieve data from the tables using clp plus. used connect db2admin@localhost:50000/sample and gave password. it gave back database connection…
Chaitanya Sykam
  • 1
0
votes
0 answers

Removing Blank lines between data rows in CLPPlus

Hi I have google this many many times but i cannot seem to find the resolution. The resolutions suggested previoulsy do not seem to work for me. I am using CLPPlus to query DB2 and when i create the spool file i get a blank row after each data row.…
Mahad Khan
  • 15
  • 3
0
votes
2 answers

How to export IXF and LOB files from dashdb

I need to copy some tables in one dashdb database over to separate dashdb database. Normally I would export the CSV file from one and load it into the other using the Web console, however one table in particular has a CLOB column and so we will need…
jpwsutton
  • 170
  • 3
  • 8
0
votes
1 answer

CLPPlus and space in table name

I have a new problem with CLPPlus and IMPORT command. I try to import data into a table which contain a space in its name, but it seems to fail: SQL> IMPORT FROM '/home/i1058/outfile' INSERT INTO USER1."TABLE 1"; Invalid Syntax Error SQL> IMPORT…
Steph
  • 47
  • 1
  • 8
0
votes
0 answers

CLPPlus and double quotes

I am currently using the IBM DB2 CLPPlus utility, and I don't know how to put double quotes into a string ? Because if I try to escape them or if I double the doubles quotes it doesn't work: Escaped double quotes : [i1058@lat111 ~]$ cat…
Steph
  • 47
  • 1
  • 8
0
votes
1 answer

Column delimiter with CLPPlus

I am trying to import a file with the DB2 CLPPlus tool like the following : cat outfile 1;"a";"b" 2;"c";"d" clpplus -nw SQL> SET COLSEP ';'; SQL> CONNECT MYUSER/MYPWD@IP:PORT/BLUDB; SQL> IMPORT FROM '/home/i1058/outfile' INSERT INTO…
Steph
  • 47
  • 1
  • 8
0
votes
1 answer

CLPPLUS command stops after execution, so the other commands are not processed

Situation: autoMark.cmd: ... clpplus user/pw@DB2database:50000/db @autoMarkDB2.sql 01.02.2016 02.02.2016 %DBISQL% -c "uid=user;pwd=pw;dsn=SA16database" READ autoMarkSA.sql 742987 742989 ... autoMarkDB2.sql: (IBM DB2 9.7 or something) simple select…
ContraViZe
  • 121
  • 1
  • 1
  • 11
0
votes
0 answers

Is DB2 CLPPLUS editor able to do xquery

I am new to the CLPPlus editor and I'm trying a simple query that works if I execute it from a file like this db2 -td% -svf C:\query.sql and the query.sql file contains: SELECT tx.ID,XMLQUERY('for $e in $d/Client/Address return data($e)' passing…
ChrisNic
  • 11
  • 3
0
votes
1 answer

Increasing Screen width in db2

SET LINES 200 The above statement in oracle increases the screen width from its default size to 200. I want to achieve the same in DB2, ie. its default width is set to 50, how can i increase it? Even if I spool the output to a file, the rows are…
Naveen
  • 1
  • 1