iseries

System i (iSeries, AS/400) Message Queuing Options

I'm trying to find options for MQ on the iSeries besides WebSphere MQ. Does anyone have experience with this? Is it possible? Could I run a pure java MQ server like OpenMQ? ...

[DB2] ordering resultset ö together with o

I want to order a resultset. The columns which i want to use for ordering contain german umlauts like ö, ü and ä. I want column data with these sortet together with normal letters. Example: At it the Moment, the resultset is ordered like this: ABCOXYZÖ I want it to be ordered like this: ABCOÖXYZ Thanks ...

how is the best option for ibm iseries legacy code consuming web services

Scenario: old legacy code in rpg have to consume data from a new web service I think in a new stored procedure implemented in any language to act like a proxy but sure there are better options Some options i have seen is http://www.rpg-xml.com/ (third party propietary) or using Java stored procedures with DB2 XML Extender Thank you!!!...

How can you enable transactions with IBM.Data.DB2.iSeries for stored procedures

I am trying to write a client which executes a series of DB2 iSeries Stored procedures in DB2. I am using the IBM.Data.DB2.iSeries provider and need all my calls to be within a .NET transaction. Seems like everything is ignored and data being committed.Any pointers... ...

Subversion for iSeries

Hi, We need info about Subversion for iSeries (OpenSource version). Has anyone used it for production systems? Thanks, Sam ...

AS400 / DB2 cross-library query problem

Hi - I'm querying an Iseries from ODBC in my app and am trying to perform a query that returns results from 2 tables. I need to join the tables but the tables are in different libraries. I don't want to use library identifiers in my query as my libraries change as I move from dev>qa>prod. However, I am certain that these tables will only...

Copy SQL Stored Procedures between DataSources/Schemas?

Hi Friends, I've created SQL stored procedures in our development schema and its working fine. Now we are in the task of moving our development codes to production one. How do I copy those stored procedures from one schema to another schema? Do I need to re-compile whole procedures on targeted schema? Or Is there any way register those p...

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 to use inline SQL in C# to perform an insert, and then I need to use the identity generated...

SQL injection - no danger on stored procedure call (on iSeries)?

I've done some searching around but I have a specific question on SQL Injection and hope I can get some input as I believe I may be getting the wrong end of the stick to do with field data sanitising etc :- I have a java program calling a stored procedure on an iSeries. The stored procedure has CL / RPG code behind the scenes. The store...

Commitment control error on iSeries procedure call

I have an intermittent problem when calling an iSeries stored procedure (consisting of various CL & RPG programs). The error is:- Commitment definition *N not valid for open of QAOSSI12 Error occurred while opening file QAOSSI12. As mentioned the problem does not always occur but occurs more when load testing the procedure. I kn...

Create a Spooled File from Java with a specified Job name on iSeries

Is there a way to specifiy the JOB name when creating a spooled file? So that my created s.f. doesn't have the default "QPRTJOB". My method that creates a spooled file with the default QPRTJOB job: public static SpooledFile createSpoolFile( com.ibm.as400.access.AS400 as, PrinterFile pPrinterFile, OutputQueue outq, String ...

Calling a remote Java program on iSeries from RPG

I'm looking to invoke a Java program from RPG running on Iseries V5r4. The remote program is a web service client (performing a postcode lookup), running in Websphere. Ideally I'd like to call it direct from RPG? is that possible? or do I have to create a java program to run on the iSeries and use RMI or something to call the remote j...

Conditional Compilation in RPG(LE)

Can I include a section of code based on whether a variable is defined in my program, or is the preprocessor completely unable to access this information, only compilation conditions? I.e. I'm after something like: /IF DEFINED(myVariable) D myOtherVariable S like(myVariable) /ELSE D myOtherVariable S ...

Class generation from database schema

I've dug around through previously asked questions and have had no luck finding a duplicate. I would love to generate basic entity classes in .Net from a DB2 schema (using the iSeries OLEDB provider). Is there any simple way to do this? I've looked into MyGeneration and CodeSmith and it just seems like there must be an easier way. ...

Simplest way to access a DB2 database on iSeries from a Linux (ubuntu) machine?

I would like to run an SQL query on an iSeries (...or "System i" or "AS/400"...) machine as part of a Nagios check, but haven't found a suitable way of interfacing the database yet. IBM suggests using the ODBC driver of System i Access for Linux with unixODBC, but since both systems are new to me, I'd like to know if there are other wa...

How long can memory leaks persist in RPGLE programs?

I'm putting into production some RPGLE code which uses %alloc and dealloc to allocate memory. Programmers should be able to ensure there are no resulting memory leaks but I'm worried about what happens if they don't. My question is: if programmers mess up and there are memory leaks then when will this memory be reclaimed? Is it when ...

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 when I try to run it. All I want to do is call an RPG program, without passing any parameters or worrying about returning any data. Sorry, I'm not an RPG programmer or an expert on IBM i, so I could be missing something very simple. The SQL ...

refactoring in iSeries (RPG), is it realistic

Implementing agile in projects requires the ability to do refactoring. It is not really a must, but code refactoring has proven to be a good engineering practice. In an agile (Scrum) project on the iSeries platform, which requires development (new code and modifications to legacy code) in RPG, RPG LE, is it possible to implement refacto...

Add a column to a DB2/400 table with a specific ordinal position

Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a specific ordinal position, or moving an existing column to a different position? ...

How can I get the EBCDIC value of a character in RPGLE?

I need to have some way of converting single characters in RPGLE into integers - does anyone know a good way? It has to work for all possible inputs and ideally provide a different integer for each input - at the very least it must provide a different value for all common inputs. I don't care particularly what the integers are. In a C li...