ISeries Questions and Answers

Recent IT Questions

1 - 20 of 455
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

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...

Answer Question   |  Nov 19 2009  11:09 PM GMT
SQLRPGLE, iSeries, SQL Cursors
asked by Dcantwell

  170 pts.

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

View Answer   |  Nov 17 2009  0:44 AM GMT
Physical Files, RPG, CL
asked by Sarapsm

  5 pts.

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...

Answer Question   |  Nov 13 2009  2:29 PM GMT
iSeries, AttachMent, IFS
asked by Streeter

  5 pts.

AS 400 software problem

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

View Answer   |  Nov 6 2009  5:27 PM GMT
AS/400, iSeries, WRKPRB
asked by Karens6

  5 pts.

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...

Answer Question   |  Nov 6 2009  3:02 PM GMT
iSeries, SQL, UDF Returning DATE
asked by RJonesPartrick

  15 pts.

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...

asked by Ten2008

  730 pts.

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...

View Answer   |  Nov 2 2009  6:04 PM GMT
DSPOBJD, iSeries, iSeries Storage
asked by Johnd01

  30 pts.

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:...

asked by Kar

  95 pts.

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

View Answer   |  Oct 21 2009  1:51 PM GMT
i5, iSeries, AS/400
asked by Yorkshireman

  3200 pts.

Tracking data changes on IBM i with triggers

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

View Answer   |  Oct 20 2009  3:00 PM GMT
iSeries, AS/400 triggers
asked by Ecuafruit

  5 pts.

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

View Answer   |  Oct 16 2009  2:19 PM GMT
ILE for iSeries, AS/400, iSeries
asked by Funny

  5 pts.

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...

View Answer   |  Oct 13 2009  3:19 PM GMT
iSeries, Data Transfer from iSeries
asked by KasMcc

  120 pts.

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

View Answer   |  Oct 12 2009  2:58 PM GMT
RPGLE, V5R4, iSeries
asked by Old2new

  25 pts.

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...

View Answer   |  Oct 9 2009  3:48 PM GMT
user profile, iSeries User Profiles, iSeries
asked by Choyle

  100 pts.

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...

View Answer   |  Oct 8 2009  7:45 PM GMT
iSeries, CPYFRMIMPF, CPYFRMPCD
asked by Brenry

  5 pts.

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...

View Answer   |  Oct 8 2009  10:39 AM GMT
AS/400, iSeries, i5
asked by Yorkshireman

  3200 pts.

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...

View Answer   |  Oct 6 2009  5:00 PM GMT
SMTP, iSeries, Lotus Notes Mailboxes
asked by GirlScout

  5 pts.

query/400

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

View Answer   |  Oct 6 2009  1:22 PM GMT
AS/400 database, iSeries
asked by Ten2008

  730 pts.

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...

View Answer   |  Oct 2 2009  7:21 PM GMT
AS/400, iSeries, Last modified
asked by Sodafountain

  25 pts.

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

View Answer   |  Sep 29 2009  3:47 PM GMT
iSeries, V5R4
asked by Computerchiksc

  5 pts.

1 - 20 of 455
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>