Update Data SQL Server From AS400

5 pts.
Tags:
AS/400 SQL
RPGLE
SQL Database
SQL Server
Hi, some help me.

I want to write data to SQL Server from AS400 in RPGLE.

Some have code for make this.

Thanks for advance.

ASKED: August 5, 2011  5:16 PM
UPDATED: October 16, 2013  2:12 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Do you mean writing into database by using Sql Queries.
If yes, You can do it by using SQLRPGLE.

Piece of code will be like this

C/EXEC SQL
C+ INSERT INTO FILE1 ..
C/END-EXEC

You can use normal SQL Query for inserting data into Database File.

Pradeep.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • TomLiotta
    Most likely it's not going to be done with RPG unless you purchase a product that enables. it. The probable direction will be to have your RPG call Java procedures that can use the Microsoft JDBC Driver for SQL Server. I'm not aware of any other driver that Microsoft makes available nowadays, though they might have an alternative at a significant cost. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    ...any other driver that Microsoft makes available nowadays... That is, Microsoft doesn't make alternative drivers available that they have compiled to run on the AS/400 series of systems. Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    But pulling from the AS/400 over the AS/400 odbc driver to SQL server is a cake walk. Phil
    48,575 pointsBadges:
    report
  • TomLiotta

    Do you mean writing into database by using Sql Queries.

    No, that wouldn't be what is meant. The question asks about "SQL Server", not DB2.

    Tom

    125,585 pointsBadges:
    report

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