https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/31970.aspxThu, 04 Sep 2008 07:22:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:31970Clay Fox0https://www.infopathdev.com:443/forums/thread/31970.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=31970<p>This should be doable with code.</p> <p>If you have SQL as an intermediatry, it could be done in SQL and then pushed or replicated to DB2.</p>https://www.infopathdev.com:443/forums/thread/31920.aspxWed, 03 Sep 2008 15:08:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:31920barmatt800https://www.infopathdev.com:443/forums/thread/31920.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=31920<p>Is it possible for infopath to pass a variable(employeeID in this case) and call a stored procedure to a db2&nbsp; mainframe database to return 4 other variables (forwardleave, sickleave, familyleave, otherleave)?&nbsp; Can I do this directly or do i need to call the mainframe stored procedure from my sql database?</p> <p>&nbsp;Which would be the best way, granted if they both are possible and any guidance?</p> <p>&nbsp;Using infopath 2007, with backward infopath 2003 vb.net code....moss 2007</p>