Is it possible for the monitor jobs to start automatically
Is it possible for the monitor jobs to start automatically after ipl. We need to manually start the monitor jobs after every IPL. We have setup few monitor jobs under iseries navigator.  

Answer Question   |  March 23, 2010  7:34 AM
AS/400 Message Monitoring, iSeries Navigator, Monitoring

Query Calculation Part of Select Criteria
This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled – no dividing by two. How do I add this to my query? Thank you, SELECT “T16.CPRP”.CP_DISTRICT_CODE, SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS TOWN , SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS [...]

Answer Question   |  January 29, 2010  3:00 PM
iSeries Navigator, Query Calculation, SQL, Sql Script

Token Error in iSeries Navigator
Help – what’s wrong with my query: (Getting Token Error, From Into Clause) SELECT DISTINCT “T16.CPRP”.CP_TOWNSHIP, “T16.CBL”.CB_INTEREST_CITY MINUS (“T16.CBL”.CB_TAXCOLL * .03) AS Interest, SUM (“T16.CTDT”.TD_DETAIL_AMT_01) as Payments FROM QS36F.”T16.CPRP” AS “T16.CPRP”, QS36F.”T16.CBL” AS “T16.CBL”, QS36F.”T16.CTDT” AS “T16.CTDT” WHERE “T16.CPRP”.CP_YEAR = “T16.CBL”.CB_YEAR AND “T16.CPRP”.CP_TAXBILL_NO = “T16.CBL”.CB_TAXBILL_NO AND “T16.CPRP.CP_ROLL_TYPE = “T16.CBL”.CB_ROLL_TYPE AND “T16.CBL”.CB_YEAR = “T16.CTDT”.TD_YEAR AND “T16.CBL_TAXBILL_NO [...]

Answer Question   |  January 21, 2010  8:18 PM
AS/400 error messages, iSeries Navigator

iSeries Token Error
Need help with this query – it will not run token error.  Here is the query: SELECT   SUM  (“T16.CTDT”.TD_DETAIL_AMT_01 * .10) AS TOTAL, “T16.CPRP”.CP_DISTRICT_CODE

Answer Question   |  January 15, 2010  5:12 PM
iSeries, iSeries Navigator, Query, Token Error

I-series Navigator Database access
I have Client access loaded on my Laptop and have recently loaded the Database facility into Navigator. It loaded okay with no errors, Client Access is V5R4M0 and the I-series is V5R4M5. My Problem is that when I go into Navigator and connect to the I-series and try to expand the database tree it does [...]

Answer Question   |  November 9, 2011  12:00 AM
iSeries database, iSeries Navigator, V5R4, V5R4M5

iSeries Navigator Tool
Hi, I am new to i Series Navigator Tool. Please can anyone suggest me a Video/WBT for for this. Many Thanks  

Answer Question   |  December 9, 2009  10:13 AM
iSeries Navigator

iSeries Navigator message monitor failing on endpoint system
After years of working very well, iSeries Nagivator (Ops Nav) refuses to monitor messags on an endpoint iSeries.  This is a recent development.  Its been working just fine on the endpoint in question for the last 3+ years.  The QYPSJSVR job log shows CPFB904 and CPFB905.  Both are running V5R4 and iSeries Nav is current.  Has [...]

Answer Question   |  October 23, 2009  10:41 PM
CPFB905, i520, IBM System i 520, iNav, iSeries Navigator, V5R4

missing Host Application
I am manage several LPAR under OS/400 V5R4M0, at least three of them were created with restore from other one. In those LPARs I can see QIBM_EJB_PRODUCT tree into Host Applications option of Application Administration in iSeries Navigator. The original LPAR have it. The question is, how can I recovery that Host Application?

Answer Question   |  October 7, 2009  9:57 PM
AS/400 administration, iSeries Navigator, iSeries Navigator 5.x, LPAR, V5R4

