StackOverflow is a collaborative programming Q&A community venture
Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.
db2 empty string equality comparison
I want to do equal comparison between empty strings('' = '')
Under query not work.I think ''='' does not work.
Like comment, changing query using decode function seems great but I don't want to.
DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
I have a new DB2 server (v10.5.0.3), and I can connect to the database locally just fine.
When trying to connect from a remote server using JDBC I am getting the "Connection refused. ERRORCODE=-4499, SQLSTATE=08001" error. Based on information found here https://www-304.ibm.com/support/docview.wss?uid=swg21403644 I have confirmed that
with these JDBC connection values
I have verified that the firewall on the both servers have opened ports 50000 and 50001. I've run out of ideas, any help is greatly appreciated.
Select values from db2 table for null value and run even though it has value
I have a table student, in which marks can have null value, and it should update table if it has null values, otherwise it should skip the record
for above code, I try running the file with values, then it is getting abended, can you help me with it?
IBM's DB2 Participation in Open-Source Software
I wanted to know if someone could provide me with some info on IBM's DB2 participation in Open-source software. I have to write a research paper on DB2 for a class of mine, however, I can't seem to find any info on DB2's participation in open source software. Please get back to me as soon as possible, thanks for your time.
Pipelines in BASH causing lost connections with db2
I have two parts of codes, both have just little differences, the 1st part run as expected, but the 2nd did not.
It seems that pipelines caused losing DB connections.
Can anyone explain why.
Thanks in advance!
BTW: I tested in RH Linux 6.6, bash
Syntax error on DB2 XMLELEMENT
I get this error when trying out this command in the BIRT Classic Models sample database in Data Studio
I do not know how to correct it.
How to execute DB2 sql script that contains a CURSOR WITH RETURN FOR statement
Below is the sample PL/SQL block that i want to execute in a sql script.
I am receiving the below error when i try to execute through script.
42601(-109)[IBM][CLI Driver][DB2/AIX64] SQL0109N The "TO CALLER" clause is not allowed.
DB2: How do I display all dates in a range
I want to expand a range using DB2(on iSeries) query. For example, I have the following value in a table
I want the output as
I tried but I am not able to develop the query. It should be somewhere in similar lines as below.
Table (MYTABLE) has two columns. Below is snapshot
On this query
I am getting the error "Column list not valid for table".
I tried this as well
This is throwing error "Keyword not allowed in recursive common table expression TEMP1."
DB2: How do I remove AUTO_INCREMENT?
How do I remove AUTO_INCREMENT of a column in DB2?
but no luck. What is the correct SQL statement?
Getting Exception java.net.ConnectException while trying for DB2 SSL connection on RHEL
I am trying to establish a DB2 SSL connection on a Linux machine. I tried all the steps mentioned in the manual.
But when I am trying to connect to it through my client machine it is throwing an exception:
For a normal connection it is working fine but for an SSL connection it is giving me this error.
Firewall is also disabled, but still getting this error.
I think it is a port issue. How to resolve this?