Top "Ibm-midrange" questions

The IBM i is a proprietary platform from IBM, which runs on their Power Systems and Pure Systems, and contains a DB2 database integrated into the IBM i OS.

Why do I get the error "Cannot store non-PrivateKeys" when creating an SSL Socket in Java?

I am working on an older IBM iSeries (IBM-i, i5OS, AS/400, etc), with a Java 5 JVM (Classic, not ITJ …

java ssl ibm-midrange
Create a delimitted string from a query in DB2

I am trying to create a delimitted string from the results of a query in DB2 on the iSeries (AS/400). …

sql db2 ibm-midrange
iSeries DB2 - Is there any way to select the identity value from an insert statement?

I know we're rare, us poor folk that are using iSeries for DB2/AS400, but I'm hoping someone can answer …

sql db2 ibm-midrange
AS/400 DB2 Logical File vs Table Index

I'm coming from a MSSQL background, and when I ask people at my company if they've created Indexes on certain …

sql indexing db2 ibm-midrange
How to join table to itself and select max values in SQL

I have a contracts table: contractId date price partId 1 20120121 10 1 2 20110130 9 1 3 20130101 15 2 4 20110101 20 2 The contract with greatest date being the active contract (don't blame …

sql db2 ibm-midrange
Java: Convert String to packed decimal

new here! Situation: I'm working on a project which needs to communicate with an AS/400 server. My task is to …

java byte ascii ibm-midrange ebcdic
DB2/iSeries SQL clean up CR/LF, tabs etc

I need to find and clean up line breaks, carriage returns, tabs and "SUB"-characters in a set of 400k+ …

sql db2 ibm-midrange replace
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
Connect to IBM i server from Sql Server 2008 R2

I have a big deal: I have to connect (I just want to read data, not to write) to my …

sql-server database-connection oledb ibm-midrange linked-server
DB2 Using LIMIT and OFFSET

I am developing a Java Web service allow paging when fetching big data set from a DB2 Database on a …

sql db2 ibm-midrange sql-limit