Convert to PDF
Please guide on how do we use Convert to PDF from i series navigator. We are on V5R4. Need the steps to be followed in order to convert a spool file to a pdf. What needs to be done in order to save it to a location on the PC.      

Answer Question   |  May 29, 2012  10:39 AM
AS/400 PDF, AS/400 Spooled Files, iSeries Navigator, PDF conversion, System i, V5R4

iSeries Navigator printed output
I can view my spool files on the iSeries using the wrksplf command, but not thru iSeriece Navigator. When I click on Printed Output the panel is blank. When I right-click on Printed Output and select Customize this view, all options except Auto Refresh are grayed-out.

Answer Question   |  September 30, 2009  1:18 AM
AS/400 printing, iSeries Navigator

UPDATE a year from an ISO date field using SQL
Dear Sir/Madam, How can I update the year from a date field. For example the date file contains ’2008-12-31′ and I would like to use I-Series navigator’s SQL to update the date field above with ’2007-11-31′.But my intention for the update here is to decrease/deduct the year by 1 year and the month by 1 [...]

Answer Question   |  August 25, 2009  9:33 AM
AS/400 SQL, iSeries Navigator, ISO files, SQL

Printer output not coming in iSeries Navigator
My Spools files generates by BPCS not showing in Printer Outputs of I-series Navigator. Plesae tell me the reason of this problem and give the solution how to resolve it.

Answer Question   |  August 19, 2009  6:11 AM
AS/400 printing, BPCS, iSeries Navigator

Difference between RMTCMD and REXEC
What are the major difference between RMTCMD and REXEC? I installed iSeries navigator in my PC and I am able to access both these commands.

Answer Question   |  July 31, 2009  3:44 PM
AS/400 commands, iSeries Navigator, REXEC, RMTCMD

Many jobs created with iSeries Nav collects inventory
Recently I installed iSeries Access service pak SI32972 on my PC. This includes updates to Navigator. Since the install, every time we collect inventory (fixes, users, etc) about 400 jobs are added to our iSeries. These jobs remain until we ENDTCPSVR *MGTC. These jobs also consume disk space which is released only when we ENDTCPSVR [...]

Answer Question   |  July 13, 2009  5:05 PM
AS/400 jobs, AS/400 prestart jobs, iSeries Access, iSeries Navigator

ISeries Navigator – changing installation language Spanish -to- English
iSeries Navigator v5r3 Installed and set up using spanish language. Needs to be switched to have user interface in English. How can one possibly do it without uninstalling it ?

Answer Question   |  August 5, 2009  4:10 PM
iSeries application development tools, iSeries Navigator, iSeries Navigator Installation

iSeries Navigator V5R3M0
Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ ‘I’) A ICTIPC COMP(EQ ’1′) How can I make this index using “a comparison value for fields” on Iseries Navigator ? Thanks Silvarb

Answer Question   |  June 23, 2009  3:39 AM
DDS, iSeries, iSeries Navigator, Logical File, V5R3

Database Issues – Trying to prove that something has to be done
Hello Everyone, I’m currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major changes happen, we won’t see [...]

Answer Question   |  September 20, 2010  2:16 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables

TABLE type not detecting in AS/400 Green Screen
hi, I created a table from i series navigator of type TABLE in lib XYZ. Now i want to see the object in AS/400 green screen. How do i see that Thanks Siddharth

Answer Question   |  April 16, 2009  10:38 AM
AS/400 administration, AS/400 green screen, iSeries Navigator

iSeries Navigator
how can i find how many and who are using the iSeries Navigator. can I use any exit program.

Answer Question   |  March 25, 2009  3:17 PM
iSeries Access, iSeries Navigator

Printer Output via iSeries Navigator
how can I know who use printer output via iSeries Nvigator. or can I play with wrkreginf.

Answer Question   |  March 20, 2009  9:08 AM
iSeries administration, iSeries Navigator, iSeries printer output, iSeries printing, Work with Registration Information, WRKREGINF