• 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:
  • Excel Dashboard from AS/400 reports

    A client has asked me to populate an Excel sheet with reports generated from an AS/400 system. Currently these reports are entered manually 1-2 times a day. What I want to do is pull the data directly from the AS/400 system rather than having it run the report, but I'm not sure where I would start...

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

    bharathtata25 pointsBadges:
  • Spool files are not reaching Xerox printer using AS/400

    My spool files not reaching the Xerox 9302 using AS/400. What is the cause?

    JNodawar5 pointsBadges:
  • Restricted state Full System Backup using BRMS

    Where do I need to specify that I do not want it to bring up any subsystems after the backup has completed?

    SusanDeRocher5 pointsBadges:
  • Memory utilization by Job/Subsystem in AS/400

    I want to check how much memory utilizing by a job or subsystem in iSeries. I want to do it manually without using iSeries Navigator.

    daudn198615 pointsBadges:
  • Touch Screen Programming in iSeries

    Hi Folks, Can anyone give some pointers on touch sensitive screen programming or where I could get some info and guidance? I have seen these being used at supermarket checkouts but not in business applications.  Are there any restrictions to these being used in business applications (iSeries)?...

    tjgm88995 pointsBadges:
  • How to set proper TCP buffer size?

    Hi, We have 3 AS/400 systems PR, HA (Both are on same physical location) & DR (situated in different physical location around 1000 KM away from PR system). All the three systems are in sync using MIMIX Global. We had 100 mbps WAN link configured for PR to DR replication. PR & HA replication...

    Ketan19305 pointsBadges:
  • How to exit RTF

    How do I get out of RTF?

    whiteside2935 pointsBadges:
  • AS/400 robot scheduler

    Robot Scheduler temp license applied and a job that was started in the robot scheduler continues to run. Cannot stop job.

    SHouseal15 pointsBadges:
  • Dynamic SQL in RPGLE

    I am building a dynamic SQL in RPGLE with a wildcards. It does not work like a native SQL statement. A search for "FRANK" will search on 6 characters (retrieve all the FRANK and the FRANKL, but not the FRANKLIN). A search on "FRANKL" will retrieve the FRANKL and the FRANKLIN. Any help would be...

    davidgrant10 pointsBadges:
  • AS/400: How to perform IPL?

    What are the basic steps to perform IPL in AS/400?

    Karthik20845 pointsBadges:
  • Logical file DDS change

    Hello all, if I change a logical dds and recompile it only with the physical. Do I need to recompile the program, because I check the program has the same file level identifier as that of newly compiled logical.

    koolsid78625 pointsBadges:
  • Logical file source

    If we have object of logical file, how can I find the source wrt object?

    koolsid78625 pointsBadges:
  • AS/400: How to remove and validate default password and limit capability parameter

    How do I remove / change and validate default password, limit capability parameter?

    yaminirosy5 pointsBadges:
  • Is it possible to get a PDF from AS400 spool file?

    Is this possible? Is it really possible to get a PDF from spool file? Nothing seems to work. :-( I was trying to convert PDF in iSeries Navigator. I put a spool file, right click, convert to pdf, asks me whether I want a new printer, I say yes, starts a printer then a writer but then everything...

    Avrelivs80 pointsBadges:
  • 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:

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