• Does anyone know of an AS400 based BOM software (standalone)?

    We currently have a in house grown BOM system. We would like to replace it with a standalone softe=ware (400 based of course)... Any suggestions? Thanks, John

    JAC260 pointsBadges:
  • select records from DB2 table that are not updated recently

    Is there a way to select records from a DB2 table that are not written/updated in last 2 years? This is for archiving purpose. From the data we cannot tell if the data is recent or not. We cannot rely on the RRN, old RRN records might have been updated recently. Purpose is to archive data which is...

    nishav95 pointsBadges:
  • How to distinguish an inactive and terminated user profiles in AS400

    When a user is no longer working in our company, the AS400 admin will disable the user profile. As per the company's procedure,it is not allowed to delete the user profile. As per current setup, user profiles also gets disabled when an user types in password wrongly 3 times, or when a user is not...

    nishav95 pointsBadges:
  • JOBQ and JOBD in AS/400

    What is the use of JOBQ and JOBD? What is the difference between JOBD and SBSD (Subsystem Description)? If we don't use the ADDJOBQE, where (in which subsystem) will the created JOBQ be stored?

    Sureyz2,880 pointsBadges:
  • Finding username that is trying to access system

    Hi folks, We just did a Help Systems security audit on our server and the report shows that the Largest number of Invalid Sign on Attempts on 1 profile is 78. However we don;t know what the user profile is. This has us alarmed, with so many attempted signons. Wondering how would I go about finding...

    djb38720 pointsBadges:
  • All inclusive list of Message ID’s with descriptions on iSeries

    Where can I download a list of all the Message ID's on the iSeries? For example I am looking for PQT0011 which is a printer error when I run a program?

    Stckrb10 pointsBadges:
  • AS400 system time and date.

    What is the command or procedure for changing the system as400 date. Please be very specific.

    jakeryan15 pointsBadges:
  • SQLRPGLE gets SQLCODE 08003

    I have an SQLRPGLE program running interactively, and i am intermittently getting 08003 The connection does not exist.SQLCODE -900. I am only accessing the local IBM i DB2 database. How does an SQLRPGLE connect to the IBM i databasese under wraps? Is it part of the /exec sql directive? Is there an...

    Jpjawili370 pointsBadges:
  • Open .MSG file on Mac OS X

    A co-worker just sent me a .MSG file (it's an attachment). I'm using a Mac OS X and I figure out how to open a file. I don't have any programs to open it. How can I open this?

    ITKE1,158,390 pointsBadges:
  • Arabic characters not displayed during SQL using IBM Navigator for i

    I have a table on the IBM i DB2/400 database, table CCSID is 420 = Arabic. My user profile is configured to CCSID 420 also. My 5250 green screen session is also configured to use CCSID 420 and my keyboard is configured to be able to enter Arabic characters. I enter Arabic characters on one of the...

    Jpjawili370 pointsBadges:
  • SAVOBJ command ended with CPA4036 – File expiration dates out of sequence

    We are processing Out Queue backup through SAVOBJ command which configured in CL program. Recently we included SAVOBJBRM command for the same CL and then we started to receive this error. we have configured SAVOBJ first and then SAVOBJBRM for same Outq. Is QSYS/QSYSTAP keeps last Expiration date...

    Anshan155 pointsBadges:
  • rtf image not printing

    image not printing in rtf document

    stevemalecki5 pointsBadges:
  • Convert MSG file types into PDF or Word doc

    Is there any way to convert these type files into a PDF or Word DOC, since the person receiving the file does not have MS outlook

    clifton125 pointsBadges:
  • If/Then Batch File for Username/Password Entry Pop-Up Window

    When starting AS400 for the first time every day it asks for an additional password via a small window titled "System i signon", however, I need to bypass this window. Long story short, I have an Excel file with a connection to AS400 that, when triggered, opens a hidden AS400 window, gathers data...

    zgadson55 pointsBadges:
  • Override not found at specified level

    My RPGLE pgm1 has following command - OVRDBF FILE(File1) TOFILE(&OVRLIB/File1) + WAITRCD(&LOCKWAIT) SECURE(*YES) + OVRSCOPE(*CALLLVL) SHARE(*NO) There are 7-8 programs called after this. The last program has below statement -DLTOVR FILE1This particular statement fails with the message...

    sri8707670 pointsBadges:
  • System i Navigator will not start

    System i Navigator will not start. My Event Viewer indicates that MSVCR80.DLL has errored out. I have already tried repairing and removing Client Access with no results. Here is the event data: Log Name: Application Source: Application Error Date: 8/19/2017 8:18:21 PM Event ID: 1000 Task Category:...

    DDEFILLIPO5 pointsBadges:
  • Changing the member type in a source file

    I have created a cobol source in QLBLLESRC in my library. But by mistake I created it as a text file by not entering the member type as "CBLLE". How can I change the member type now...thanks

    ten20081,150 pointsBadges:
  • Logical File error message

    I have encountered this error and didn't understand why it was coming. The error was: "Errors in DDS not allowed with specified GENLVL. " I checked with wrksplf command also but didn't help me either.

    Sangay635 pointsBadges:
  • method to decrypt AES128 in RPGLE

    Hi, How to decrypt AES128 in RPGLE

    6r2,920 pointsBadges:
  • STRQMQRY

    If you use a CLP to pass parameters to a STRQMQRY command. How do you disable prompting this command.

    sorella85 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