Is it possible for infopath to pass a variable(employeeID in this case) and call a stored procedure to a db2 mainframe database to return 4 other variables (forwardleave, sickleave, familyleave, otherleave)? Can I do this directly or do i need to call the mainframe stored procedure from my sql database?
Which would be the best way, granted if they both are possible and any guidance?
Using infopath 2007, with backward infopath 2003 vb.net code....moss 2007