What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?
Answer Question | May 27, 2009 4:57 PM
AS/400 database, AS/400 database administration, Database maintenance, iSeries, iSeries database, Logical File, Rebuilding Logical Files, Recompiling Logical Files
I have a field in a file eg. NewQueue. Once I write or update a record in the file that has field NewQueue, are the contents of that field still available for evaluation?
Answer Question | May 22, 2009 7:04 PM
AS/400 database, RPG, RPG Data Fields
I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.
Answer Question | May 7, 2009 7:26 PM
AS/400 Data Reports, AS/400 database, AS/400 import/export
Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely
Answer Question | November 24, 2010 3:25 PM
AS/400 database, DB2, RPG
How do I display a packed data field on the iSeries?
Answer Question | April 7, 2009 3:12 PM
AS/400 database, iSeries database, iSeries Packed Data Fields
What is the Maximum number of records that can be stored on an as400 data file.
Answer Question | March 30, 2009 12:19 PM
AS/400 Data File, AS/400 database, AS/400 Records, AS/400 tables
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.
Answer Question | March 8, 2009 3:36 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE
WHEN ACCESS PATH WILL BE CREATED AND WHEN OPEN DATA PATH WILL BE CREATED?
Answer Question | January 31, 2011 6:06 PM
AS/400 database, AS/400 DB2, DB2/400
Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.
Answer Question | December 23, 2008 2:32 AM
AS/400 database, AS/400 database administration, DB2, DB2/400, Open source databases
Hello, I’m looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
Answer Question | December 10, 2008 2:10 AM
AS/400 database, AS/400 development, PF/LF, Physical File, RPG, RPG ILE, RPGILE
Hello All, I’m trying to convert an AS400 database file to a .txt with pipe delimeter and I want to make the .txt file name a batch number. 0012345.txt Any help is greatly appreciated.
Answer Question | December 8, 2008 2:45 PM
AS/400, AS/400 database, AS/400 Database File, AS/400 Database to Text File
could anyone provide me with the codeline for reading a database file via RPG program
Answer Question | November 24, 2008 5:49 AM
AS/400 database, RPG, RPG/400
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
Answer Question | December 15, 2008 4:54 PM
AS/400 database, AS/400 DB2, iSeries database, iSeries DB2, iSeries Navigator, SQL scripts, V5R4
We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.
Answer Question | November 13, 2008 4:52 AM
AS/400 database, AS/400 testing, DB2/400, HP QuickTest Professional, QTP, QTP TE Add-in, QTP Terminal Emulator Add-in, QuickTest Professional
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
Answer Question | November 10, 2008 9:00 AM
AS/400 database, AS/400 database connectivity, i5/OS, Lotus Notes, ODBC, ODBC drivers, Open Database Connectivity, OS/400, System i
Hello ,how can we Migrate fromcurrently running on UNISYS platform to AS/400 platform. Major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database
Answer Question | November 3, 2008 2:02 PM
AS/400 database, AS/400 import/export, AS/400 migration, COBOL/400, DB2/400, RPG/400, Unisys DMSII
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a ‘SQL precompile failed’ error. How do I handle this?? And i have to display the employee records grouped by their locations… how can this be [...]
Answer Question | October 22, 2008 4:39 AM
AS/400 database, AS/400 development, AS/400 error messages, Embedded SQL, Report Program Generator, RPG, RPG/400, SQL precompile failed, SQL/400
A project I am working on requires that I do some stuff on a iSeries/AS400 DB (which I’m accessing through a linked server on a remote machine). I’m trying to build a query, but some of the AS400 syntax is giving me problems, and I was hoping that someone would be able to help me [...]
Answer Question | October 8, 2008 3:47 PM
AS/400 database, AS/400 Query, Nested selects
Can I create Materialized View in AS/400 iSeries, which I can refresh incrementally?
Answer Question | September 12, 2008 9:59 AM
AS/400 database, Materialized Views
How to determine the number of workstations defined in an As400?
Answer Question | August 14, 2008 7:17 PM
AS/400 database, Workstations