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

    RobertHart225 pointsBadges:
  • iSeries SQL ISNULL Equivalent

    What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

    Jaggerdude60 pointsBadges:
  • Create trigger using iSeries Navigator

    I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it be possible to have some example that I...

    Myhandle5405 pointsBadges:
  • 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...

    Dcantwell470 pointsBadges:
  • iSeries Navigator SQL Script Output

    I'm not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.

    Jaggerdude60 pointsBadges:
  • iSeries Navigator viewing AFP files

    I've been using iSeries navigator for some time now to view AFP files - click on the spool file, get to see the spool file and it's overlay together, works great, saves lots of printing. Of a sudden, about a week ago - it stopped working. Now when I double click on a spool file, all I get is a...

    Renojim145 pointsBadges:
  • Monitor the AS400

    I just found on the iSeries Navigator a way to monitor my Qbatch and Qinter for MSGW. But how can I monitor for when the AS400 goes down? Or at least no one would be able to log in. The QINTER is down...

    Jaymz69765 pointsBadges:
  • Monitor When QINTER is inactive

    What is a good way to moniter when QINTER is inactive? So if QINTER isn't up I need to know, since no one can log in at that point. I am using iSeries Navigator  VR5.4.0 THANKS

    Jaymz69765 pointsBadges:
  • System i Navigator connection error to Central Management System.

    I am getting an error message in System i Navigator when I try to connect to Central Management System. "Unable to complete the connection to central system `system name`". I am trying to retreive the System Operator Messages. Also under Basic Operations - Messages click on the bottom panel on View...

    Chabsta85 pointsBadges:
  • Iseries navigator

    I am recieving a cwbunnav.exe error when i attempt to logon to navigator. I have ver5 rel3.

    Diego20 pointsBadges:
  • unable to start management central

    I was trying to start management central using the command STRTCPSVR *MGTC as the job QYPSSRV under QSYSWRK was not running which is supposed to be the job for management central. But when I tried that, I got the error TCP1A10. however, when I start it using iseries navigator it shows as started,...

    Srinivas naikk115 pointsBadges:
  • 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.  

    JohnsonMumbai1,160 pointsBadges:
  • 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,...

    lorit365 pointsBadges:
  • 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...

    lorit365 pointsBadges:
  • 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

    lorit365 pointsBadges:
  • 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  

    Hugheswilliams345 pointsBadges:
  • external procedures

    I have an RPGLE program which I define to be external procedure so that I can call it from a .NET program. When I execute it from iseries it works fine ans returns the parameter requested filled properly. When I call it out AS400 it runs succesfully but with no results. The problem seems to be the...

    GTseli5 pointsBadges:
  • 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...

    WoodEngineer6,425 pointsBadges:
  • Users having Access to run DTF’s.

    Steps to generate report of List of Users having Access to Transfer Data from iSeries Server (DTF Access).

    Haaiderali215 pointsBadges:
  • 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...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following