Hello, I wanted to ask something related to the Java AS400 connection driver, that is, JTOpen, and it is about whether it has a URL parameter similar to that of PostgreSQL:

jdbc:postgresql://localhost:5432/db?reWriteBatchedInserts=true

That allows doing SQL inserts like these:

INSERT INTO table (name, value) values ​​("name1", "value1"), ("name2", "value2"), ("name3", "value3")

instead of doing them like this:
INSERT INTO table (name, value) values ​​("name1", "value1")
INSERT INTO table (name, value) values ​​("name2", "value2")
INSERT INTO table (name, value) values ​​("name3", "value3")

Could someone guide me if it is possible or where I could ask to find out about it?

------------------------------
Roy Martin
------------------------------

Hi @Roy Martin ...

It's pretty standard ... here's a snippet from some code I wrote last week:

Class.forName("com.ibm.as400.access.AS400JDBCDriver");
    String db2URL = "jdbc:as400:localhost";

db2_conn = DriverManager.getConnection(db2URL, db2_user, db2_password);

I'm not sure in detail all the various options. There's documentation here.

------------------------------
Jack Woehr
Senior Consultant
Seiden Group LLC
Beulah CO
3038478442
------------------------------

Original Message:
Sent: Wed October 23, 2024 05:03 PM
From: Roy Martin
Subject: JTOpen configuration

Hello, I wanted to ask something related to the Java AS400 connection driver, that is, JTOpen, and it is about whether it has a URL parameter similar to that of PostgreSQL:

jdbc:postgresql://localhost:5432/db?reWriteBatchedInserts=true

That allows doing SQL inserts like these:

INSERT INTO table (name, value) values ​​("name1", "value1"), ("name2", "value2"), ("name3", "value3")

instead of doing them like this:
INSERT INTO table (name, value) values ​​("name1", "value1")
INSERT INTO table (name, value) values ​​("name2", "value2")
INSERT INTO table (name, value) values ​​("name3", "value3")

Could someone guide me if it is possible or where I could ask to find out about it?

------------------------------
Roy Martin
------------------------------