{"product_id":"db2-11-for-z-os-application-programming-workshop-cv722g-1","title":"DB2 11 for z\/OS Application Programming Workshop (CV722G)","description":"\u003cdiv\u003e\n\u003cp\u003eThis official IBM DB2 11 for z\/OS course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. It is an intermediate course for application programmers who need to write embedded SQL programs in COBOL or PL\/I (on z\/OS)\u003c\/p\u003e\r\n\r\n\u003cp\u003eEmphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.\u003c\/p\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eYou Will Learn How To:\u003c\/h3\u003e\n\u003cul\u003e\r\n\t\u003cli\u003eIncorporate static SQL statements in an application program\u003c\/li\u003e\r\n\t\u003cli\u003ePrepare the program for execution\u003c\/li\u003e\r\n\t\u003cli\u003eValidate execution results are correct\u003c\/li\u003e\r\n\t\u003cli\u003eProduce code to support multiple rows being returned from the database manager using cursors\u003c\/li\u003e\r\n\t\u003cli\u003eIdentify considerations regarding units of work, concurrency, and restart of programs\u003c\/li\u003e\r\n\t\u003cli\u003eIdentify differences between static and dynamic SQL\u003c\/li\u003e\r\n\t\u003cli\u003eProvide test data for applications\u003c\/li\u003e\r\n\t\u003cli\u003eDiscuss program and DB2 options relative to performance of static SQL\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003cul class=\"accordion\"\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRequirements\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eYou should already have experience with one of the supported programming languages, COBOL or PL\/I for z\/OS. You are also expected to already be able to construct and use SQL statements.\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e","brand":"ExitCertified","offers":[{"title":"206F57US \/ 2020-06-08T09:30:00 \/ Online","offer_id":31394992685174,"sku":"US-1402-GOVT-IL","price":2093.0,"currency_code":"USD","in_stock":true},{"title":"209E55US \/ 2020-09-14T09:30:00 \/ Online","offer_id":31612695281782,"sku":"US-1402-GOVT-IL","price":2093.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/ltreetheta.myshopify.com\/products\/db2-11-for-z-os-application-programming-workshop-cv722g-1","provider":"Learning Tree International","version":"1.0","type":"link"}