{"id":809,"date":"2020-06-11T10:13:51","date_gmt":"2020-06-11T01:13:51","guid":{"rendered":"https:\/\/www.agtech.co.jp\/actian\/?page_id=809"},"modified":"2024-12-17T18:04:08","modified_gmt":"2024-12-17T09:04:08","slug":"tip004","status":"publish","type":"page","link":"https:\/\/www.agtech.co.jp\/actian\/support\/reference\/techtips\/tip004\/","title":{"rendered":"Tech Tip"},"content":{"rendered":"
\r\n
\r\n

Tech Tip
PSQL Library<\/span><\/h1>\r\n <\/div>\r\n \r\n
\r\n\r\n \r\n <\/a>\r\n

\u300c\u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u4f7f\u7528\u300d<\/h3>\r\n \r\n \r\n

Actian Zen \u306e\u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306f\u3001\u72ec\u81ea\u306e SQL \u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u306a\u304f\u7a2e\u3005\u306e\u30bf\u30b9\u30af\u3092\u5b9f\u884c\u3059\u308b\u624b\u6bb5\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002
\r\n
\r\n \u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u547c\u3073\u51fa\u3059\u4e00\u822c\u7684\u306a\u5f62\u5f0f\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002
\r\n Call \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u540d (‘\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d’, ‘\u30c6\u30fc\u30d6\u30eb\u540d’, ‘\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d’)
\r\n <\/span>
\r\n \u4ee5\u4e0b\u306b\u3001Zen \u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e 2 \u3064\u306e\u4f8b\u3092\u793a\u3057\u307e\u3059\u3002\u3053\u308c\u3089\u3092\u4f7f\u7528\u3059\u308b\u3068\u30011 \u3064\u4ee5\u4e0a\u306e DDF\uff08\u30c7\u30fc\u30bf\u8f9e\u66f8\u30d5\u30a1\u30a4\u30eb\uff09\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3059\u308b\u30af\u30a8\u30ea\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u306a\u304f\u3001DDF \u3078\u306e\u554f\u3044\u5408\u308f\u305b\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\r\n
\r\n Demodata \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e Billing \u30c6\u30fc\u30d6\u30eb\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u306b\u3064\u3044\u3066\u306e\u60c5\u5831\u3092\u5165\u624b\u3059\u308b\u306b\u306f\u3001\u6b21\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002
\r\n Call psp_columns(‘demodata’, ‘billing’, ) <\/span>
\r\n \u30e1\u30e2\uff1a\u5217\u540d\u3092\u7a7a\u306e\u307e\u307e\u306b\u3057\u3066\u304a\u304f\u3053\u3068\u306b\u3088\u308a\u3001Billing \u30c6\u30fc\u30d6\u30eb\u306e\u5217\u540d\u306e\u3059\u3079\u3066\u3092\u8981\u6c42\u3057\u3066\u3044\u307e\u3059\u3002
\r\n
\r\n \u3053\u306e\u30af\u30a8\u30ea\u306e\u7d50\u679c\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002
\r\n
\r\n \"\"

\r\n
\r\n \u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3059\u3079\u3066\u306e\u30e6\u30fc\u30b6\u30fc \u30c6\u30fc\u30d6\u30eb\u306e\u540d\u524d\u3092\u554f\u3044\u5408\u308f\u305b\u308b\u306b\u306f\u3001psp_tables \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\r\n \r\n

Call psp_tables(‘demodata’, ,’user table’)<\/span>
<\/p>\r\n \r\n

\"\"
\r\n
\r\n
\r\n \u5229\u7528\u53ef\u80fd\u306a\u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u591a\u6570\u3042\u308a\u307e\u3059\u3002
\r\n <\/p>\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
psp_columns<\/td>\r\n psp_column_attributes<\/td>\r\n psp_column_rights<\/td>\r\n <\/tr>\r\n
psp_fkeys<\/td>\r\n psp_groups<\/td>\r\n psp_help_sp<\/td>\r\n <\/tr>\r\n
psp_help_trigger<\/td>\r\n psp_help_udf<\/td>\r\n psp_help_view<\/td>\r\n <\/tr>\r\n
psp_indexes<\/td>\r\n psp_pkeys<\/td>\r\n psp_procedure_rights<\/td>\r\n <\/tr>\r\n
psp_rename<\/td>\r\n psp_stored_procedures<\/td>\r\n psp_tables<\/td>\r\n <\/tr>\r\n
psp_table_rights<\/td>\r\n psp_triggers<\/td>\r\n psp_udfs<\/td>\r\n <\/tr>\r\n
psp_users<\/td>\r\n psp_view_rights<\/td>\r\n psp_views<\/td>\r\n <\/tr>\r\n <\/tbody><\/table>\r\n
\r\n\t \r\n

\u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u300eSQL Engine Reference\u300f\u30de\u30cb\u30e5\u30a2\u30eb\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002 <\/p>\r\n

\u4ee5\u4e0b\u306e\u30ea\u30f3\u30af\u304b\u3089\u30aa\u30f3\u30e9\u30a4\u30f3 \u30de\u30cb\u30e5\u30a2\u30eb\u3092\u53c2\u7167\u3067\u304d\u307e\u3059\u3002
\r\nhttps:\/\/www.agtech.co.jp\/products\/actian\/docs_portal\/Zen\/16.0\/index.html#page\/sqlref\/sysstorprocs.htm<\/a><\/p>\r\n\r\n \r\n \r\n <\/div>\r\n <\/div>","protected":false},"excerpt":{"rendered":"Tech TipPSQL Library \u300c\u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u4f7f\u7528\u300d Actian Zen \u306e\u30b7\u30b9\u30c6\u30e0 \u30b9\u30c8\u30a2\u30c9 \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306f\u3001\u72ec\u81ea\u306e SQL \u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u306a\u304f\u7a2e\u3005\u306e\u30bf\u30b9\u30af\u3092\u5b9f\u884c\u3059\u308b\u624b\u6bb5\u3092\u63d0\u4f9b\u3057 […]","protected":false},"author":1,"featured_media":0,"parent":801,"menu_order":128,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/pages\/809"}],"collection":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/comments?post=809"}],"version-history":[{"count":12,"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/pages\/809\/revisions"}],"predecessor-version":[{"id":5549,"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/pages\/809\/revisions\/5549"}],"up":[{"embeddable":true,"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/pages\/801"}],"wp:attachment":[{"href":"https:\/\/www.agtech.co.jp\/actian\/wp-json\/wp\/v2\/media?parent=809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}