ISeries

SQLRPGLE Cursors and Recursion

I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

data search using popup window

Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF? Software/Hardware used: RPG, CL, SQL, iSeries

Notes agent accessing attachment from IFS on another iSeries

I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document.  I am having difficulties with this.  When the IFS was local (on the same iSeries) it was easy, just point to the directory with...

AS 400 software problem

Received the following in wrkprb should I contact IBM  Problem message ID  . . . . . . . :   CPI93B9                                  Severity  . . . . . . . . . . . . :   None                                     Problem...

iSeries SQL UDF gets CPF426A

I created a SQL UDF using the iNav wizard.  It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.)  It says the...

IBM i certifications

Hi, can anybody plz list out the types of certifications one can do on IBM i including the administration and development. I am experienced over 5 yrs in development and a novice in administration. Hence to move my career ahead and as an administrator too i wanna do some certifications. Plz help me...

DSPOBJD - Storage Information

We have a production system and a DR system, we use MIMIX to keep the systems in sync.  If I do a DSPOBJD on a Ile in both systems I get a Different value in the Storage Information : Size field.  The number of records and everything are the same.  Any Ideas ? Software/Hardware used: IBM...

Binder Language

What Binder language meant for? I think to export Procedures outside the service program... Is it correct? I got a doubt that, If ina module, a procedure is defined as EXPORT then any way we can access it from any other module. In that case what the need of Binder lang? Software/Hardware used:...

Is the new WRKDBF out yet?

Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together. Software/Hardware used: i5 v5r4

Tracking data changes on IBM i with triggers

Hi I like to implemnet this tip can you share the sources files of this tip

ILE O spec to print file

I am looking for a program to convert ILE O spec to a print file. Software/Hardware used: AS/400

Automatic Data transfers from iseries

I am quite ok with manual data transfers and menu options calling transfers, but does anyone know how to get a data transfer set up from the iseries to a mapped drive on our server to run automatically, e.g. at 04:30 am ? Also, is it possible to send data from the iseries to a server that is not on...

Retrieve error message in RPG

I have an interactive RPGLE program ,PGMA, that calls another RPG program, RPG3P, based on a parameter and that job is not interactive. If RPG3P aborts how can I find out what the error mesage was? The job log does not give enough information to help find the problem. Software/Hardware used: V5R4

Swapping user profiles

We do not have single-sign-on, and have an iSeries user profile named "AM2000" that also exists on our network. Historically, by compiling CL programs as AM2000 with USRPRF(*OWNER), any user could execute the program and access network files "as AM2000". Something has changed (possibly moving from...

Copy File from PC file to Iseries- Change record length.

I am trying to copy a PC text file and copy it in a wrapping format to an ISeries DB File with a single 128 length field. I am trying CPYFRMIMPF, CPYFRMPCD, CPYFRMSTRMF and they all seem to cut off part of the record. Can this be done short of counting characters in a record? Software/Hardware...

Database member Cross reference in Qsys? - Where's it hidden?

A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field. I've been looking for the equivalent for file members. Specifically, I want to search for all occurrences of a given file member name across the system's many...

SMTP and internet mail

Using the SNDDST command on an iSeries with Notes mail. Recently had to switch to HA box (don't ask..). Made all the SMTP command changes, ended the server and restarted. Cannot send internet mail. Returns NOT ABLE TO DELIVER MAIL, 554. FIrst was using our backup mail server (not defined on...

query/400

plz tell me how to work with query/400 on as/400 machine...thanks Software/Hardware used: as/400,IBM i

progam change date updated for SQLRPGLE program

Can anyone tell me where I can fird the reason that the 'program last change date' is updated in an SQLRPGLE program when it is run?  It showed up on an audit and the auditors say it is unacceptable.  I am looking for proof that this the way it is from some kind of official source, or a way to...

Connection to Iseries for multiple users V5R4

Have shared computer and need to make connection to iseries that works for each user that logs onto the system without having to make same connection manually for each user. Software/Hardware used: Client Express V5R4