Top "Db2-400" questions

DB2-400 is IBM's name for the database integrated into the OS/400 operating system for it's AS/400 line of midrange computers.

GETDATE() method for DB2

I have been trying for a while now to get a similar method to GETDATE() in DB2 for i. So …

sql sql-server tsql ibm-midrange db2-400
How can we View the DB2 Procedure and How can we execute the DB2 Procedure and just see the output of the procedure using DB2

How can we View the DB2 Procedure (I mean what logic they have written ) and How can we execute the …

db2 db2-400
How do I programmatically run a complex query on an as400?

I'm new at working on an as400 and I have a query the joins across 4 tables. The query itself is …

sql ibm-midrange db2-400
How to add a not null constraint in an existing column in DB2 iSeries?

I have tried the following scripts to add a not null constraint to my column. ALTER TABLE MYDB.RULES ALTER …

sql db2 db2-400 iseries-navigator
Add a column to a DB2/400 table with a specific ordinal position

Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a …

sql db2 ibm-midrange db2-400
HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999)

HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999) java.sql.SQLNonTransientConnectionException: Communication link failure. (Read timed …

spring-boot hikaricp db2-400
DB2 400 drop column

I want to drop a column called id which is an auto incrementing PK. The SQL: alter table "CO88GT"."…

db2 ibm-midrange db2-400
What's the correct way to check sql found condition in ILE RPG?

When working with embedded SQL in RPG, you often end up with a cursor and a dow-loop for processing all …

rpgle db2-400 embedded-sql
How to make connection in python to connect as400 and call any as400 programs with parameter

Anyone knows How to make connection in python to connect as400 iseries system and call any as400 programs with parameter. …

python-3.x python-2.7 ibm-midrange db2-400 django-pyodbc
IBM DB2: Generate list of dates between two dates

I need a query which will output a list of dates between two given dates. For example, if my start …

sql db2 db2-400 db2-luw