IBM System i

3K

Solutions

1K

Contributors

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Related Topics

  1. Operating Systems
  2. DB2
  3. Mainframe Languages
  4. Mainframe OS
  5. Databases
  6. Microsoft SQL Server
  7. Query Syntax
  8. Printers and Scanners
  9. Programming
  10. Microsoft Access
Refine results

Is there a difference bwteen selecting rows in the WHERE clause on in the JOIN clause.

For example,

SELECT t2.*
  FROM orderHdr t1
  JOIN orderDtl  t2 on t2.orderno = t1.orderno
  WHERE …

411 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi Experts,

While using the QLIRLIBD API, I discover that some libraries take a lot of time (up to several minutes), while other libraries take a few seconds.
the size of the library an the number…

217 views

I have very simple code to check if the last entry of an email address is a '.' and if it is remove it. If multiple '.' are entered remove them all.

The issue is if my email address exceeds 30 …

222 views

I have installed Client Access (7.1) on our MS SQL 2014 server.  I am using the IBMDA400 OLE driver to create a linked server to DB2 database one the iSeries. When I run a select statement on the data…

852 views

I need to calculate a prorated amount of annual premium in free rpgle and account the number of days in leap years.

say a company's annual premium would be $1000 and they sign up on 11/01. I only …

627 views

We have a user who is having an issue with her messages not breaking to her screen for some reason.

Her user profile is set to *BREAK and I verified that her MSGQ is set to *BREAK.

Not sure what…

122 views

This is an ongoing project to sync Office Vision on a 610 (v4r5) to backup system a 170 (v4r4).

We did a full system save of the main system and restored it to the backup system, changed license …

324 views

Update: I'm trying to sync office vision email changes between to old systems for recovery purposes. Office vision is the only application running both systems:  active system is a 610 v4r5 and the …

538 views

Our developers have been creating a lot of SQL Stored Procedures lately.  When they are doing this - the default authority that is "granted" to the new object is basically *PUBLIC *USE and then *ALL …

327 views

Hi,
Our shop has not used journal until a couple months ago when I added them to a couple master files for audit trail purpose. So, my experience with journaling is very limited. I don’t mind …

848 views
Free Tool: SSL Checker
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

We have a few overlays layed out as an image file and the text prints on the white space in he middle before our logo and after footer text. And then that is saved as a .ovl file imported to the 400 …

326 views

Hello,
    We have an IBM iSeries / AS400 and a Zebra label printer currently setup on a PC in our factory. I know that there is a PC that runs a terminal window that we need to keep open in order to…

1253 views

Hi Experts,

I like to find the place where the iSeries backup (Go Backup) is storing the settings and calendar info.

337 views

Hi,

First, sorry I think I'm brain dead this morning.

I have a screen which needs French verbiage changes. I created the screen years ago, but for the life of me I can't remember (or correctly…

338 views

Hi Experts,

I followed This link (https://www.helpsystems.com/how-to-guides/robot/save-using-virtual-tape-save-data) to create a Virtual tape.
Now I try to create an Imagecatalog  CRTIMGCLG while …

243 views

We have a 3573-TL hooked up to an 8203 for testing, so it doesn't get used that much. Can I hook this Tape Drive up to a Windows Server 2008/2012 box and use it to backup my windows/mac Servers with …

359 views

Hi Experts,

In my RPG program I have the following parameters:
     DCL-PI *N;                  
       INPUT llikeDs(tmpl001);      
       OUTPUT likeDs(resp);
     end-pi;                  …

1255 views

I am attempting to use RUNRMTCMD to fire a visual basic script that uses Excel automation.  I want to open an excel file and saveas .csv and/or .pdf.  

I have gotten this to work while running the …

1286 views

I am configuring another as400 on our network - and soon our programmers will want to move objects in a save file from one system to another. can someone point me in the right direction on how to set …

351 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi,

We are still running Office Vision.  It is running on an old '610' and we have a '270' as a backup. This is the only thing running on both systems. Moving to Lotus Notes in the near future is …

1350 views

We are having issues running our BRMS backups to TSM since we recently upgraded our TSM server from v6.3.3 to v7.1.6.100

One of our contractors was helping us try to resolve the issues and asked us…

554 views

Hi All,
I have PDF file which has 2 page.
Question #1:
I am converting PDF file into overlay object with the extension ".prn" using "Generic Infoprint 300dpi AFP".
But problem is I am able convert…

8113 views

I am working on a project which allows users the ability to email reports from the iSeries to specific email addresses. The business does not enroll each user in the system directory (WRKDIRE). Is …

687 views

Hi Experts,

I created a Rest webservice on an iSeries server with Json In- and output data.

After processing the data, the requester get a response with an Error-level, Error-count  and a list …

160 views

We have a program called Speedweigh by a company called Varsity Logistics. What is supposed to happen is that when a box is placed on the WeighTronix 7880 the AS/400 is to populate the Varsity …

1867 views
Show more content
201506-LO-Top-001

IBM System i

3K

Solutions

1K

Contributors

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

Related Topics

  1. Operating Systems
  2. DB2
  3. Mainframe Languages
  4. Mainframe OS
  5. Databases
  6. Microsoft SQL Server
Top Experts In
IBM System i
<
Monthly
>