ISeries

Using the SQL IN clause in SQLRPGLE

Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

How do I determine the price ranges for an iSeries?

I am interested in understanding how much an iSeries costs (mid-range and enterprise level systems) and its associated hardware components such as DASD, memory, etc.. I have been browsing the internet, but I have not come across a site that clearly lists the price for a specific iSeries model or...

Tuning DB2/400 queries on iSeries

We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

System Request Menu

How can you control access to the System Request Menu ? Want to deny end users, but allow programmers, operators, etc. Thanks, Bill Poulin

SQL Stored Procedure

I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

calling java function running on websphere from as/400

How to call a java program running on web sphere application server from System i? We are able to call a java program deployed on System i on IFS directory using RPG ILE.

RSTLIB and Journaling

I am doing a SAVLIB of our Production Data Libraries creating SaveFiles on our Production iSeries, then thru FTP, transferring the SaveFiles to our Development iSeries, then doing RSTLIBs. During the RSTLIBs I get a CPF7085 - Journal QSQJRN already exists and CPF3756 - JRN QSQJRN not restored. ...

Iseries fails to boot

I have a v5r4 820 model that failed. Error code in display is 284C3203 which pointed to I/O problem for either system board or Disk controller. I replace both and the only way I can get past this error is by using the new disk card with the new RAID memory. The old RAID memory card seems to have...

Problem with CCSID ?

Hi Our iSeries is on V5R4 and hosts a few Lotus Domino Servers... The Domino servers runs scheduled agents which create CSV File stored on the IFS. I can access and open these CSV files under Windows (with this syntax \\SERVER\SHAREDFOLDER)but the content is like this : ...

Mapping to IFS from another domain

Iseries and AD profiles are synch'd for mapping IFS Shares. We now have other users from another domain accessing the shares, If the get the windows Signo window what need to be inputted?

create a remote outq which points to an outq on the remote iSeries

i need to transfer spool files from one iseries server to a remote iseries server.

Does anyone know if Mime&Mail (MMAIL) works with i5/os V6R1?

We use MMAIL daily at our shop. We will replace our i5 this winter, the new i5 will come with V6R1. Does anyone know if MMAIL will work on V6R1? Any issues with conversion, APIs or etc.?

OS/400 V5R3MO to Oracle 10g

I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures which I like to migrate from source to oracle too. As I know Oracle migration workbench works on V4R5 0R V4R3 but not on V5R3MO .So there...

AS400 mapped drive locks Windows account

I have a user that has AS400 mapped drives. When they access the drive, their Windows account gets disabled!?!? This isn't happening to anyone else. We use EIM to control access to the Netserver folders. He can access the AS400 folders just fine, but when he does, that's it for his Windows...

Migration

I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or...

import data from excel 2007 to iseries

how do you import data from excel 2007 to iseries

Port 443 is 'filtered' to internet clients. How can I make it 'open'?

The problem is that HTTPS 443 port isn't accessible from interned, but it is open in local network. Our iSeries 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...

iSeries Object Deletion

Is it possible to track down who deleted an object on the iSeries? (Not a system object). Where should I look?

Address validation or checking software

I'm looking for a software that check and/or correct address entry, Is there an application for Iseries based? I've found some windows and Web based applications but not on the AS400.

iSeries: Accessing src PF member using Java/400

I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member (e.g...