AS/400
How can we remove the two years back data from our table? We don’t have any time stamp in a table. Please let me know the process to achieve it. Thanks, Ravula

Answer Question   |  March 19, 2013  7:48 AM
AS/400, AS/400 tables

Link Tables in AS400 to SQL Server 2008
Has anyone set up a link server to their AS400 from SQL Server 2008/5?

Answer Question   |  May 3, 2011  10:34 PM
AS/400 tables, AS/400 to SQL Server 2008, AS400 Data Definitions, SQL Server 2008

AS400 – Queries
Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by [...]

Answer Question   |  July 15, 2011  10:37 AM
AS/400 queries, AS/400 Query, AS/400 tables, AS400 -WRKQRY

AS400 – Tables (object *file has a pending change)
When I run the Script to Alter the table, it shows the below error message.(script is – ALTER TABLE……) Error Message : Object * file has a pending change. I checked the file that it is locked, but no locks. Could you please let me know the solution to overcome this error and to run [...]

Answer Question   |  September 15, 2010  10:01 AM
AS/400 error messages, AS/400 objects, AS/400 tables, AS400 file changes

Enherit column attributes when ALTERing column
I have this: 1. A field-reference table (fieldref): CREATE TABLE mylib/fieldref ( A CHAR (10) NOT NULL WITH DEFAULT, B CHAR (10) NOT NULL WITH DEFAULT, C DECIMAL (7 , 5) NOT NULL WITH DEFAULT, PRIMARY KEY (A)) 2. A data table (myfile) created on the basis of the above fieldref table: CREATE TABLE mylib/myfile [...]

Answer Question   |  August 30, 2010  8:21 PM
AS/400 DB2, AS/400 tables, OSV6R1, SQL, V6R1

Use of Alternate Table/Array Name?
Whats the use of use of Alternate Table/Array Name when defining a table/array in E Spec?

Answer Question   |  September 14, 2009  11:46 AM
AS/400 Arrays, AS/400 tables

Sequenced Records
In one of our tables there is a sub-table that keeps records based on sequence numbers. These numbers vary from record to record. Is there any logic statements within as400 queries that will tell it to just pick the most recent and Active sub-record for each record? Any help you can give would be great!

Answer Question   |  May 22, 2009  7:56 PM
AS/400, AS/400 Records, AS/400 Sequenced Records, AS/400 tables

Tracking sensitive table access
How can I track the number of Read’s users perform on specific tables on an iSeries?

Answer Question   |  May 10, 2009  4:30 PM
AS/400 journaling, AS/400 tables, PCI DSS

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

Using SSIS to populate SQL Server Data Warehouse
I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?

Answer Question   |  March 12, 2009  2:33 PM
AS/400 tables, SQL Server tables, SSIS