Rebuilding Logical Files
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
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
whats are the contents of a databse fields after the record is written
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 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 not a programmer
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
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
Is a DB on AS400 always DB2 ?
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
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
Packed Data
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
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
Maximum number of records that can be stored
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
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
How to Determine Database Access on AS/400
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
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
DB2/400
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
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
Native database implementation on AS/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
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
How to get the row count of a PF with RPG ILE?
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, 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
Converting to .txt
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
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
Reading a database file via RPG program
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
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
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
Answer Question
| December 15, 2008 4:54 PM
AS/400 database, AS/400 DB2, iSeries database, iSeries DB2, iSeries Navigator, SQL scripts, V5R4
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
How can we automate the DB2/400 used in AS/400 through QTP?
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
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
ODBC in AS/400, OS/400, System i, i5/OS
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
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
RPG/400
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
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
Grouping the records in RPG
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
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
Nested Selects
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
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
Incremental Materialized View
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
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?
How to determine the number of workstations defined in an As400?
Answer Question
| August 14, 2008 7:17 PM
AS/400 database, Workstations
How to determine the number of workstations defined in an As400?
Answer Question
| August 14, 2008 7:17 PM
AS/400 database, Workstations
