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.

PHP/Linux to AS/400-db2

I am trying to get php on Linux Centos server access as/400 (iSeries) db2 database. I am using this IBM …

linux odbc db2 ibm-midrange
List of source members in a file with SQL

Is it possible to generate a list of all source members within an iSeries source file using SQL? Might be …

sql ibm-midrange
External stored procedure on IBM i

I am trying to create an external stored procedure on an IBM i (V5R4), but I'm getting an error …

stored-procedures ibm-midrange rpgle
Run a SQL query on a DB2 file with a dot "." in the name?

I have a DB2 file with a name like "my.test". The DB2 filename contains a dot '.' If …

db2 ibm-midrange
What's the equivalent of Oracle's to_char in AS400 DB2 SQL syntax?

I'm trying to display a DATE field fetched from a DB2 instance. In Oracle I'd use something like: to_char(…

oracle db2 ibm-midrange to-char
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
Error SQL0104 when creating a function in System i V7R1

I'm creating a SQL function on System i V7R1: CREATE FUNCTION MYSCHEMA.GROUPDIBAS(v_code VARCHAR(50)) RETURNS VARCHAR(2048) LANGUAGE …

sql for-loop ibm-midrange create-function db2-400
Add a field description to a DB2/400 file

I have a set of files in a library on an AS/400/iSeries/System-I/whatever-IBM-wants-me-to-call-it-these-days which I do not have …

sql db2 ibm-midrange db2-400
How to view a Trigger Definition in AS400

I have been trying to view the Trigger Definition for a trigger for AS400, and can't seem to find the …

ibm-midrange db2-400
How to move a DB2 SQL result table into a physical file?

I would like to get the result table from a SELECT statement, and then move it into a physical file. …

sql db2 ibm-midrange rpgle