Questions tagged [ibm-midrange]

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.

Originally introduced on June 21, 1988 the platform has been continually updated to support and integrate with modern technologies while maintaining source and binary compatibility.

The platform includes an integrated database server and natively supports many application servers including , and .

The proprietary OS uses an object-based architecture, which encapsulates and protects the integrity of objects. An object can only be used in ways allowed for that object type. For example, you cannot open a program as if it were a file for I/O, nor can you execute a file as if it were a program. This is unlike the Unix/Linux/Windows model where everything is a file.

Common programming languages for the IBM i platform include:

The platform is capable of running AIX executables via its Portable Application Solutions Environment (PASE) functionality. This has, in particular, permitted the extensive availability of open source software on the platform (PHP, Python, Node.js, ...). As of v7.2 of the operating system, yum is the supported package manager for most open source solutions that have been ported to IBM i.

For more information see the Wikipedia article on IBM i.

2742 questions
97
votes
10 answers

Equivalent of LIMIT for DB2

How do you do LIMIT in DB2 for iSeries? I have a table with more than 50,000 records and I want to return records 0 to 10,000, and records 10,000 to 20,000. I know in SQL you write LIMIT 0,10000 at the end of the query for 0 to 10,000 and LIMIT…
elcool
  • 6,041
  • 7
  • 29
  • 44
42
votes
7 answers

Connect to AS400 using .NET

I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400. What do I have to install on my machine (or the AS400 server) in order to connect? (IBM iSeries Access for Windows ??) What…
madatanic
  • 1,760
  • 3
  • 16
  • 28
37
votes
8 answers

Connect PHP to IBM i (AS/400)

I've got an upcoming project wherein I will need to connect our website (PHP5/Apache 1.3/OpenBSD 4.1) to our back-end system running on an iSeries with OS400 V5R3 so that I can access some tables stored there. I've done some checking around but am…
dragonmantank
  • 15,243
  • 20
  • 84
  • 92
32
votes
6 answers

How to do SQL select top N ... in AS400

How do you perform a Select top N * from as400table type query against an as400/db2 database
James Moore
  • 2,501
  • 6
  • 26
  • 29
23
votes
3 answers

Memory leaking without objects growing in number or size

On an IBM iSeries system, I have a Java program running - an application server with a web server component, all in-house developed. When running on the 32 bit or 64 bit J9 JVM (IBM Technology for Java) I have symptoms of a memory leak. Note that…
Lawrence Dol
  • 63,018
  • 25
  • 139
  • 189
20
votes
10 answers

Convert String from ASCII to EBCDIC in Java?

I need to write a 'simple' util to convert from ASCII to EBCDIC? The Ascii is coming from Java, Web and going to an AS400. I've had a google around, can't seem to find a easy solution (maybe coz there isn't one :( ). I was hoping for an opensource…
scottyab
  • 23,621
  • 16
  • 94
  • 105
19
votes
5 answers

SQL query of multi-member file on AS400

On AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has more than one member. How can I get rows from a specific member? Important: in the end I'd like to do this over JDBC with jt400 so…
tmtest
  • 1,541
  • 3
  • 15
  • 14
18
votes
3 answers

GETDATE() method for DB2

I have been trying for a while now to get a similar method to GETDATE() in DB2 for i. So far I have found the following: current date current timestamp current time Would it be possible for me to: select specific, columns from table where…
DeanMWake
  • 893
  • 3
  • 19
  • 38
18
votes
3 answers

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 this simple question. Is there any way to return the identity value from an insert statement without using two lines of SQL? I'm being forced…
AJ.
  • 16,368
  • 20
  • 95
  • 150
17
votes
7 answers

Using Delphi data-aware components - pros and cons

I want to know your opinion about using data-aware components in projects. Which are the 'strength' and 'weak' points of developing applications(win32 and web), by using Delphi and data-aware components(from Delphi's standard suite or third-party)?…
RBA
  • 12,337
  • 16
  • 79
  • 126
17
votes
3 answers

How to call a stored procedure in IBM System i Access for Windows GUI Tool

I would like to test a DB2 stored procedure running on an AS400 system. I have the IBM System i Access for Windows installed and can run SQL commands against the DB2 database. My question is: What is the syntax to execute a stored procedure that…
Ken Burkhardt
  • 3,528
  • 6
  • 33
  • 45
16
votes
6 answers

DB2 400 drop column

I want to drop a column called id which is an auto incrementing PK. The SQL: alter table "CO88GT"."XGLCTL" drop column id cascade; And I get: Error: [SQL0952] Processing of the SQL statement ended. Reason code 10. SQLState: 57014 ErrorCode:…
Quaternion
  • 10,380
  • 6
  • 51
  • 102
16
votes
8 answers

AS400 Emulator or Virtual Machine

Do these exist? Can you recommend one?
user48545
  • 3,291
  • 9
  • 31
  • 42
16
votes
1 answer

Connect to IBM DB2 with .Net using only .dll reference

I would like to connect to a DB2 database, specifically an iSeries version, using .Net and C# by referencing a .dll and NOT installing any software on the server. Currently we use the IBM.Data.DB2.iSeries.dll, which is installed as part of iSeries…
Blake Mills
  • 824
  • 2
  • 9
  • 15
14
votes
3 answers

Why aren't connections being reused in my iSeries/ASP.NET MVC 4 app?

We are running an MVC 4 web application on a Windows 2008 server farm. We have been trying to upgrade our server farm to Windows 2008 R2 64-bit servers but have run into an issue with connection pooling on an iSeries (running V7R1). We frequently…
Joel Anair
  • 13,832
  • 3
  • 31
  • 36
1
2 3
99 100