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.

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 …

db2 limit ibm-midrange
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 …

stored-procedures db2 ibm-midrange
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 …

java ascii ibm-midrange ebcdic
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

sql ibm-midrange
GETDATE() method for DB2

I have been trying for a while now to get a similar method to GETDATE() in DB2 for i. So …

sql sql-server tsql ibm-midrange db2-400
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 …

c# .net asp.net sql ibm-midrange
SSIS: Just started getting a "Key not valid for use in specified state." error on my scheduled SSIS package

I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs …

sql-server sql-server-2005 ssis ibm-midrange bids
CPF4131 appeared during OPEN for a file

What are the possible reasons for CPF4131 to be appearing on a file in a program. And how do we …

ibm-midrange rpgle
Update 1 field in a table from another field in a different table (OS400, not a 1 to 1 relationship)

Im trying to update a field in a table from another field in a different table. The table being updated …

sql db2 sql-update ibm-midrange