writing SQL queries in db2 database

Question

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

Try something, start with their documentation, and if you get stuck, then come back here with a more focused question. — Tim Biegeleisen
– Tim Biegeleisen, Commented Mar 26, 2018 at 7:46

MandyShaw · Accepted Answer · 2018-04-25 19:20:25Z

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.

answered Apr 25, 2018 at 19:20

MandyShaw

1,1653 gold badges15 silver badges31 bronze badges

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

Comments

danny117 · Accepted Answer · 2018-03-26 16:45:42Z

-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.

answered Mar 26, 2018 at 16:45

danny117

5,6511 gold badge29 silver badges36 bronze badges

Collectives™ on Stack Overflow

writing SQL queries in db2 database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related