• How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688035 pointsBadges:
  • Logical files in mimix are in *HLDERR

    How to troubleshoot and resolve, if the logical files are *HLDERR status.

    Praveen195 pointsBadges:
  • How to see output for an AS/400 stored procedure

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • How to capture screen continuously for Rumba AS/400?

    I can capture each screen by clicking on option -> capture screen. Can I capture all displays or assign a short-cut key to capture the current screen?

    Wchang7215 pointsBadges:
  • Job Dependency across LPARS

    J1 scheduled to run in lpar - lets say L1 J2 scheduled to run in lpar - lets say L2 Here my requirement is J2 should start run after completion of J1. Can we make this dependency across the LPARS? I am using CA ESP tool to schedule the jobs.

    Manoranjani5 pointsBadges:
  • IBM DB2 Rows-Records Limits

    IBM DB2 allows up to a maximum of 4.2 Billon rows or records in a table. (In AS/400, iSeries). MS SQL, Sybase SQL, Oracle, MySQL all allow way more. We know that with clusters IBM can handle more, but this doesn’t solve the problem in many cases (Requires Embedded SQL)… DB2/400 was supposed to...

    Florenjm180 pointsBadges:
  • Running AS/400 query in Specific job queue

    Is there a way to restrict user(s) to submit their queries to a specific job queue instead of going into qbatch?

    Msatbh175 pointsBadges:
  • How does equal to operator work in RPGLE free format when v compare file field with constant value.

    I have a file field which has values 'X' or 'Y' and it is of 10 length. Chain f1:f2:f3 filename if %found filename if f4 = 'X' In free format RPGLE when I tried to compare it fails even though value of f4 is ' X' . Note: f4 is of 10length. Work around is trimming F4 before equating but I would...

    NicyChn135 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:
  • 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:
  • Creating shortcut commands in AS/400

    Hi, I want to create a shortcut command for wrkmbrpdm command in my AS/400 platform. i have done like this: 1. wrkmbrpdm libraryname/member name 2. Shift F4 3. Created a user - defined function (as w1 for wrkmbrpdm) But an error throws w1 not found in *libl . Please somebody can help me out on...

    Sangay635 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:

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