Post reply

creat a table on the iseries from sql 2008?

  • April 6, 2012 at 10:50 am

    #259500

    Is this possible?? I know to use insert,update, delete against an iseries table(through a linked server) the file on the iseries needs to be journaled. So how do I create a journaled table/file that will reside on my iseries

    from the sql server side?

    Thanks in advance!

  • April 6, 2012 at 11:52 am

    #1470205

    pduback (4/6/2012)

    Is this possible?? I know to use insert,update, delete against an iseries table(through a linked server) the file on the iseries needs to be journaled. So how do I create a journaled table/file that will reside on my iseries

    from the sql server side?

    I think you can do DDL using OPENQUERY()... provided you have the right privileges on the target database and you know the syntax of the target rdbms.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply