python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - db2-400

Java 8 Time API - DB2/400 / JT400

I'm currently upgrading an application that uses DB2/400 database, and I'm migrating to the new java time api (LocalDate, LocalTime, ...), using the latest version of jt400.jar. However, when executin...
test-img

areal

jdbc

ibm-midrange

java-time

db2-400

jt400

Votes: 0

Answers: 1

Latest Answer

You must use java.sql.date with JDBC. Convert with : java.sql.Date.valueOf(LocalDate.now());
test-img

Dam

Create a nested JSON with SQL in Db2

I have actually a JSON extracted from a table select json_object ('ITEM_ID' value Trim(PRDC), 'ITEM_DESC' value TRIM(DESC), ) JSONData fro...
test-img

Nifriz

sql

arrays

json

db2-400

Votes: 0

Answers: 1

Latest Answer

So you want an JSON object that includes an array of JSON objects.. Have you looked at the examples in the documentation? This one in particular select json_object( 'department number' value ...
test-img

Charles

Update multiple columns based off another table in DB2 V5R4M0

I am working on an update statement for an AS400 DB/2 table. It needs to have multiple rows updated using data from another table with matching fields. Our version of the driver displays is: 05.04.000...
test-img

eaglei22

sql

sql-update

common-table-expression

db2-400

sql-merge

Votes: 0

Answers: 1

Latest Answer

you'll need something like so update TBL1 t1 set STS = (select sts from TBL1CPY cp where cp.prj = t1.prj AND cp.PN = t1.PN AND cp.IN = t1.IN ) where LDT = '20220104' A...
test-img

Charles

Posts

Questions

Blogs

Jobs