as400

Connect PHP to an AS/400

I've got an upcoming project wherein I will need to connect our website (PHP5/Apache 1.3/OpenBSD 4.1) to our back-end system running on a iSeries with OS400 V5R3 so that I can access some tables stored there. I've done some checking around but am running into some roadblocks. From what I've seen the DB2 extensions and DB2 software from ...

Resources for an Oracle beginner

Can anyone recommend some good resources that highlight the differences between Oracle and the AS/400 database? I am trying to help someone with a lot of AS/400 experience implement an Oracle installation, and they need some guidance. A book or online resource would be ideal. ...

Sample code for using IBM's PCOMM in C# o write an as400 screenscraper

Has anybody used C# to write a sample screen scraper for IBM as400? ...

How do indicate the SQL default library in an IBM iSeries 2 connection string to an AS/400?

I'm connecting to an AS/400 stored procedure layer using the IBM iSeries Access for Windows package. This provides a .NET dll with classes similar to those in the System.Data namespace. As such we use their implementation of the connection class and provide it with a connection string. Does anyone know how I can amend the connection str...

How do I iterate over a set of records in RPG(LE) with embedded SQL?

How do I iterate over a set of records in RPG(LE) with embedded SQL? ...

Setting a key field on a view

I am creating an SQL view for a file that strips out the spaces in a particular field. My question is if there is a why to set a key on that new view so a person can still CHAIN the file. We are on V5R3. ...

Source Control on the IBM i (iSeries)

On the web side we are working on getting source control. Now, I want to see what can be done for the iSeries side. What is your favorite source control application for iSeries and why? I am looking for low-cost if possible. ...

C#: Convert COMP-3 Packed Decimal to Human-Readable Value

I have a series of ASCII flat files coming in from a mainframe to be processed by a C# application. A new feed has been introduced with a Packed Decimal (COMP-3) field, which needs to be converted to a numerical value. The files are being transferred via FTP, using ASCII transfer mode. I am concerned that the binary field may contain wh...

iSeries Export to CSV

Is there an iSeries command to export the data in a table to CSV format? I know about the Windows utilities, but since this needs to be run automatically I need to run this from a CL program. ...

iSeries SQL Procedure - Check if already exists

I have an script that falls over if any of the procedures it is trying to create already exists. How can I check/drop if this procedure is already created? ...

Accessing RPG on iSeries from Java

Has anyone had good experiences of talking direct to RPG programs running on a V5R4 iSeries machine from Java? If so, what are the recommendations of the community, and what pitfalls should I try to avoid? From the various pieces of literature and spike solutions I have attempted it looks as though we can use ProgramCallBeans (either th...

Encrypt on iSeries

What tools are available to encrypt or password-protect a file stored on the IFS? *integrated file-system, accessible from Windows ...

OpenQuery to DB2/AS400 from SQL Server 2000 causing locks

Every morning we have a process that issues numerous queries (~10000) to DB2 on an AS400/iSeries/i6 (whatever IBM calls it nowadays), in the last 2 months, the operators have been complaining that our query locks a couple of files preventing them from completing their nightly processing. The queries are very simplisitic, e.g Select [Fie...

Data structure definitions / templates in RPG(LE)

Say I have a data structure, such as d dog DS qualified d name 20 d breed 20 d birthdate 8 0 I can then define d poochie likeds(dog) and use poochie.name, etc. But can I just set up the 'dog' as a template w...

iSeries - Call SQL stored procedure from CL program

How can I run a stored procedure from a CL program? RUNSQLSTM requires a source member, but I just want to build a command so users can pass in variables easily, so this won't work. ...

XML and iSeries RPGLE - development tools?

I've got a iSeries to .Net compact framework project. It includes rgple programs exposed as web services and a Windows mobile app that uses the webservices. Each iSeries program has a specific webservice wrapper and the .net app reference each. I would like to come up with a more generic messaging service using XML. I am fairly fami...

AS/400 ODBC Drivers

We have been using the Client Access ODBC drivers when accessing AS/400 data from our .net applications and SQL DTS/SSIS packages. Are there third party drivers that provide better performance or functionality? ...

AS400 C#.net inserting new record problems

I am trying to build a C#.net program that works like a RPG Subfile on the AS400. Have the general subfile part working. I can display and then edit and update existing records. Am blowing up in my code where I am trying to insert a new record. Blowing up on the cmd.ExecuteNonQuery(); If you want to see how this works without the i...

Port 443 on iSeries v5r4 is ‘filtered’ to internet clients, even it is allowed in firewall rules. How can I make it ‘open’? Can it be i5/OS bug? [SOLVED]

Port was fitered by ISP. The problem is that HTTPS 443 port isn't accessible from internet, but it is open in our local network. Our iSeries v5r4 is connected to inet via L2TP withot IPSec. If no packet filters are active, nmap shows that ports 25, 80, 110 and even 10322 (WAS admin console) have state 'open' on internet ip address. 443 ...

Mail from iSeries with attachment

Is there a way to send an email from an iSeries terminal, adding an attachment from the IFS? I know how to send a normal email using the SNDDST utility. ...