ISeries Database

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...

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...

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?

Packed Data

How do I display a packed data field on the iSeries?

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.

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

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 of these in iseries

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?

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.

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

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?

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

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?

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??

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...

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?

Ending ODBC Connections

I have several active ODBC connections throughout the day and I'm finding they sometimes lock objects during my Dayend so I want to cancel them just before the Dayend starts. Can someone tell me the cleanest method to end ODBC connections? I was going to try just ending the Qusrwrk sub-system but...

Bad date.

I'm using the "CPYTOIMPF" to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here's what it looks like.ñññòð÷