Stack Overflow
Stack Overflow

Questions tagged [iseries-navigator]

The iSeries Navigator (now known as "Navigator for i") is system management software made by IBM for their IBM i platform.

The Navigator for i family of products provide a comprehensive set of system management features for IBM i. Using rich graphical user interfaces, maintaining your IBM i has never been easier! Tasks included in the consoles cover everything from basic system’s control to DB2 for i database control and beyond.

Navigator for i is available in both a web-based console and as a Windows client. With either interface, all areas of the system are within your reach. Even optional products such as Domino, BRMS, High Availability, Advanced Job Scheduler and OmniFind are readily available and automatically “plugged in” when installed.

The web-based Systems Director Navigator for i console is the strategic interface for IBM i. Available since 6.1, using the web console is as simple as opening a web browser and pointing it to your IBM i system (at the 2001 port).

System i Navigator is the Windows client. It is packaged as part of the iAccess for Windows product. It is the more traditional systems management console, but continues to be supported and enhanced.

96 questions
5
votes
3 answers

DB2 - How to run an ad hoc select query with a parameter in IBM System i Access for Windows GUI Tool

I would like to run some ad hoc select statements in the IBM System I Navigator tool for DB2 using a variable that I declare. For example, in the SQL Server world I would easily do this in the SQL Server Management Studio query window like…
Ken Burkhardt
  • 3,528
  • 6
  • 33
  • 45
3
votes
1 answer

AS400 and System I Navigator

I'm new into AS400 and I got a job where I'm using AS400 and Powerlink (XA) to access and manage big ERP data. And I found a way to access the data through Excel VBA and SQL using the System I Nagivator tables. My problem is that I can't find the…
MrKen
  • 51
  • 1
  • 9
3
votes
1 answer

MySQL tables on iSeries / IBMDB2I

We are using the zendDBi database and are attempting to setup a MySQL table from an existing DB2 table. Using the method found here: http://wsip-174-79-32-155.ph.ph.cox.net/wiki/index.php/MySql/DB2StorageEngineDocument (in the section titled…
Cryptographic_ICE
  • 609
  • 7
  • 24
3
votes
3 answers

How to LEFT JOIN in DB2 iseries with first row?

I have need a query that JOIN a TABLE with A first row of other table value based: SELECT * FROM TABLEA A LEFT JOIN (SELECT * from TABLEB WHERE FIELD1 <> '3' and FIELD2 = 'D' AND A.CODE=CODE FETCH FIRST 1 ROW ONLY ) B on…
Daniele Grillo
  • 1,011
  • 4
  • 13
  • 31
2
votes
2 answers

How can i journal all my tables's schema in db2 iseries as/400?

I have created using system i navigator a jounral called abc in schema called TEST.Now i want to journal all the tables in my schema called mySchema how can i do that.I can only journal only one table.Is there any script to journal all the tables…
BenMansourNizar
  • 1,558
  • 4
  • 21
  • 42
2
votes
3 answers

Unique identifier for AS400 Database if there is no primary key / unique key / composite key defined?

Question: How to uniquely identify a record in AS400 database Detailed Question: I have AS400 database and some tables within it. Tables don't have primary key / unique key / composite key defined. Like oracle has concept of ROWID, in same way do we…
Seriously
  • 155
  • 5
2
votes
1 answer

Java: Connection class extending to login class

I'm practicing some java coding and I'm having some problems with the connection class extending to the login class. What I'm wanting to do is prompt the user to login with a username and password. The getUser() is going to store the username and…
HDWomack
  • 77
  • 9
2
votes
2 answers

IBM DB2 ON AS400

I want to configure IBM DB2 on iseries AS400. The issue is I'm not getting the proper tool for AS400 and I've already installed Data Studio for configure DB2. I don't have any knowledge regarding AS400 and I'm fresher for IBM technology. I have…
uvcreation
  • 91
  • 1
  • 9
2
votes
5 answers

How to add a not null constraint in an existing column in DB2 iSeries?

I have tried the following scripts to add a not null constraint to my column. ALTER TABLE MYDB.RULES ALTER TYPEID SET NOT NULL; ALTER TABLE MYDB.RULES ALTER COLUMN TYPEID SET NOT NULL; I also get this error when I execute it: Reason code 10. [SQL…
Loren
  • 1,260
  • 5
  • 16
  • 23
2
votes
1 answer

Concatenate Multiple Row Values into 1 Row, with SQL for iSeries

First, I need to thank Kent Milligan and his article at http://www.mcpressonline.com/sql/techtip-combining-multiple-row-values-into-a-single-row-with-sql-in-db2-for-i.html for getting me as far in this problem as I have. But now I need to expand on…
Andrew
  • 417
  • 5
  • 21
2
votes
4 answers

AS400 index configuration table

How can I view index of particular table in AS400? In which table index description of table is stored?
Swapnil Srivastav
  • 182
  • 2
  • 12
2
votes
1 answer

Using dynamic table name in db2

Currently in my project development need of generating the record count based on certain criteria where the table names are stored in separate table.For instance say xx table stores the table name under the column name is tableInfo. I've written the…
Anto
  • 57
  • 2
  • 10
2
votes
2 answers

db2_fetch_assoc() fails midway through iterating over result set

I'm running on IBM i (an AS/400) V7R2, PHP v5.6.5, Zend Server v8.0.2. I have a query which takes less than a second to execute from iNavigator. When I run the same query from a PHP script and then loop through it using: $numRows = 0; while ($row =…
d.lanza38
  • 2,525
  • 7
  • 30
  • 52
2
votes
2 answers

Implementing Java stored procedure IBM DB2 for i (AS400)

I created the Java stored procedure as follows, able to generate a .class file using AS400 Qshell command interpreter. import java.sql.*; public class sample { public sample(){ super(); } /** …
Anto
  • 57
  • 2
  • 10
2
votes
2 answers

AS400 iSeries Client Access multiple versions

We are running an AS400 v5r2 and I have iSeries Client access installed. Since v5r2 does not support a x64 ODBC driver does anyone know how I can either install two versions (v5r4 supports x64) of iSeries Client Access on the same box or just…
Steve Salowitz
  • 1,283
  • 1
  • 14
  • 28
1
2 3 4 5 6 7