as400

How do you organize your RPGLE subversion repository on IBM i ?

How do you organize your RPGLE subversion repository on IBM i ? I'm currently working in a travel business company that has a vast amount (about 13k) of RPGLE - sources for their in-house application and finally they want to use version control and adopt a more modern style of coding (the whole WDSC - RDi stuff). So my all-the-time-pr...

SQL query of multi-member file on AS400

On AS400 in interactive SQL in a 5250 session, select * from myfile returns rows from one member only when myfile has more than one member. How can I get rows from a specific member? Important: in the end I'd like to do this over JDBC with jt400 so really I want a solution that'll work there. Thanks. ...

AS400 style naming over JDBC

Is there any way I can use AS400 style library/file style naming over JDBC with jt400? I want to be able to run queries like: SELECT * FROM MYLIBRARY/MYFILE Thanks ...

AS400 library/file (member) JDBC query

Using JDBC (with jt400 driver / connection, naming=system) I'm running these SQL statements: "CREATE ALIAS QTEMP/SOURCETEMP FOR " + library + "/" + file + " (" + member + ")" "SELECT SRCDTA FROM QTEMP/SOURCETEMP" "DROP ALIAS QTEMP/SOURCETEMP" This works. However, when the member String has a . in it this confuses everthing. Is there...

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 similar to getting table definitions from SYSTABLES and SYSCOLUMNS, but I'm unable to find anything so far. ...

Making update to AS400 from SQL 2000

I'm trying to update something in AS400 from sql server 2000 through openquery like following. UPDATE OPENQUERY(odbcname, 'SELECT * FROM "libname"."filename" WITH NC') SET NBFLAG01=1 WHERE NBFLAG01 <> 1 Here's the error I'm getting. "OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: Insufficient base ...

Convert String from ASCII to EBCDIC in Java?

Hello, I need to write a 'simple' util to convert from ASCII to EBCDIC? The Ascii is coming from Java, Web and going to an AS400. I've had a google around, can't seem to find a easy solution (maybe coz there isn't one :( ). I was hoping for an opensource util or paid for util that has already been written. Like this maybe? Con...

Anyone doing mainframe or AS/400 Batch processing with Java?

I'm going to propose to a client that I build some batch jobs in Java that will run on their mainframe and/or AS/400s (sorry System z and System i). Both platforms are up to date system software wise. I'm wondering if anyone has done this and can provide any pointer or gotchas to watch out for. The motivation is to have access to the to...

What resources would you recommend for RPG36 code conversion?

The question really asks it all. We have a bunch of really old S/36 programs that need to be moderized. I am more looking for articles or sites that explain what the old method does and how to convert it to RPGLE. ...

Are there some projects that rate RPG source? like software metrics?

I just wanted to know if you know of some projects that can help to decide whether the analyzed Source it is good code or bad RPG code. I'm thinking on the terms of [Software metric], [McCabe Cyclomatic Number] and all those things. I know that those numbers are mere a hunch or two, but if you can present your management a point s...

How can I access the name of a current library in a CL program?

I need to use the current library name explicitly in a CL program. CHGVAR &LIB *CURLIB doesn't work (after this line &lib = '*curlib'). This should be simple - any ideas? ...

DSN-less ODBC Connection to iSeries

I'm running PHP 5.2.4 with ibm_db2 v1.8.0 on Ubuntu 8.04.1 Server. I am trying to hit an IBM iSeries running OS/400 v5R3 but I'm not sure at all how to actually connect without a DSN. I've looked at http://www.connectionstrings.com/ but none of the DB2 or AS/400 connection strings seem to work. All I end up with is: [IBM][CLI Driver] SQ...

What database tool to use on Linux to read an as/400 database?

From Linux (Red Hat dist), we need to read an AS400 database. We have the ODBC driver to connect, what's the best query tool? ...

AS400 SQL query with Parameter

Hello, I am testing a simple query to get data from an AS400 database. I am not sure if the way I am using the SQL query is correct. I get an error: "The parameter is incorrect." Select FIELD1, FIELD2 From Mylibrary.MyTable WHERE FIELD1 = @Field1 I don't get an error when I run the following query: Select FIELD1, FIELD2 From Mylib...

telnet to port 25 from AS400

I want to very SMTP connectivity from an AS400 in a VM to a mailserver on port 25 The native telnet command on the as400 does not seem to support a port specification. Any ideas how to telnet from as400 to port 25 on my mailserver? I can ping the mailserver from the as400 I can telnet in from other boxes (non as400) Thanks \0 ...

AS400 Data Connection in ASP.NET

I have an application that will reside within a business2business network that will communicate with our AS400 in our internal network environment. The firewall has been configured to allow the data request through to our AS400, but we are seeing a huge lag time in connection speed and response time. For example what takes less than a ...

How do you access data from your I Series in ASP.Net?

All of our current ASP.Net web apps access our IBM I Series using an ODBC connection and command object. Should I move to another way of accessing it? How do you current access your I Series when your ASP.Net app needs data from it? There has to be a better way. I recently saw this article about IBM supporting Linq to Entities with a sp...

Where can I find an AS400 to Java interface?

Does anyone have links and resources to connect to an AS400 from Java? I remember years ago, somebody told me about a connector that simulates KeyStrokes from the keyboard and other "purest" approach that connected directly. On the web I have found a lot of links, but I cannot find a complete product to do this (I am probably not usin...

Error while connecting to DB2 from JBoss Application Server

Hi, I'm trying to connect to the AS400 database DB2 from a Java application hosted in JBoss application server. But, I'm getting the below error when ever I run my application: Apparently wrong driver class specified for URL: class: com.ibm.as400.access.AS400JDBCDriver, url: jdbc:as400://DBSYTEM;driver=toolbox;trace=false;errors=full;p...

Is it possible to create a view that is aware of current schema/library name?

Background: iSeries version of DB2. In every environment, there is a table containing positional column information about other tables. As the data in this table is static and has to be re-generated every time a table is altered, problems can occur if it is out of step. All the positional data exists in QSYS2.SYSTABLES and QSYS2.SYSCOLU...