{"issue":{"milestone":{"creator":{"login":"Jach","id":159184,"url":"https://api.github.com/users/Jach","gravatar_id":"49cb434238ae04c786eb888a33591ad6","avatar_url":"https://secure.gravatar.com/avatar/49cb434238ae04c786eb888a33591ad6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"title":"0.9.4 M1","created_at":"2011-12-29T23:28:07Z","open_issues":1,"state":"open","due_on":null,"closed_issues":0,"number":4,"description":null,"url":"https://api.github.com/repos/Jach/testr/milestones/4"},"title":"[DDB-26] Create Table As UDP","created_at":"2011-12-29T23:30:07Z","user":{"login":"Jach","id":159184,"url":"https://api.github.com/users/Jach","gravatar_id":"49cb434238ae04c786eb888a33591ad6","avatar_url":"https://secure.gravatar.com/avatar/49cb434238ae04c786eb888a33591ad6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"updated_at":"2011-12-29T23:30:13Z","state":"open","labels":[{"name":"UDR Library","color":"0a79c6","url":"https://api.github.com/repos/Jach/testr/labels/UDR+Library"}],"id":2683885,"closed_at":null,"html_url":"https://github.com/Jach/testr/issues/38","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"[created=\"Sun, 14 Mar 2010 19:38:27 -0700\", resolved=\"Thu, 8 Apr 2010 19:55:32 -0700\"]\n<br /><br />\n<p>Create a UDP that creates a table from a generic cursor input, then optionally loads the table from the input cursor</p>\n\n        <p>call applib.CREATE_TABLE_AS(target_schema, target_table, input select statement, should_load);</p>\n\n        <p>required:<br/>\n        target_table_name - Name <br/>\n        input select statement - The input cursor.  a Select statement that will produce a cursor.</p>\n\n        <p>optional:<br/>\n        target_schema - the schema to create the new table in.  If null use the schema on the calling connection.<br/>\n        should_load - defaults to true, which means that after the new table is created the table is populated with the select statement.</p>\n\n        <p>Implementation notes:</p>\n        <ul class=\"alternate\" type=\"square\">\n        <li>if at all possible, the select statement should only be prepared, not executed during table creation</li>\n        </ul>\n\n\n        <p>Testing Notes:</p>\n        <ul class=\"alternate\" type=\"square\">\n        <li>Test to make sure datatypes/precisions match</li>\n        <li>Test for errors thrown if table already exists</li>\n        <li>Test for select statements from tables, UDXs, and remote tables</li>\n        </ul>\n      ","number":38,"url":"https://api.github.com/repos/Jach/testr/issues/38","comments":4,"assignee":null},"comment":{"created_at":"2011-12-29T23:30:13Z","user":{"login":"Jach","id":159184,"url":"https://api.github.com/users/Jach","gravatar_id":"49cb434238ae04c786eb888a33591ad6","avatar_url":"https://secure.gravatar.com/avatar/49cb434238ae04c786eb888a33591ad6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"updated_at":"2011-12-29T23:30:13Z","id":3306516,"body":"[author=\"ngoodman\", created=\"Thu, 8 Apr 2010 19:55:32 -0700\"]\n<br /><br />\n<p>checked into //open/dy/dev with unit tests.  A-OK</p>","url":"https://api.github.com/repos/Jach/testr/issues/comments/3306516"},"action":"created"}