1
  • Link Tables in AS400 to SQL Server 2008

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

    Jaymz69765 pointsBadges:
  • Remove back data from AS/400 table

    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.

    ravula700 pointsBadges:
  • 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 changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
  • 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 the Alter...

    As400pgmmer305 pointsBadges:
  • 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...

    DanTheDane2,555 pointsBadges:
  • Use of Alternate Table/Array Name?

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

    Kar425 pointsBadges:
  • 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...

    JMarks224815 pointsBadges:
  • Tracking sensitive table access

    How can I track the number of Read's users perform on specific tables on an iSeries?

    LarryH6015 pointsBadges:
  • Maximum number of records that can be stored

    What is the Maximum number of records that can be stored on an as400 data file.

    JohnsonMumbai1,160 pointsBadges:
  • 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?

    RodVerity20 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following