Convert Date to Integer or Dec...

SQL: from integer to date...

meta data on As400 (IBM i) SQL table QSYS2.SYSTABLES...

Why is *SHRRD lock HELD on a PF by job QZDASOINIT user QUSER, even after querying a new PF?...

How can I get which application is locking a table/record in DB2 for i...

CRTSQLCI v RUNSQLSTM...

InvalidDataAccessResourceUsageException SpringDataJPA IBM AS/400 DB2 AS400JDBCSQLSyntaxErrorExceptio...

DB2 - use field as a labeled duration for time calculation...

flyway, added additional JDBC driver, still getting "No database found to handle"...

What is a valid END-OF-STATEMENT for IBM SQL?...

DB2 merge upsert gets 'Row not found for MERGE' error...

DB2/Sql grouping with condition...

Is rowid concept is there in AS400 like in oracle?...

Update failing on DB2 i Series table (TIMESTAMP)...

Incorrect data population issue in numeric field in PF in AS400...

When is there a need for an sql package used?...

DB2 - Iseries (AS/400) DDS to DDL (FIFO, LIFO)...

Converting decimal to Date...

Why does DB2 put my UserId from the connection string as my table name?...

How do I insert a character every 2 spaces in a string?...

How to select columns that aren't part of an aggregate query using HAVING SUM() in the WHERE and...

Write SQL output from IBM i Db2 to IFS in XML format using QSYS2.IFS_WRITE...

DB2 Select column names from nested select...

Position 1 Keyword SEARCH not expected. Valid tokens: ) FETCH LIMIT ORDER UNION EXCEPT OFFSET...

AS400 duplicate fileds name different types in logical file...

How can I parse correctly this XML file with parameter in main TAG?...

Server name, Instance Name, DB name in DB2 via sql query...

DB2 Error executing sql statement: [SQL0104] Token ) was not valid...

Getting the order status of the vehicles on order...

Converting SQL Server query to DB2...