I finally got connected to our AS400 using DB2Connect software from IBM, not sure why I need another product to do this but according to IBM I do, and our IBM guy says that isnt a stranger model for them to have. Oh well, moving on.



I am able to use the BO Mapper against my AS400 OS400 DB2 databases,libraries, and tables, map to business objects and use the "read only" type controls like bound textboxes, the SF Maintenance form, ListView, and BrowseDialog, a hug improvement from 2 weeks ago



Now I need to figure out what to set up for updates and CRUD settings, when I try to "save" it blows out saying there is no primekey on the table (which there is). I imaging is is because I have always relied on the DDT to create sprocs for CRUD, and I cant with the DB2 model.



So, where do I go from here? Do I need to create sprocs on the 400 for these? Our in-house 400 guy is an RPM programmer and has never used stored procedures. I nudge along the right direction will be much appreciated.



Licensing for the DB2Connect product is about $500.00 for a sinlge user, or $2,500.00 for 25 named users, if anyone was curious.



Thanks,



Keith

Keith Chisarik

What I would give for "edit your own post" ability, sorry for the above, been a bad day.



RPM = RPG

Keith Chisarik

Hehe, I just figured the guy was really a car mechanic

As for the stored procedures, you don't have to use them.  If you want you use them, you'll need to hand code them (good luck), otherwise, the businss object will generate the CRUD statements on its own.  So, as for why the BOMapper isn't picking up on the primary key, I don't know.  When you view the fields within the BOMapper, do any of the fields show up with the little key icon?  If not, you can specify the primary key for the business object by going into the business object's properties within the BOMapper.  There is a field for overriding the PK specification.  You can't enter the field, but if you hit the browse button, you'll get a dialog that allows you to enter the field(s) that is the primary key.  Once you have that set, everything should be good and allow you enter records.