CODEWITHSUNDEEP
db2ibm-midrangedb2-400
Satish
Satish

Reputation: 49

writing SQL queries in db2 database

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

Upvotes: 0

Views: 545

Answers (2)

MandyShaw
MandyShaw

Reputation: 1156

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.

Upvotes: 2

danny117
danny117

Reputation: 5651

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.

Upvotes: -1

Related Questions