iseries

Is there an numeric type in ILE RPG which will overflow without crashing my program?

I'm looking for a numeric type in ILE RPG which will "wrap round" when it overflows, in a similar way to how a C int would. Is there such a thing? ...

NHibernate - Why does Delete() call fail to delete but delete through HQL works?

Considering the following code blocks, why does call to HQL work but call to delete() not work? As a background, I'm using NHibernate over IBM.Data.DB2.Iseries driver. Come to find out, journaling on the AS400 is turned off so I can't use transactions. I'm not the AS400 admin or know anything about it so I don't know if having journaling...

Access AS400/DB2 with SQL 2008 Express

I'm trying to add the AS400 as a linked server in SQL 2008 Express in order to access some tables in a DB on the iSeries. I've tried all of the OLE providers with many different strings and have had no luck establishing a connection. Is this even possible with this version of SQL? Thanks ...

NIO file channel transfer problem on iSeries

Hi all, I'm having a problem with some Java NIO code running on an iSeries box (JDK 1.5). Basically the code is splitting a file up into chunks part of a file to another smaller files. The same code has been operating on other iSeries boxes for some time with no problems. Here's the code snippet: //copy original data file content to te...

Processing XML from a Table (with one line in one record each)

IBM only provides a database connection to the iSeries, thus I have to work around this issue with using a table to pass data from the iSeries to .NET. The RPGLE program creates an XML document in a table for processing on the .NET side. The thing is that on one record in the table has one line of the XML document. To help visualize pr...

Is CPYTOIMPF to qtemp faster than to other library?

I am a programmer working on IBM AS400 V5R4. I create 2 CL programs, both of which use CPYTOIMPF to format a list of AS400 PFs to character delimited files. The difference between them is: one formats files to qtemp(PGM A), while the other one formats files to a library other than qtemp(PGM B). I called the 2 program separately to forma...

Web development on iSeries with ABL's Strategi

Advanced BusinessLink offers a suite of products called Strategi, which basically allows creating web applications running natively on iSeries, consuming and providing web services, and replacing green screens with web user interfaces, among other things. The business logic is written on RPG, with web pages combining html and a proprieta...

Best way to access data stored in relational files (not DB2) on an AS400, using .NET?

We have need to connect to an AS/400 from .NET (C#) and access (read and write) data. The issue is the data is stored in relational files on the mainframe, not in a DB2 database. What is the best way to accomplish this? I would love to use an ADO.NET Entity Framework type solution, but I believe the compatible data providers only work ...

Invoking ASO400 RPG From Java

Hi, I have a very limitied (0) knowledge on AS400 and RPG. But we have a urgent requirement where we need to invoke a RPG program from a java class. So I found that we can achieve it through JTOpen. But I am stuck at declaring the ProgramParameter list. I have the following information about RPG Program Program name: ZM30000R Parame...

DB2 - 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 takes in a parameter and returns a result as an output parameter and print the value to the...

Using LINQ with IBM i

Has anyone been able to use LINQ with the IBM i? That is without having to write a custom provider? ...

DB2 - How to run an ad hoc select query with a parameter in IBM System i Access for Windows GUI Tool

I would like to run some ad hoc select statements in the IBM System I Navigator tool for DB2 using a variable that I declare. For example, in the SQL Server world I would easily do this in the SQL Server Management Studio query window like so: DECLARE @VariableName varchar(50); SET @VariableName = 'blah blah'; select * from TableName ...

Rational developer for power and ILE C compilers - Is ILE-C still supported?

Websphere Studio for System I is EOL as of April and the literature on the web page for Rational Developer for Power Systems Software doesn't explicitly mention C compilers. What is the relationship between RDPS and the "The ILE Compiler set"? Is the latter product still supported? Is this the right product to build something involv...

Speeding Up Queries with LINQ

I am transferring about 350 rows (with some data collection) from a MS SQL Server to the iSeries for processing. I feel the process is too slow which is about a minute or so. I am doing all of the MS SQL stuff in LINQ2SQL. Here is the basics of what I am doing currently: Collect all of the vehicle master data to process one-at-a-time. ...

Call MiSys Equation API from BizTalk

How can I call MiSys Equation API from BizTalk or .NET? Equation is a banking system hosted on ISeries AS/400 server. is the Host Integration server way to go? ...

DB2 Transaction Logs

How to read Transaction Logs of DB2 in iSeries / AS/400. Is there any C or C++ or Java API Any help is appreciated? ...

recursive run of rpg program

i am running a rpg program recursively it is giving an error like this Application Error. RNX8888 unmonitored by PGM1 at statement *N, instruction X'0000'. Trigger program or external routine detected an error.....what can be the resolution ...its urgent..thanks ...

Very strange iSeries Provider behavior

We've been given a "stored procedure" from our RPG folks that returns six data tables. Attempting to call it from .NET (C#, 3.5) using the iSeries Provider for .NET (tried using both V5R4 and V6R1), we are seeing different results based on how we call the stored proc. Here's way that we'd prefer to do it: using (var dbConnection = new...

problem with NHibernate and iSeries DB2

Ok So I have an AS400/iSeries running v5r4. I have an application that was using classic NHibernate to connect and do some basic crud. Now I have pulled that app (which sat for 2 years) off the shelf of TFS and onto a new PC and cannot seem to get it running. Here is my Hibernate Config: <hibernate-configuration xmlns="urn:nhibernate-...

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 ...