• CPYFRMIMPF command successfully copies to PF but resulted to special characters on PF

    I have created new directory in AS/400 named MMVRADIR with subfolder MMVRAFLR. I have a CL program using CPYFRMIMPF command to restore the content of a txt file inside "MMVRADIR/MMVRAFLR/APDM082716.TXT" to AS/400 physical file SMREB33F. The CPYFRMIMPF was able to copy the contents but when I runqry...

    KAILOFOXS5 pointsBadges:
  • OPENQRYF: Unmonitored message CPF9899 occurred at statement

    Hi All I had made the changes in the program and debug the same but while debugging it gives me the following message at open query file line as: Unmonitored message CPF9899 occurred at statement. OPNQRYF FILE((F60SLB05)) QRYSLT('YTAN8 *EQ ' *CAT + &EMP *CAT ' *AND YTATIM *GT &STARTDATE +...

    Anshul14095 pointsBadges:
  • Modify QINACTITV to a limited number of users

    Sir, how do you configure a limited number of users where the objective is that the session of these users will not automatically sign-off. Because the way i understand it, this is done using WRKSYSVAL SYSVAL(QINACTITV) but this approach will affect all users and this is not what i intend to do. i...

    danmd5systemad370 pointsBadges:
  • Use of CCSID in AS/400?

    What is the use of CCSID in AS/400 Physical File? How it is important? What are the considered/configured to be noted when we develop web application in AS/400 with native DB2 database?

    Sureyz2,735 pointsBadges:
  • AS/400 display program message

    I am seeing this message from a lot of my users when they try and access the routing application within the AS/400. It has 4 options to answer the message but none seem to do anything. The exact wording is" Job 408069/ED/QPADEV0160 started pm 7/25/16 at 08:46:10 in subsystem QINTER Message queue Ed...

    whaline5 pointsBadges:
  • RPGLE validation

    How can I do a validation like first 3 words character and next 5 must be number in RPGLE?

    Vishalsuryavanshi15 pointsBadges:
  • Converting Float to packed

    I am trying to convert a Float8 to a 17 6 Packed and I am loosing 1/100000th of the value of the decimal portion. The packed result is 1/100000th less than the Float value. How do I stop this from happening? I am calculating taxes.

    Kcgto4550 pointsBadges:
  • iSeries sending emails to a group

    We would like to emails sent from the iSeries to a group when a job that runs at midnight unattended has an error message. How do we set this up?

    bwb1011115 pointsBadges:
  • How to end AS/400 session

    How do I end AS/400 session? DPI/GUI/JWALK - I can't log in cause sessions are running but I'm logged out.

    jacquelynnkane5 pointsBadges:
  • How DB2 converts the FLOAT value to IEEE floating-point format?

    I had created a SQL table as below: CREATE TABLE MYLIB/Mytable (FLD1 FLOAT (9) NOT NULL WITH DEFAULT) When I ran DSPFFD, I had seen that FLOAT(9) gets converted to 3F 2. So, I want to understand how does it happen? Which algorithm is being used?

    manojibmi5 pointsBadges:
  • How to get nth highest salary using SQL/400 query

    Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

    6r1,850 pointsBadges:
  • AS/400: How to check the list of source libraries inside a library?

    In AS/400, how do I check the list of source libraries inside a library?

    Ruchik15 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • AS/400 BPCS: How to get SKEEP code descriptions

    I am trying to find a report that extracts all Skeep codes with their respective descriptions in a report. Skeep codes are also known as "IREF05". Does anyone know how to extract this information from BPCS? Thanks!

    kchafe5 pointsBadges:
  • If an account has \’Initial Program\’ =*NONE and \’Initial Menu\’=*SIGNOFF, the parameter \’Limited Capabilities\’ is not relevant. The account cannot be us

    If an account has 'Initial Program' =*NONE and 'Initial Menu'=*SIGNOFF, the parameter 'Limited Capabilities' is not relevant. The account cannot be used on the command line. Is this true? What about if user is restricted to only one program? Could you elaborate on Initial menu and initial program,...

    aldc1235 pointsBadges:
  • Code for BI Publisher template

    In BI publisher, report should be populate in long name, for that I need code to insert in template RTF.

    zyngapoker5 pointsBadges:
  • Removing a Window without Re-Displaying the Underlying Record Format

    Program TST040 displays format Fm01Fmt. When the user presses F8 program TST041 is called, which displays a window and immediately returns to TST040 to continue processing (denoted by the Sleep function). After the “processing” completes, Fm01Fmt is redisplayed, removing the window from TST041....

    wbellis335 pointsBadges:
  • Where can I get an INFOPRINT 300dpi AFP print driver?

    I'm new to AFP and need to get set up with the proper AFP driver. I need the Generic INFOPRINT 300dpi AFP driver. Do you have a link I could try? Thank you.

    cher20165 pointsBadges:
  • The installation image can not locate any language resources

    The installation image can not locate any language resources. What can I do?

    JimTanaka400005 pointsBadges:
  • System i Navigator Error

    Good day, whenever I try to open System i Navigator I receive an error message, "cwbunnav.exe - Application Error". The application was unable to start correctly (0x000020c). Any help would be greatly appreciated.

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