0

I'm new be to DB2/AS400. I know writing sql queries to insert/update in the database but not sure how could i perform same thing in DB2/AS400.Can any body guide me how could i write the sql insert/stored procedure queries in db2 database

Improve this question
2
  • 1
    Try something, start with their documentation, and if you get stuck, then come back here with a more focused question. Commented Mar 26, 2018 at 7:46
  • 2
    Exactly the same way you do it with any other SQL database. Commented Mar 26, 2018 at 12:54

2 Answers 2

Reset to default
2

STRSQL as suggested previously would work fine but it is a green screen (5250 emulation) option; if you are not familiar with that environment, I would recommend you use the 'Run SQL Script' function from either IBM i Access Client Solutions or IBM i Navigator, whichever is available to you.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

-1

On the AS400 command line issue the following command.

STRSQL

Start Here and this is typical IBM documentation. It leaves you guessing why am I here.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.