• 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:
  • 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?

    davidgrant10 pointsBadges:
  • Uploading .CSV spread sheet to AS/400

    When saving an excel spread sheet to .CSV, the numbers in the columns will look like this 1E+13 no matter how I format the file.

    UARTJ125 pointsBadges:
  • How can I find to what program my iSeries Module was bound?

    I am trying to clean up a system (new contract) worst control of source that I have ever seen, buy I digress. My question is, If I have a module object on the iSeries, how do I find what program the module was bound?

    SicRob5 pointsBadges:
  • Turn off AS/400 notification

    At the bottom of the screen it says: The cursor is on row 3 column 23. Input is not inhibited. Insert mode is off Caps lock is off. 3270 numeric lock is off. How do I get rid of this?

    babydoll15 pointsBadges:
  • How to get details of all invalid login attempts by a user in AS/400

    I have a user profile whose invalid login attempts count in a day which is stored in the user profile does not match the logins recorded in DSPLOG for that day. How can i get details of all the invalid logins attempted by the user. Apart from DSPLOG is there anywhere else this is recorded and can...

    JohnsonMumbai1,360 pointsBadges:
  • SQL on multi-membered file without overriding

    How to query on a file and retrieve data from any of the members of the file without overriding to any of them?

    vishwaraja5 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