Database operations:
...
Select
...
env("CONSOLE","1");
select(so_mstr where so_domain = "10USA" and so_ship = "11C1000") {
console(so_mstr.so_nbr);
}
Update
...
env("CONSOLE","1");
select(so_mstr where so_domain = "10USA" and so_ship = "11C1000") {
so_mstr.so_cust = "NEWCUST";
update(so_mstr);
}
Insert
...
env("CONSOLE","1");
so_mstr.so_domain = "10USA";
so_mstr.so_nbr = "SO_0102202";
insert(so_mstr);