• 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,955 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:
  • 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.

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

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

    Singholia5 pointsBadges:
  • 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 ?

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

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

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

    Sangay635 pointsBadges:
  • Printer Output via iSeries Navigator

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

    Maltaf65 pointsBadges:
  • iNavigator hangs on SMTP properties

    We have an iSeries running v5r2 and the latest release of client access. I need to change the binding of SMTP and this appears to only be available by Navigator. However Navigator hangs when I click the properties on SMTP. Any other way that I can change this binding to a new ip address?

    FrankStacey105 pointsBadges:
  • Message Monitoring

    Is there a way through Iseries Navigator to setup monitoring for messages from Qsysopr. I do not sit at the console so I would need my monitor at my desk to do a break message when a message appears in Qsysopr queue. I have tried to setup the monitor view but it does not do a break message.

    TRFCTL20 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • mapping a drive to the As400

    We currently map drives to the as400, is anyone using a different and maybe easier method? I Series Navigator?

    Bwright0810 pointsBadges:
  • iSeries Navigator V5.4 automatically reset monitor triggers

    I have created a message monitor in ISeries Navigator V5.4 and I want to trigger a command whenever a message appears on the QSYSOPR log. The trigger command is working properly; however, the "Automatically reset after trigger command has run" does not work. How do I get the trigger to reset so...

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