• 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:
  • RPGLE validation

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

    Vishalsuryavanshi5 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 create monthly attendance report?

    TABLE I HAVE: Code Name AttendanceDate Status ---- ---- -------------- ------ A001 Abc Jan-01-2013 Present B001 Xyz Jan-01-2013 Present A001 Abc Jan-02-2013 Absent B001 Xyz Jan-02-2013 Late A001 Abc Jan-03-2013 Late Expecting below output with AVG attendance of month. Jan, 2013 Code Name 1 2 3 .....

    Sri100815 pointsBadges:
  • Data Queue initiation on AS/400

    What is the best way to send/receive a request via a data queue when data from an outside source is added to files on the AS/400? Physical file trigger added to one of the files?

    delraek25 pointsBadges:
  • Difference between source physical file and physical file on AS/400

    What is AS/400? Difference between source physical file and physical file?

    AS400 - Ask the Expert485 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:
  • Error message when creating a stored procedure: SPxxx is created but cannot be saved or restored

    I created a stored procedure on AS/400, the message in return was 'SPxxx is created but cannot be saved or restored '. I am able to view the created stored procedure in the Library but when I call the procedure the error message was 'SPxx was not found with specified parameters". How to resolve...

    bharathtata5 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:
  • Like in SQLRPGLE

    Hi, I am using the below query in SQLRPGLE Select count(data) into :cntrec from sample where data like '%' "+:tpnumber+" '%'. I am getting an error "Token "+:tpnmber+" was not valid" . The tpnumber is a character field(10a). Sample file is a flat file I even tried '%' +:tpnumber+" '%' and '%'...

    Prashanth123270 pointsBadges:
  • Dynamic SQL in RPGLE

    How can I build a dynamic SQL statement for input from a screen file?

    davidgrant5 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