• Get full data dictionary of DSPUSRPRF OUTFILE

    Where can I get a full "dictionary" of everything provided in the DSPUSERPRF OUTFILE for example fields such as UPPWEX, UPOBJA and UPINMN for example. I cannot find a data dictionary anywhere. Thanks!!!!

    surfettekw20 pointsBadges:
  • FTP from IFS to iSeries database line: Line break not recognized

    I am trying to FTP from IFS to a iSeries database file. The file gets transferred but the end of line is not getting recognized so only one record is created in the receiving file.

    ptrabe5 pointsBadges:
  • 21 SAVE IFS & DLO

    I am processing on an i5, 520, V6R1M0. How are the IFS & DLO folders being saved using 21 SAVE? Upgrading to a Power 8 and we want to be sure all information is backed up and properly restored to the new iSeries.

    NormS316920 pointsBadges:
  • Error Messages on AS/400

    Dear All, Friends i want to know how to show all error messeges using AS400. For example criticle messages, other messages. Regards, Tahir

    tahirliaqat1150 pointsBadges:
  • Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 pointsBadges:
  • Receiving CPP630C error message when trying to restore tape

    We are using 3592-J1A to restore client's back up tape. But when we are trying to restore the tape, we got CPP630C error ID and SRC63A09355 System reference code. What to do now? Thanks

    excellentrandy1,330 pointsBadges:
  • MKS implementer is not able to compile RPG program

    Before compile the RPG program need to create the temp file using CRTDUPOBJ. I created the Object and try to compile the PGM but the spool file showing error. Temp files not found. The program compiled in WRKMBRPDM but the same is not able to compile in MKS Implementer. Please help to sort out the...

    Progrmmer45 pointsBadges:
  • Turnover form IN-USE Status

    I was trying to promote a form over AS/400 turnover and my session got disconnected meanwhile. Its approved but not run yet. Due to the disconnection, I am not able to run the form now because the form is IN-USE status. What am I supposed to do now?

    yaazhisai260 pointsBadges:
  • Connect Excel to Rumba 8.2.0

    My company is using AS/400 Micro Focus Rumba 8.2.0 SP0. Every time we want to run a report we must spool file the query and send it to our email, then we import it into excel. but I wanted to know if we can directly connect Excel to Rumba.

    hoomansd5 pointsBadges:
  • AS400 – Queries

    Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
  • Uninstall MIMIX from iSeries

    I need to know the specific steps required to remove my MIMIX environments.  We have 6 MIMIX pairs, currently remote journaling to another system and are moving into a flash scenario. Eliminating MIMIX entirely. Thank you.

    maroche15 pointsBadges:
  • Find spool files in AS/400

    How do I find spool files in AS/400?

    CherylFloyd5 pointsBadges:
  • CPYFRMIMPF Error Code 2

    Hello, Can someone help me here? I'm trying to import data into a physical file using cpyfrmimpf and I keep getting error code 2 - The field A in the Field Definition File is not a field in the TOFILE. I've created the FDF from the physical file so the fields should be exactly the same. I'm trying...

    bp0144290 pointsBadges:
  • Determine if secondary language is installed correctly on iSeries (AS/400)

    After much searching, I have determined that the simple answer is no where to be found. I'm trying to determine how to trouble shoot when adding QSYS2924 to the library list doesn't work, what might be the problem. I have a client that has at least attempted to install English as the secondary...

    cooldht50 pointsBadges:
  • Clearing Message Queue in AS400?

    Hi All, Is there a way to clear the Messages from Message Queue datewise, consider i have messages for a 30 days and i want to delete the messages for  first 20 leaving messages for Last 10 days Kindly let me the is there a possible

    Msharbudeen50 pointsBadges:
  • Is there any default performance variations between Scheduled Job & Manually submitted job?

    I have a job. The job will be run everyday as a scheduled job. The job is taking just 3 to 7 minutes to complete it's run. If I submit the same job manually, it is taking more than 2 hours. I want to know the reason. Can any one help me on this? Note: Both jobs are having run priority as 50 &...

    Kirubaharan8915 pointsBadges:
  • OS/400 Logical file and object

    In OS/400, does a logical file has an object?

    rajat01110 pointsBadges:
  • RPG9032 file &5 contains a record not in sequence

    We get the message: RPG9032 file &5 contains a record not in sequence. What do we do?

    HansVerloop5 pointsBadges:
  • How to create PF without member

    Is it possible to create physical file without a member? If possible, please let me know method of creating PF.

    Sonis1212175 pointsBadges:
  • Mimix VSP application group

    When I check the Summary on my Mimix VSP everything is green and looks good except the Application group, this is blue and when I hover over it I get the message, "Resource Group has not been built". If everything appears to be working fine, what hasn't been built?

    dazkeyte55 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following