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
View Answer
| May 12 2008 9:46 PM GMT
| asked by
Lost in Kansas
iSeries database, iSeries application development tools, 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?
View Answer
| Apr 3 2008 1:23 AM GMT
| asked by
ISHII
AS/400 DB2, iSeries database, iSeries Access
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
View Answer
| Mar 27 2008 7:11 PM GMT
| asked by
ESands
iSeries database, Microsoft Excel, 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?
View Answer
| Mar 17 2008 5:04 PM GMT
| asked by
Floyd02
SQL, iSeries development, iSeries database
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??
View Answer
| Mar 1 2008 2:50 PM GMT
| asked by
Gvdsswami
DB2 Implementation, AS/400 DB2, DB2
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...
View Answer
| Jan 23 2008 8:11 PM GMT
| asked by
Wpoulin
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?
View Answer
| Jan 17 2008 3:32 PM GMT
| asked by
Popers
iSeries Access, Excel 2007, iSeries database
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...
View Answer
| Dec 14 2007 4:28 PM GMT
| asked by
Alison883
ODBC on i5, ENDACTCNN, ENDHOSTSVR
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.ñññòð÷
View Answer
| Dec 14 2007 3:20 PM GMT
| asked by
Shelties
CPYTOIMPF, CSV, iSeries database


