Stack Overflow
Stack Overflow

Questions tagged [db2-connect]

db2-connect is an independent product used as a database client driver to connect IBM host database servers like zOS and i-Series servers.

db2-connect is an independent product used as a database client driver to connect IBM database servers like zOS, i-Series and Informix. db2-connect package comes with these client drivers: ODBC driver, CLI Driver, JCC Driver, .NET Driver, Python, PHP, Perl and Ruby Driver. It comes with CLPPlus command line tool too.

66 questions
0
votes
0 answers

IBM DB2 retrieve resultset from Compound SQL

I am new to DB2, so please excuse if this seems too novice to you. I am trying to read the output of the following code in a Crystal Report I get 'No Data to Retrieve' error when I try to map it to the report. Is there a 'RETURN' dataset command I…
Abey
  • 155
  • 1
  • 2
  • 9
0
votes
1 answer

How to increase allocated table size for particular table using db2 command

How to increase allocated table size for particular table using DB2 command.Or is there a alternative way to increase memory for all table by 5mb at once.
Al Jam
  • 35
  • 1
  • 3
  • 11
0
votes
1 answer

Correct statement for UNION ALL with three or more selects

I have the following situation: I have a script consisting of 6 selects joined by "UNION ALL". From the CLP DB2 console, this script fails. Curiously, each query independently work, and even come to work if grouped in pairs. However, when I try with…
agg
  • 1
  • 1
0
votes
1 answer

Changing Collation order with IBM.Data.DB2-driver to DB2 for IBM i

We have hundreds of web apps that need to support localization. Our back end is a combination of Asp.net Web API with legacy DB2 for IBM i. To connect from C# to DB2 we use IBM Data Server Client 10.5 FP5 package -> managed .Net drivers. With native…
Kappas Vaan
  • 15
  • 4
0
votes
2 answers

Unable to connect DB2 Zos with bluemix using cloud integaration

We used cloud integration to connect to mainframe DB2 in bluemix, downloaded the secure connector in a Linux OS and configured it with DB2 jars. The status in the BlueMix got changed to "connected" ,but we were unable to proceed further to create an…
user3346242
  • 11
  • 2
0
votes
1 answer

IBM DB2 error in event viewer logs after IIS default Application pool recycle after 1740 minutes

I am getting a strange issue in one of my production servers which uses client IBM.data.DB2 version to get data from DB2 database.This applications is designed in C# and deployed on IIS-7. All the transaction's work fine until the app pool…
User
  • 1
  • 1
0
votes
0 answers

WAMP 2.4 PHP 5.4 - Fatal error for db2_connect()

Can't seem to find a fix for this. Have: - WAMP 2.4 - PHP 5.4.12 - php_ibm_db2.dll extension on in the php.ini file and the file in the ext folder. I get Fatal error: Call to undefined function db2_connect() in I see this in the apache_erro.log…
newbie_146
  • 127
  • 1
  • 9
0
votes
2 answers

how to get db2 without any appended values

select rtrim(char(PKG_AGR_IDR)),rtrim(char(STA_DTE)) from test FETCH FIRST 10 ROW ONLY "0010000010. 2014-03-14" "0010000010. 2014-03-14" I need data as below: 0010000010 2014-03-14 I am planning to write a script to do rtrim(char(fieldname)) is…
user3754136
  • 509
  • 11
  • 25
0
votes
2 answers

How to rebuild index in DB2 9.7 LUW

How I can rebuild index in DB2 9.7 LUW. Is there any rebuild utility for index or I have to recreate index. Regards, Masheed
Masheed
  • 35
  • 3
  • 13
0
votes
3 answers

Querying using the datepart from a time stamp in a pass-through Proc SQL

I am trying to use the date part of a time-stamp in my where query in a db2 pass-through proc SQL code below. I tried using date and datepart functions but it wont work with this format. Does anyone know the name of the function to use in the same…
Keneni
  • 705
  • 5
  • 12
0
votes
0 answers

Passing XML datatype as input from Java to DB2 stored Procedure

I'm completely newbie to Stored Procedure. Got a requirement like the Input type to be passed is of XML datatype to DB2 stored procedure and output as ResultSet. //Stored Procedure: CREATE PROCEDURE GetGrpInfo (IN inpdoc XML) DYNAMIC RESULT SETS…
user2737399
  • 81
  • 1
  • 4
  • 13
0
votes
1 answer

how to connect Worklight 6.1 to DB2?

I am developing a hybrid application which needs database connectivity to store and retrieve data.I am using IBM db2 database and worklight 6.1. I need the javascript code to connect to db2 so that I can enter information directly to the database…
user3305763
  • 59
  • 10
0
votes
1 answer

problem with the connectivity/updation using db2(universal driver)

I choosed a web project in order to do that i am using an IDE (Eclipse), database (DB2 universal driver) and Apache Tomcat server. So, by gods grace every thing has gone well but when I try to update data to DB2 database through JDBC code then I am…
rams
  • 1
0
votes
0 answers

connect odbc to iseries from LAMP php

I am having issues connecting from a LAMP over to an DB2 iseries. Any thoughts on this code? I cannot get it to connect. How can I confirm that the iseries driver works, is installed, etc. Or is my code wrong? Thanks in advance... $db_name …
Greg Burris
  • 123
  • 3
  • 10
0
votes
1 answer

warning message in console while calling DB2 function on zOS using jdbcTemplate

My java app deployed in jboss AS 7, queries a MS SQL server database using spring data. I also need to call a DB2 function on zOS for which I use Spring JdbcTemplate. The SQL is: public String getUniqueId() { String sql = "SELECT " + schemaName…
SGB
  • 2,118
  • 6
  • 28
  • 35
1 2 3
4
5