Rexx - Insert Operation

It is required when you want to create your records into a database table.

The following example will insert a record in the employee table.

Example

/* Main program */ 
Call RxFuncAdd 'SQLLoadFuncs', 'rexxsql', 'SQLLoadFuncs' 
Call SQLLoadFuncs 

if SQLConnect(c1,'testuser','test123','testdb') == 0 then say 'Connect Succedded' 
if SQLCommand(u1,"use testdb") == 0 then say 'Changed database to testdb' 
   sqlstr = "INSERT INTO employee(first_name,last_name,age,sex,income) values 
   ('Mac','Mohan',20,'M',2000)" 

say SQLCommand(c2,sqlstr) 

if you look into the MySQL testDB database, you will see that the record has been inserted.

Kickstart Your Career

Get certified by completing the course

Get Started