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.

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
Conversion error on host variable or parameter *N

I am getting this Error on Insert statement to AS400 database, using Java with JDBC.

sql ibm-midrange
SQL7008 Error - Workaround?

I'm using the JTOpen JDBC driver for a DB2 Universal database. I have very little experience with SQL beyond simple …

java sql jdbc db2 ibm-midrange
Connecting to an IBM AS/400 DB2 Database

I'm trying to connect to a client's IBM AS/400 DB2 Database from an Ubuntu Server using PHP's ODBC Driver. I …

ubuntu db2 ibm-midrange unixodbc
What is the carriage return character in an AS/400 db?

I have a client running an AS/400. I have to ftp a flat file over to them. They tell me …

ibm-midrange carriage-return
What's the difference between EVAL and MOVE in RPGLE

I recently got into the IBM's RPG world, so while writing some code and reviewing other people's code I've found …

ibm-midrange rpgle rpg
Grouping by MONTH in SQL

I am trying to put together a table that will take a full date, YYYY-MM-DD, pull out only the month …

sql db2 ibm-midrange
On DB2 for i, Search for Column, return table names in list form

I'm still a bit of a noob, so pardon if this question is a bit obvious. I did search for …

sql db2 ibm-midrange squirrel-sql
Repeated prompt for user name and password when accessing AS400 IFS under Windows XP using map network drive

I was trying to access the IFS using map network drive. It prompted the dialog asking for user name and …

ibm-midrange network-drive
How to get the length of character type variable in RPGLE?

Is there any easy way to directly return the length of character and type variable in RPGLE? The length I …

ibm-midrange rpgle variable-length