{"id":17,"date":"2006-03-31T14:14:34","date_gmt":"2006-03-31T22:14:34","guid":{"rendered":"http:\/\/wp.colliertech.org\/cj\/?p=17"},"modified":"2006-03-31T14:14:34","modified_gmt":"2006-03-31T22:14:34","slug":"useful-maxdb-commands","status":"publish","type":"post","link":"https:\/\/wp.c9h.org\/cj\/?p=17","title":{"rendered":"Useful MaxDB commands"},"content":{"rendered":"<p>To find a list of tables in a schema:<\/p>\n<pre>$ sqlcli -u TEST,TEST -d SYNCMANA \"SELECT * FROM TABLES WHERE SCHEMANAME = 'TEST'\"<\/pre>\n<p>To find a list of triggers on a table:<\/p>\n<pre>$ sqlcli -u DBSERVICE,SECRET -d SYNCMANA \"SELECT * FROM TRIGGERS WHERE TABLENAME = 'T'\"<\/pre>\n<p>To describe a table&#8217;s structure:<\/p>\n<pre>\r\n$ cat me && echo \"-----\" && \\\r\n   loadercli -d SYNCMANA -u TEST,TEST -b .\/me && echo \"-----\" && \\\r\n   cat tabledef.txt\r\ndataextract for dataload table T\r\noutstream file 'tabledef.txt'\r\noutstream file 'idontcare'\r\n\r\n-----\r\nLoader protocol: '\/home\/cjcollier\/.sdb\/loader\/log\/loader.prt'\r\nLoader packages: '\/home\/cjcollier\/sdb\/loader\/packages'\r\n\r\nUser TEST connected to database SYNCMANA schema TEST on local host.\r\ndataextract for dataload table T\r\noutstream file 'tabledef.txt'\r\noutstream file 'idontcare'\r\nSuccessfully executed\r\n\r\n-----\r\n\/\/\r\nCREATE TABLE \"T\"\r\n(\r\n        \"I\"  Integer  NOT NULL,\r\n        \"C\"  Varchar (32) UNICODE,\r\n        PRIMARY KEY (\"I\")\r\n)\r\n NO FIXED LENGTH COLUMN\r\n\/\/\r\nDATALOAD TABLE \"T\"\r\n\"I\" 1 CHAR\r\n\"C\" 2 CHAR DEFAULT NULL\r\nINSTREAM  FILE  'idontcare'\r\n COMPRESSED UCS2\r\nDECIMAL '\/\/.\/'\r\nSEPARATOR ','\r\nDELIMITER '\"'\r\nDATE INTERNAL\r\nTIME INTERNAL\r\nTIMESTAMP INTERNAL\r\nNULL '?                   '\r\nBOOLEAN 'TRUE\/FALSE'\r\n\/\/\r\n<\/pre>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=cjamescollier\" class=\"twitter-share-button\">Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>To find a list of tables in a schema: $ sqlcli -u TEST,TEST -d SYNCMANA &#8220;SELECT * FROM TABLES WHERE SCHEMANAME = &#8216;TEST'&#8221; To find a list of triggers on a table: $ sqlcli -u DBSERVICE,SECRET -d SYNCMANA &#8220;SELECT * FROM TRIGGERS WHERE TABLENAME = &#8216;T'&#8221; To describe a table&#8217;s structure: $ cat me &#038;&#038; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,20,10,8],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-maxdb","category-sql","category-sync-manager","category-work"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1YDIB-h","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":0,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}