• What does “Job is not waiting for a specific message.” mean?

    My batch-job is most of the time in MSGW status, but when I take opt-7 against it it shows..."Job is not waiting for a specific message." What does it mean basically? I run EOD (End-Of-Day) job (i.e. my batch job), but these days it is taking much much longer time than usual. Please advice. Thanks...

    svankipu625 pointsBadges:
  • Audit Journal Entries AS/400

    Hi, I would like to trace the Audit entries for the event - *ATNEVT(IM) and *PGMADP(AP). I have included both auditing values in the CHGSECAUD command. Please suggest 1. In order to get those entries, what operation that I need to perfom? 2. And why this is missing in DSPAUDJRNE ** -- I have the...

    as400dev585 pointsBadges:
  • Message Subfile

    Hi, I am trying to implement message subfiles. But unable to process the code. Below is what my program does: 1. I have a Member Master (LMP001). I had built a Member maintenance Program which on calling shows the list of Members (Its a subfile) & corresponding fields. 2. When I take F9-Add on...

    juslikdat1440 pointsBadges:
  • How to increase the no. of records accomodated in a sequence no. field of 6-digit (Numeric Field) length?

    Dear all! My situation is..... I have a field (Sequence Number) which is a numeric-field (Len 6,0). Now the records this field can accommodate is limited/restricted to a maximum of 999999. This application has been running for years together now. Therefore the demand to accommodate maximum no. of...

    svankipu625 pointsBadges:
  • Move cursor to screen position in AS/400 macro

    Is it possible to move cursor to specific screen position in an AS/400 macro file (not VB)

    Willable15 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries.  Everything is going extremely well other than 2 files that I need to access use members.  These are the only ones that do on the entire system.  I was told that...

    mgrady15 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message: "[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)" Any idea what is missing? Thanks in...

    Antser5 pointsBadges:
  • Install iSeries on none IBM server

    Can we install iSeries or create iSeries partition on none IBM server?

    abar1570 pointsBadges:
  • Upgrade AS/400 SSL from 128-bit to 256-bit

    Kindly provide me assistance on how to perform the upgrading of AS/400 SSL Certification from 128-bit to 256-bit. Currently I'm connecting to AS/400 via client access running on SSL 128-bit.

    Puva12345 pointsBadges:
  • RUNSQLSTM and Excel

    Can an Excel spreadsheet be created with the runsqlstm?

    lewman5 pointsBadges:
  • Query

    Hi Team, I have scenario with me. For that I need to create a query. The scenario is as follows: When My Location And Department is equal in the file I want to Multiply Quantity Column with Cost Column and Add it. Loc Dept Quantity Cost 1 10 10 2 1 10 10 3 1 10 11 5 2 10 10 7 For above example in...

    ankit2002770 pointsBadges:
  • ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger555 pointsBadges:
  • Locked Records

    Is there an easy way to trap a Record Lock in RPGLE

    Doc135 pointsBadges:
  • RPGLE Record Lock Data

    I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.

    Doc135 pointsBadges:
  • AS400 subsystem listings

    Not too sure specifically how subsystems are listed in the AS/400. I know there are startup programs and subsystems need to be 'pointed' there in order to autostart? Questions is: Is there a way to list the current autostarted programs and how I can remove them. If there isn't a way to list what is...

    Gramicci65 pointsBadges:
  • AS/400 opcodes

    What is the difference between LOOKUP and XFOOT opcodes? Where can we use these opcodes?

    Icc10 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN200056,155 pointsBadges:
  • How do I check members list for a specific user group in iSeries (AS/400)

    What is the command to request system to list out member of a particular group profile with the assumption that my user ID is just a normal user ID (without SECADM function). Please help.

    Grpprfmbr20 pointsBadges:
  • French accent

    Hi everyone, SAP put a flat file in an AS/400 folder. The format is .csv (with UTF8 specification). When I use the command FTP in AS/400 to get it (User,passw,cd,get.....), every french accent is garbage. I changed the CCSD file, but nothing. I really need help.

    hewitt10 pointsBadges:
  • Convert C Prototypes to RPG

    I need to interface our payroll progam to Vertex Q Series payroll tax software. Vertex is written in C and our payroll programs are in RPGLE. Does anyone know what the RPG prototype to this function would be? PREFIX tVprtConn POSTFIX VprtOpenPRT (char *pDataSource, char *pServerName, char *pUserID,...

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