iSeries database Questions


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
asked by:
1,185 pts.

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
asked by:
70 pts.

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
asked by:
5 pts.

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
asked by:
225 pts.

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
asked by:
2,480 pts.

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
asked by:
120 pts.

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
asked by:
465 pts.

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
asked by:
50 pts.

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
asked by:
5 pts.

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
asked by:
415 pts.

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
asked by:
385 pts.

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
asked by:
35 pts.

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
asked by:
5 pts.

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
asked by:
20 pts.

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
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
320 pts.

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
asked by:
20 pts.

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
asked by:
2,480 pts.

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
asked by:
40 pts.