What is the best why to get started in DBA
I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self [...]
Answer Question
| March 31, 2012 11:00 AM
Access, DBA training, iSeries database, SQL
I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self [...]
Answer Question
| March 31, 2012 11:00 AM
Access, DBA training, iSeries database, SQL
CPYFRMIMPF error
I am using the CPYFRMIMPF to copy data from a TXT file into a DB file. The delimiter is a ‘]’ character. The command runs but no records are copied. The error says “0 records copied from member TXT. Copy command ended because of error”. Upon further review I found “The copy did not complete [...]
Answer Question
| March 31, 2012 9:16 PM
CPYFRMIMPF, iSeries database, OS/400, V5R4
I am using the CPYFRMIMPF to copy data from a TXT file into a DB file. The delimiter is a ‘]’ character. The command runs but no records are copied. The error says “0 records copied from member TXT. Copy command ended because of error”. Upon further review I found “The copy did not complete [...]
Answer Question
| March 31, 2012 9:16 PM
CPYFRMIMPF, iSeries database, OS/400, V5R4
iSeries Exit Point for ALL file member changes
I’m looking for an exit point that lets me capture changes to files (not the data in the files). I want to know when the following occur, regardless of the source of the change (ODBC / FTP / Cmd /CL / SEU / PDM / Navigator / SQL / …) member added / renamed / deleted [...]
Answer Question
| February 8, 2011 1:40 PM
AS/400 Exit Points, iSeries administration, iSeries database, V5R4
I’m looking for an exit point that lets me capture changes to files (not the data in the files). I want to know when the following occur, regardless of the source of the change (ODBC / FTP / Cmd /CL / SEU / PDM / Navigator / SQL / …) member added / renamed / deleted [...]
Answer Question
| February 8, 2011 1:40 PM
AS/400 Exit Points, iSeries administration, iSeries database, V5R4
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 does [...]
Answer Question
| November 9, 2011 12:00 AM
iSeries database, iSeries Navigator, V5R4, V5R4M5
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 does [...]
Answer Question
| November 9, 2011 12:00 AM
iSeries database, iSeries Navigator, V5R4, V5R4M5
Member Level ID
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and Views. The issue is that [...]
Answer Question
| October 26, 2009 3:43 PM
AS/400 database, AS/400 development, iSeries database
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and Views. The issue is that [...]
Answer Question
| October 26, 2009 3:43 PM
AS/400 database, AS/400 development, iSeries database
What causes the last used date to be updated on a file?
I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is [...]
Answer Question
| May 29, 2009 5:36 PM
AS/400 database, AS/400 Library, DSPOBJD, iSeries database
I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is [...]
Answer Question
| May 29, 2009 5:36 PM
AS/400 database, AS/400 Library, DSPOBJD, iSeries database
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
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
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
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
Special character in a PF
Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any [...]
Answer Question
| September 3, 2010 10:49 PM
Database, iSeries, iSeries database, PF/LF, Physical File
Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any [...]
Answer Question
| September 3, 2010 10:49 PM
Database, iSeries, iSeries database, PF/LF, Physical File
job QZDASOINIT
My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?
Answer Question
| September 27, 2010 5:40 AM
DB2/400, iSeries database, ODBC, QZDASOINIT
My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?
Answer Question
| September 27, 2010 5:40 AM
DB2/400, iSeries database, ODBC, QZDASOINIT
Giving Permission
Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.
Answer Question
| May 21, 2008 6:46 AM
AS/400 DB2, DB2, iSeries database
Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.
Answer Question
| May 21, 2008 6:46 AM
AS/400 DB2, DB2, iSeries database
SAVF listing
Does anyone know of a way to get a file with savf files only in it? I am trying to get a file so I can query it to see if I have any old save files on my iSeries
Answer Question
| May 13, 2008 9:46 PM
iSeries application development tools, iSeries database, SAVF
Does anyone know of a way to get a file with savf files only in it? I am trying to get a file so I can query it to see if I have any old save files on my iSeries
Answer Question
| May 13, 2008 9:46 PM
iSeries application development tools, iSeries database, SAVF
How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess
We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?
Answer Question
| April 19, 2010 1:23 AM
AS/400 DB2, iSeries Access, iSeries database
We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?
Answer Question
| April 19, 2010 1:23 AM
AS/400 DB2, iSeries Access, iSeries database
Deactivate Transfer Data To iSeries in EXCEL
How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel
Answer Question
| April 1, 2008 7:11 PM
iSeries database, Microsoft Excel
How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel
Answer Question
| April 1, 2008 7:11 PM
iSeries database, Microsoft Excel
SQL multiple files
On our iSeries I need to find out if fld01 or fld02 or fld03 in file “C” contains a value that is obtained from file “B” using a value from file “A”. How would I do this using SQL?
Answer Question
| March 18, 2008 5:04 PM
iSeries database, iSeries development, SQL
On our iSeries I need to find out if fld01 or fld02 or fld03 in file “C” contains a value that is obtained from file “B” using a value from file “A”. How would I do this using SQL?
Answer Question
| March 18, 2008 5:04 PM
iSeries database, iSeries development, SQL
DB2 to Text File Conversion and Transfer
I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??
Answer Question
| March 3, 2008 2:50 PM
AS/400 DB2, DB2, DB2 Implementation, iSeries database
I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??
Answer Question
| March 3, 2008 2:50 PM
AS/400 DB2, DB2, DB2 Implementation, iSeries database
Transferring data from 1 iSeries to another
We have 2 iSeries Servers, 1 for Production, 1 for Development. I have been asked to refresh our production data libraries on our Development System on a regular basis. My thought is to create a Save File of the data libraries on our Production System then FTP the Save File to our Development System and [...]
Answer Question
| January 24, 2008 8:11 PM
iSeries, iSeries database, iSeries networking
We have 2 iSeries Servers, 1 for Production, 1 for Development. I have been asked to refresh our production data libraries on our Development System on a regular basis. My thought is to create a Save File of the data libraries on our Production System then FTP the Save File to our Development System and [...]
Answer Question
| January 24, 2008 8:11 PM
iSeries, iSeries database, iSeries networking
transferring data from iSeries to Excel 2007
Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?
Answer Question
| February 24, 2009 3:32 PM
Excel 2007, iSeries Access, iSeries database
Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?
Answer Question
| February 24, 2009 3:32 PM
Excel 2007, iSeries Access, iSeries database
