python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - db2-400

Upgrade of JTOpen throws an error (No suitable driver)

We are using Java applications with JDBC/JTOpen to AS400/IBM i DB2. Currently using JTOpen v.10.5 which works fine. Trying to upgrade to latest v.10.7 but it fails with: java.sql.SQLException: No suit...
test-img

4integration

java

jdbc

ibm-midrange

db2-400

jtopen

Votes: 0

Answers: 1

Latest Answer

Even though we are using Java 17, I tested with the one in java8/jt400.jar and that works fine. The main jar in root works if you add Class.forName... Jar file Contents -------- ----...
test-img

4integration

Assigning points based on data from sql query

Is there a way within sql (db2) to assign points based on values of columns, i.e. for every 5 sales you get one point and for every 100 dollars you get one point? My query: SELECT SALES, DOLLARS, EMPL...
test-img

Geoff_S

sql

db2-400

Votes: 0

Answers: 1

Latest Answer

Seems like simple arithmetic (assuming the dollars = 5 for employee 456 is a typo and it should be 500) SELECT EMPLOYEE, SALES, DOLLARS , (sales/5) + floor(dollars/100) as points FROM EMP_SALE...
test-img

Charles

SQL/DB2 getting single row of results per employee with a UNION

I'm currently using a UNION on 2 select statements and while I'm getting the correct data, it's not exactly what I actually need when it comes time to use it in a front-end view I'm currently using th...
test-img

Geoff_S

sql

db2-400

Votes: 0

Answers: 2

Latest Answer

Try adding an outer query: select employee, MAX(case when type=Orders then data end) as orders , MAX(case when type=Sales then data end) as Sales from ( SELECT T.employee as e...
test-img

Ergest Basha

I need help defining a case statement in SQL db2-400

I am using SQL, IBM Data Studio, db2-400. I need help writing a case statement that looks for the length of a field and returns a blank if it is not equal to 14, I have tried many ways without success...
test-img

Dan B.

sql

ibm-midrange

db2-400

Votes: 0

Answers: 2

Latest Answer

Main issue is that you are missing a ) CASE WHEN LENGTH(TRIM(FFIUPCN)) <> 14 THEN '' ELSE FFIUPCN END AS "UPC (if applicable)" but you shouldn't be comparing a n...
test-img

Charles

Posts

Questions

Blogs

Jobs