IBM System i

3K

Solutions

2K

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. Microsoft Access
  10. Programming
Refine results

We have a remote system running V5R4 and our current server is running v7r2.  

We have a remote location entry setup for the old machine it works with TELNET.  I can access using 'TELNET OLDSYS' …

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

Hi Experts,

We have to add a Certificate (from a customers webshop) to the iSeries KeyStore.
I alleady have a *.cer file stored op the IFS, buth that is where my knowledge ends.

what are the …

131 views

Hi experts,

I try to get a list with abnormalities between object(source)date and source change date.

I think ANZUSROBJ would do the job, but when I start this, I get the error:
The call to …

1336 views

Hi Experts,

I have a DB2-400 table that contains a field of type 'G' (DBCS-Graphic data  30-pos) this field contains some text (some records chinese)
If I try to print this field I get all data …

825 views

HI,

We run BRMS nightly. Last night the tape failed. The snapshot was created. Is there a way to push this snapshot to tape so we don’t lose a backup?

Thank You,
Lynn

121 views

Hi,

We have a powerbuilder application which connects to AS400.

When it runs some AS400 cobol program through ODBC connection, I see in the job log with below error

226 views

Hello all,
As the title says I need to make a cronjob to check a remote ftp folder if a file exists. If so, it needs to email me. I have a Ubuntu web server I can use that is setup to email out and …

5104 views

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 …

450 views

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…

242 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 …

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

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…

8105 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 …

651 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…

148 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 …

353 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 …

569 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 …

353 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 …

888 views

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 …

346 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…

1274 views
Free Tool: Subnet Calculator
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hi Experts,

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

365 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…

364 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 …

271 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 …

391 views

Hi Experts,

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

1280 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 …

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

IBM System i

3K

Solutions

2K

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
>