Db2 and Jupyter Notebooks

Jupyter NotebookからDb2に簡単にアクセスできるDb2 Magicコマンドの説明(の日本語訳)です。

Jupyter NotebookからDb2へらくらくアクセス - Db2 Magic コマンドを使おう!
https://speakerdeck.com/kyokonishito/jupyter-notebooks-with-db2
もぜひ一緒に参照ください。

参考:
https://github.com/IBM/db2-jupyter

Transcript

1. IBM Cloud 1 %C
   BOE
   +VQZUFS
   /PUFCPPLT Š (FPSHF
   #BLMBS[ %C
   %JHJUBM
   5FDIOJDBM
   &OHBHFNFOU ೔ຊޠ༁ ੢ށ ژࢠ ,ZPLP
   /JTIJUP ೔ຊΞΠɾϏʔɾΤϜגࣜձࣾ ςΫϊϩδʔࣄۀ෦ %BUB
   
   "*
   5FDIOJDBM
   4BMFT
2. IBM Cloud 2 Legal Disclaimer 2 Copyright © IBM Corporation 2019 All rights reserved. U.S. Government Users Restricted Rights - Use, duplication, or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON CURRENT THINKING REGARDING TRENDS AND DIRECTIONS, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUT NOTICE. FUNCTION DESCRIBED HEREIN MY NEVER BE DELIVERED BY IBM. IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR REPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR SOFTWARE. IBM, the IBM logo, ibm.com and Db2 are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or !), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml
3. IBM Cloud 3 Agenda § +VQZUFS /PUFCPPLͱ͸ʁ § ͳͥ +VQZUFS /PUFCPPL § %C
   Λ /PUFCPPLʹ౷߹ͯ͠ΈΑ͏ - ಈ͔ͯ͠ΈΑ͏ - 42-
   αϙʔτ - ߴ౓ͳػೳ § ελʔτʹ໾ཱͭϦιʔε
4. IBM Cloud 4 Jupyter Notebook § +VQZUFSͷϊʔτϒοΫ͸ɺ೥݄ʹ։ൃ͕࢝·ͬͨ*1ZUIPOΛϕʔεʹ͍ͯ͠·͢ɻ § طଘͷ1ZUIPOΠϯλʔϓϦλ͸ػೳ͕ݶΒΕ͓ͯΓɺΑΓॆ࣮ͨ͠։ൃ؀ڥΛ࡞ΔͨΊʹ ࡞ۀ͕࢝·Γ·ͨ͠ɻ § ೥ʹ͸*1ZUIPO͕ϦϦʔε͞Ε·ͨ͠ IUUQCMPHGQFSF[PSHJQZUIPOOPUFCPPLIJTUPSJDBMIUNM § ϊʔτϒοΫͷʮςΩετʯΛ࡞੒͢ΔͨΊʹ.BSLEPXOΛ࢖༻͍ͯ͠·͢ɻ § ίʔυͷηϧʹ͸ҎԼͷ΋ͷ͕࢖͑·͢ - 1ZUIPO - .BHJD
   ίϚϯυ ޙड़ - +BWB
   $
   (P-BOH
   ͳͲ͍Ζ͍Ζͳݴޠ § ΠϯλϥΫςΟϒͳ։ൃͱϓϩτλΠϐϯά͕Մೳ
5. IBM Cloud 5 +VQZUFS /PUFCPPL͸ͲΜͳ΋ͷ § .JDSPTPGU
   8PSEʹࣅ͍ͯ·͕͢ɺϥΠϒίʔυ͕͋Γ·͢ɻ ςΩετ ίʔυ
6. IBM Cloud 6 Jupyter Notebook の動作要件 § ҰൠతͳσεΫτοϓϓϥοτϑΥʔϜͰಈ࡞ - -JOVY - .BD
   049 - 8JOEPXT § ίϯςϯπ͸8FCϒϥ΢βʔͰࢀর - $ISPNF
   *&
   4BGBSJ
   'JSFGPY
   FUDʜ § +VQZUFS͸ɺϫʔΫεςʔγϣϯ্ͰϩʔΧϧʹ࣮ߦ͢Δ͜ͱ΋ɺαʔϏεͷҰ෦ͱͯ͠ ࣮ߦ͢Δ͜ͱ΋Ͱ͖·͢ɻ - MPDBMIPTUͰ/PUFCPPLʹΞΫηε § ΠϯετʔϧΠϝʔδ͸ҎԼͷαΠτͰऔಘͰ͖·͢ - IUUQTKVQZUFSPSH - IUUQTXXXBOBDPOEBDPNEJTUSJCVUJPO - 1ZUIPOͱඞཁͳଟ͘ͷϥΠϒϥϦΛؚΉ"OBDPOEBͷϑϧελοΫΛೖख͢Δ͜ͱΛ͓קΊ͠ ·͢ɻ ༁஫
   "OBDPOEB͸৚݅ʹΑΓ༗ྉԽͨ͠ͷͰ஫ҙ
7. IBM Cloud 7 ෳࡶͳ+VQZUFS /PUFCPPL
   ͷαϯϓϧ
8. IBM Cloud 8 ͳͥ+VQZUFS /PUFCPPL § Α͍ͱ͜Ζ - ݚڀऀ΍σʔλαΠΤϯςΟετʹ޿͘ར༻͞Ε͍ͯΔ - ςΩετ΍ίʔυͷڞ༗͕Մೳ - ࢼߦࡨޡΛଅ͠ɺίʔυͰԿ͕ى͍ͬͯ͜Δ͔Λه࿥͢Δ͜ͱ͕Ͱ͖Δ § ͍·͍ͪͳͱ͜Ζ - Կ͔Λ΍Δʹ͸1ZUIPOΛཧղ͢Δඞཁ͕͋Δʢͱ͖Ͳ͖ʣɻ - /PSFCPPLʹ͸%CͷωΠςΟϒ઀ଓ͕ͳ͍ʢ؆୯ʹͰ͖Δύοέʔδ͸͋Δ͕ɺ%Cͷ֦ு Λαϙʔτ͍ͯ͠ͳ͍
9. IBM Cloud 9 ͸͡ΊΑ͏ §"OBDPOEB·ͨ͸+VQZUFS/PUFCPPLΛΠϯετʔϧ͠·͢ - ωΠςΟϒʹΠϯετʔϧͨ͘͠ͳ͍৔߹͸ɺ%PDLFSͷ࢖༻Λݕ౼͍ͯͩ͘͠͞ ʢ༁஫ɿ"OBDPOEB΋%PDLFS %FTLUPQ΋৚݅ʹΑΓ༗ঈʹͳͬͨͷͰ஫ҙʣ §*OTUBMM
   UIF
   %C
   1ZUIPO
   ESJWFS - FBTZ@JOTUBMM JCN@EC ·ͨ͸ - QJQ
   JOTUBMM
   
   JCN@EC ༁஫
   ࠓ͸ͪ͜Β §%PXOMPBE
   UIF
   %C
   .BHJD
   $PNNBOE - IUUQTHJUIVCDPN%#4BNQMFTECKVQZUFS - ͨͬͨͭͷϑΝΠϧ͕ඞཁ
   ECJQZOC - JQZOC
   ͸ +VQZUFS OPUFCPPL༻ͷ֦ுࢠͰ͢ - ͜ͷ +VQZUFS OPUFCPPL
   FOWJSPONFOUʹΠϯϙʔτ͠·͢ 9
10. IBM Cloud 10 ͕Μ͹Γ·͠ΐ͏ʂʜ § %PDLFSͷಋೖ - IUUQTEPDTEPDLFSDPN ࢀর §%PDLFS
    ίϯςφͷ࡞੒ - IUUQTHJUIVCDPN%#4BNQMFTECKVQZUFS - ECKVQZUFSEPDLFS
    ΛۭͷσΟϨΫτϦʹμ΢ϯϩʔυ͠·͢ - ,JUFNBUJD $-*
    ίϚϯυϥΠϯ͔
    
    8JOEPXT
    PS.BD PS
    -JOVYͷλʔϛφϧ΢Οϯυ΢Λ࢖͍·͢ w ECKVQZUFSEPDLFSϑΝΠϧ͕ஔ͔Ε͍ͯΔσΟϨτϦʹҠಈ͠·͢ w ҎԼͷίϚϯυΛ࣮ߦͯ͠ɺ%PDLFSΠϝʔδΛ࡞੒͠·͢ɻ  EPDLFS
    CVJME
    U
    ECKVQZUFS
    G
    ECKVQZUFSEPDLFS
    
    
    
    
    ß,FFQ
    UIF
    QFSJPE EPDLFS
    SVO
    OBNF
    ECKVQZUFS
    E
    Q
    
    ECKVQZUFS
    - ͓޷Έͷϒϥ΢βΛ࢖ͬͯMPDBMIPTU ʹΞΫηε ʢ༁஫ɿ%PDLFS %FTLUPQ͸༗ঈʹͳͬͨͷͰ஫ҙ
    -PDBMʹ+VQZUFS OPUFCPPLΛಋೖɺΫϥ΢υ؀ڥΛ࢖͏ ͔͋ͨΓ͕ଥ౰ʣ 10
11. IBM Cloud 11 ࣍͸Կ͢Δ §+VQZUFS /PUFCPPLTͷىಈ §%CυϥΠόʔ͕Ͳ͔͜ʹ͋Δ͜ͱΛ֬ೝ͍ͯͩ͘͠͞ʢ·ͨ͸%PDLFSΠϯετ ʔϧΛ࢖༻͍ͯͩ͘͠͞ʂʣɻ §ϊʔτϒοΫʹΞΫηε͠·͢ʢMPDBMIPTUʣɻ §ECJQZOCϊʔτϒοΫΛΠϯϙʔτ͢Δ͔ɺϊʔτϒοΫΛอଘ͢Δύεʹ഑ஔ ͠·͢ɻ 11
12. IBM Cloud 12 %C
    .BHJD
    ίϚϯυͷϩʔυ §ۭͷϊʔτϒοΫΛ։͖ɺ࣍ͷίϚϯυΛೖྗ͠·͢ɻ §+VQZUFSͷ 3VO
    Ϙλϯ·ͨ͸4IJGU3FUVSOͰίʔυΛ࣮ߦ͠·͢ɻ §ຐ๏͕͔͔ͬͨʂʁ 12
13. IBM Cloud 13 .BHJD
    ίϚϯυ §+VQZUFSʹ͸ɺ1ZUIPOίʔυ΍ಛผͳΞΫγϣϯΛ୅ߦ͢Δ.BHJDίϚϯυ͕༻ҙ ͞Ε͍ͯ·͢ - ྫ͑͹
    TZTUFN
    γεςϜίϚϯυΛ࣮ߦ͠·͢ §SVO
    ECJQZOCίϚϯυ͸ɺECJQZOCϑΝΠϧͷ಺༰ΛಡΈࠐΜͰɺ৽͍͠ TRM ͱ TRM ίϚϯυΛ࡞੒͠·͢ § TRMίϚϯυ͸ҰߦίϚϯυʹ࢖༻͞Εɺ TRM ͸ 42-
    ͷϒϩοΫΛ࣮ߦ͢Δ ͨΊͷ΋ͷͰ͢ɻ - ม਺ʹ୅ೖͰ͖Δͷ͸ TRM ίϚϯυͷ݁ՌͷΈͰ͢ɻ - \ม਺໊^Λ࢖༻ͨ͠1ZUIPOͷม਺ஔ׵͸ɺTRMίϚϯυͰͷΈಈ࡞͠·͢ɻ - ୯Ұͷ TRM ίϚϯυ͸ɺߦ຤ͷόοΫεϥογϡ = Λ࢖༻ͯ͠ෳ਺ߦʹ֦ுͰ͖·͢ɻ - TRM ϒϩοΫ಺ͷෳ਺ͷεςʔτϝϯτͰ͸ɺηϛίϩϯ 
    ΛσϦϛλʔͱͯ͠࢖༻ ͠·͢ɻ 13
14. IBM Cloud 14 %C΁ͷ઀ଓ §%C
    .BHJDίϚϯυΛಡΈࠐΜͩΒɺ͍Α͍Α઀ଓͰ͢ɻ §઀ଓߏจ͸%C
    $-1ʹࣅ͍ͯ·͕͢ɺ͍͔ͭ͘ͷ޻෉͕͋Γ·͢ɻ TRM $0//&$5
    50
    EBUBCBTF 64&3
    %#*/45
    64*/(
    ECJOTU )045
    
    1035
    
    44- TRM $0//&$5
    $3&%&/5*"-4
    OBNF TRM $0//&$5
    130.15 TRM $0//&$5
    3&4&5 TRM $0//&$5
    $-04& 14
15. IBM Cloud 15 %C΁ͷ઀ଓ §%C
    .BHJDίϚϯυΛಡΈࠐΜͩΒɺ͍Α͍Α઀ଓͰ͢ɻ §઀ଓߏจ͸%C
    $-1ʹࣅ͍ͯ·͕͢ɺ͍͔ͭ͘ͷ޻෉͕͋Γ·͢ɻ TRM $0//&$5
    50
    EBUBCBTF 64&3
    %#*/45 64*/(
    ECJOTU )045
     1035
     44- TRM $0//&$5
    $3&%&/5*"-4
    OBNF TRM $0//&$5
    130.15 TRM $0//&$5 15
16. IBM Cloud 16 ϓϩϯϓτΛ࢖ͬͨ઀ଓ §130.15ʹ઀ଓ͢Δͱɺ͢΂ͯͷඞཁͳύϥϝʔλΛ࣭໰Λ͞Ε·͢ɻ §೚ҙͷλΠϛϯάͰఀࢭ͢Δʹ͸ɺ/6--஋Λೖྗ͠·͢ɻ 16
17. IBM Cloud 17 ೝূ৘ใΛ࢖ͬͨ઀ଓ §%CͷΫϥ΢υɾΠϯελϯε͔Βఏڙ͞ΕΔೝূ৘ใ §ೝূ৘ใΛ1ZUIPOͷม਺ʹׂΓ౰ͯͰ͖·͢ NZJE 
    \EC
    #-6%#
    QBTTXPSEJGPSHPUJU
    ʜ^ TRM $0//&$5
    $3&%&/5*"-4
    NZJE 17
18. IBM Cloud 18 ઀ଓ৘ใΛ࢖ͬͨ઀ଓ §σʔλϕʔε΁ͷ઀ଓʹඞཁͳ͢΂ͯͷ஋Λهड़ TRM $0//&$5
    50
    EBUBCBTF 64&3
    %#*/45 64*/(
    ECJOTU )045
     1035
     <44-> §Ҏલʹ઀ଓ͍ͯͨ͠৔߹͸ɺTRM $0//&$5ͰσΟεΫʹอଘ͞Ε͍ͯΔҎલͷ ઀ଓ৘ใΛ࢖༻͠·͢ɻ §஋͕଍Γͳ͍৔߹͸ɺҎલͷ઀ଓͷ৘ใ͕ར༻͞Ε·͢ɻ - TRM DPOOFDU
    UP
    TBNQMF
    - ҎલͷϢʔβʔ࢖༻ऀͷ஋͸ɺҎલͷ৘ใ͕࢖ΘΕ·͢ɻ §҉໧తͳ઀ଓ͸ɺ࠷ॳͷ TRM จΛ࣮ߦ͢Δͱ͖ʹߦΘΕ·͢ɻ 18
19. IBM Cloud 19 ઀ଓͷࣦഊ §઀ଓઌ͔Βͷ׬શͳ਍அ৘ใ͕໭͖ͬͯ·͢ɻ - ͦͷ৘ใ͕໾ʹཱ͔ͭͲ͏͔͸ɺ͋ͳ͕ͨ൑அ͍ͯͩ͘͠͞ 19
20. IBM Cloud 20 ਍அ৘ใ §ͭͷ૊ΈࠐΈม਺͔Βৗʹ਍அ৘ใΛಘΔ͜ͱ͕Ͱ͖·͢ɻ - TRMDPEF r࠷ޙʹੜ੒͞ΕͨTRMDPEF - TRMTUBUF r࠷ޙʹੜ੒͞ΕͨTRM TUBUF - TRMFSSPS r࠷ޙʹੜ੒͞Εͨϝοηʔδ §ϓϩάϥϛϯάɾϩδοΫΛ࢖༻͍ͯ͠Δ৔߹ʹศར 20
21. IBM Cloud 21 ઀ଓ੒ޭ 21 §઀ଓ͕੒ޭͨ͠৔߹΋ϝοηʔδΛ໭͠·͢ §TRMίϚϯυ͸ߦʹ͔͠ॻ͚ͳ͍͜ͱʹ஫ҙ͍ͯͩ͘͠͞ɻ - ߦҎ্ଓ͚Δ৔߹͸ɺόοΫεϥογϡ=Λ࢖༻͍ͯͩ͘͠͞ɻ - Ϣʔβʔ*%ͱύεϫʔυͷେจࣈɾখจࣈ͸۠ผ͞Ε·͢ɻ §ͲͷOPUFCPPLͰ΋DPOOFDUͰ઀ଓͰ͖ΔΑ͏ʹͳΓ·ͨ͠ɻ
22. IBM Cloud 22 ࣍͸Կ͕Ͱ͖Δ 22 §઀ଓ͕׬ྃͨ͠Βɺ42-Λ࣮ߦ͢Δ͜ͱ͕Ͱ͖·͢
23. IBM Cloud 23 ϑΥʔϚοτ͕͓͔͍͠ 23 §σϑΥϧτͰ͸1BOEBT
    %BUBGSBNFܗࣜͰग़ྗ͞Ε·͢ɻ §ग़ྗͷ࠷ॳͷߦͱ࠷ޙͷߦΛදࣔ͠·͢ɻ §΋ͬͱݟ͍ͨ৔߹͸ɺಛผͳϑϥά BMM Λ࢖༻͢Δ͔ɺ͍͔ͭ͘ͷઃఆΛมߋ͢Δ ͔ɺHSJEϑΥʔϚοτΛ࢖༻͢Δඞཁ͕͋Γ·͢ɻ
24. IBM Cloud 24 άϦουܗ͕ࣜΑΓඒ͘͠ 24 §TRMίϚϯυͷޙʹHSJEΦϓγϣϯΛ࢖༻͠·͢ɻ §͜ΕͰɺճ౴ηοτΛεΫϩʔϧͨ͠ΓɺྻͷαΠζΛมߋͨ͠Γɺ೚ҙͷྻͰιʔ τͨ͠Γ͢Δ͜ͱ͕Ͱ͖·͢ɻ §015*0/Λมߋ͢Δ͜ͱͰɺ͜ͷදࣔܗࣜΛσϑΥϧτʹ͢Δ͜ͱ͕Ͱ͖·͢ɻ ༁஫
    HJUIVC ্ͷެࣜ%PDLFS *NBHFͰ͸ಈ͖·͕ͨ͠ɺ 8BUTPO
    4UVEJP
    ্ͷOPUFCPPL΍Colaboratory Ͱ͸ಈ͖·ͤΜͰͨ͠ɻ಺෦Ͱ࢖༻͍ͯ͠ΔRHSJE͸͏·͘ಈ͔ͳ͍؀ڥ͕Α͋͘ΔΑ͏Ͱ͢ɻΤϥʔʹͳΔ ৔߹͸͖͋ΒΊͯBΦϓγϣϯΛ࢖͍·͠ΐ͏
25. IBM Cloud 25 Φϓγϣϯ §ίϚϯυͷಈ࡞Λมߋ͢ΔΦϓγϣϯ͕͍͔ͭ͋͘Γ·͢  - ."93084 rճ౴ηοτͷҰ෦ΛӅ͢લʹ1BOEBTͷσΟεϓϨΠʹදࣔ͢Δߦ਺ - ."9(3*% rεΫϩʔϧՄೳͳσΟεϓϨΠͷ࠷େදࣔߦ਺ - 36/5*.& rεςʔτϝϯτ࣮ߦͷλΠϛϯάͰɺԿඵޙʹ࣮ߦ͢Δ͔ - %*41-": rग़ྗʹ1BOEBT·ͨ͸(SJEϑΥʔϚοτΛ࢖༻ - -*45 rݱࡏͷઃఆΛදࣔ §ίϚϯυ͸ɺҰ౓ʹෳ਺ͷΦϓγϣϯΛઃఆ͢Δ͜ͱ͕Ͱ͖·͢ɻ TRM PQUJPO
    NBYHSJE 
    EJTQMBZ
    HSJE 25
26. IBM Cloud 26 42-จͱ42-ϒϩοΫ §͜Ε·Ͱ͸୯Ұͷ42-จͷΈΛ͖ࣔͯ͠·ͨ͠ §େن໛ͳ42-ͷϒϩοΫΛ࣮ߦ͍ͨ͠৔߹͸ʁ §TRMϑΥʔϚοτΛ࢖༻ͯ͠ɺ$FMM಺ͷ͢΂͕ͯ%C
    42-Ͱ͋Δ͜ͱΛϓϩά ϥϜʹ఻͑·͢ɻ 26
27. IBM Cloud 27 σϦϛλʔ §σϑΥϧτͰ͸42-จͷ۠੾Γʹηϛίϩϯ  ͕࢖ΘΕ͍ͯ·͢ɻ §͜ΕΛΞοτʢ!ʣه߸ʹมߋ͢Δʹ͸EϑϥάΛ࢖༻͠·͢ɻ §ϒϩοΫͷ࣮ߦதʹΤϥʔ͕ൃੜͯ͠΋ແࢹ͢Δʹ͸ - ΤϥʔΛ཈੍͍ͨ͠৔߹͸ɺRVJFU
    ·ͨ͸ R
    ϑϥάΛ࢖༻͍ͯͩ͘͠͞ɻ - ग़ྗ͸ͦͷ··දࣔ͞Ε·͢ 27
28. IBM Cloud 28 4&-&$5ͷ݁ՌΛม਺ʹ୅ೖ §݁ՌηοτΛ1ZUIPOͷม਺ʹׂΓ౰ͯΔ͜ͱ͕Ͱ͖·͢ɻ §ม਺ʹ֨ೲ͞Εͨޙ͸ɺ1BOEBTͷߏจΛ࢖ͬͯදࣔͨ͠ΓɺεϥΠεͨ͠Γ͢Δ ͜ͱ͕Ͱ͖·͢ɻ - ΧϥϜͷ໊લ͸Θ͔͍ͬͯΔ͕ɺҐஔ͕Θ͔Βͳ͍৔߹ʹศརͰ͢ɻ 28
29. IBM Cloud 29 4&-&$5ͷ݁ՌΛม਺ʹ୅ೖ §·ͨɺl७ਮͳ ͷ഑ྻܗࣜͷσʔλΛಘΔ͜ͱ΋Ͱ͖·͢ɻ §഑ྻͷ࠷ॳͷߦʢߦ໨ʣ͕ΧϥϜ໊ɺ࢒Γͷߦ͕σʔλߦͰ͢ɻ 29
30. IBM Cloud 30 ύϥϝʔλͷ࢖༻ §εςʔτϝϯτʹ1ZUIPOม਺Λ༩͑Δʹ͸ɺҎԼͷϑΥʔϚοτΛ࢖༻͠·͢ɻ WBS@OBNF §*/ͷϦετʹ΋ରԠ͍ͯ͠·͢ 30
31. IBM Cloud 31 จࣈྻஔ׵ §42-ߏจͷ߲໨ʢྻͳͲʣͷ஋Λࢦఆ͢Δʹ͸ɺ\WBSOBNF^ܗࣜΛ࢖༻͠·͢ɻ §୯Ұߦͷ TRM ίϚϯυͰͷΈ࢖༻Ͱ͖·͢ɻ 31
32. IBM Cloud 32 */4&35 §*/4&35ͰจࣈྻΛѻ͏৔߹͸஫ҙ͕ඞཁ §యܕతͳ*/4&35
    XJUI
    7"-6&۟Λ࢖͏͜ͱ͕Ͱ͖·͢ɻ §จࣈྻ಺ͷҾ༻ූ b ͸ɺͭͷҾ༻ූͭͷҾ༻ූͱͳΓ·͢ɻ §·ͨ͸ɺม਺Λ࢖͍·͠ΐ͏
    Ҿ༻ූ͸ඞཁ͋Γ·ͤΜ 32
33. IBM Cloud 33 +40/
    */4&35 §+40/ΦϒδΣΫτʢࣙॻܕʣΛ࡞੒͠ɺ௚઀*/4&35 33
34. IBM Cloud 34 ؆୯ͳϓϩοςΟϯάػೳ §TRMίϚϯυͰ͸ɺ؆୯ͳνϟʔτ͕࡞੒Ͱ͖·͢ - QJF
    rԁάϥϑ - CBS
    r๮άϥϑ - MJOF
    rંΕઢάϥϑ TRM rCBS
    4&-&$5
    803,%&15
    "7( 4"-"3:
    '30.
    &.1-0:&&
    = (3061
    #:
    803,%&15 34
35. IBM Cloud 35 ίϛοτɾείʔϓ §42-࣮ߦͷσϑΥϧτϞʔυ͸"650$0..*5
    0/ - ͢΂ͯͷεςʔτϝϯτ͸ίϛοτ͞Ε·͢ §"650$0..*5ͷ0/0''͕ՄೳͰ͢ TRM "650$0..*5
    0'' - "650$0..*5ͷঢ়ଶ͸ɺ઀ଓͷ༗ޮظؒதɺ͜ͷঢ়ଶΛҡ࣋͠·͢ §τϥϯβΫγϣϯͷ࠷ޙʹ$0..*5จΛ࢖͍·͢ - $0..*5
    803, rεςʔτϝϯτΛด͡ɺ͢΂ͯͷ࡞ۀΛίϛοτ͢Δ - $0..*5
    )0-% r͞ΒͳΔ࡞ۀͷͨΊʹεςʔτϝϯτΛΦʔϓϯʹ͓ͯ͘͠ - 30--#"$, r͜͜·Ͱͷ࡞ۀΛશͯϩʔϧόοΫ͢Δ 35
36. IBM Cloud 36 ετΞʔυɾϓϩγʔδϟ §ετΞυϓϩγʔδϟΛݺͼग़͢ʹ͸ɺҎԼͷߏจΛ࢖༻͠·͢ɻ SFTVMU
    Q@B
    Q@C
    Q@D
    ʜ
    
    TRM rS
    $"--
    QSPD B C D ʜ §͜ͷߏจʢSϑϥά෇͖ʣͰ͸ɺ݁Ռͱύϥϝʔλ͕ฦ͞Ε·͢ - Q@B
    Q@C
    Q@D͸ɺϓϩγʔδϟʹΑͬͯఏڙ·ͨ͸ฦ͞ΕΔ஋Ͱ͢ɻ §݁ՌηοτͷΈ͕ඞཁͳ৔߹͸ɺεςʔτϝϯτΛ୯ಠͰ࢖༻͢Δ͔ɺม਺ʹ୅ೖ ͍ͯͩ͘͠͞ɻ Y
    
    TRM $"--
    "%.*/@$.% %&4$3*#&
    5"#-&
    &.1-0:&&
    
    36
37. IBM Cloud 37 1SFQBSFE
    4UBUFNFOUT §13&1"3&ίϚϯυͱ&9&$65&ίϚϯυ͸ɺ42-จΛԿ౓΋܁Γฦ࣮͠ߦ͢Δ৔߹ ʹศརͰ͢ɻ §ͨ·ʹ͔࣮͠ߦ͞Εͳ͍Α͏ͳ؆୯ͳλεΫʹ͸ɺ͜ΕΒͷεςʔτϝϯτΛ࢖༻͠ ͯ΋ϝϦοτ͸͋Γ·ͤΜɻ §13&1"3&&9&$65&ͷϝϦοτ͸ɺಉ͡಺༰ͷτϥϯβΫγϣϯΛେྔʹॲཧ͢Δ ৔߹ʹݦஶʹݱΕ·͢ɻ 37
38. IBM Cloud 38 1SFQBSFE
    4UBUFNFOUT §13&1"3&จ͸ɺҎԼͷ42-จʹͷΈ࢖༻Ͱ͖·͢ɻ - 4&-&$5 - */4&35 - 61%"5& - %&-&5& - .&3(& §εςʔτϝϯτΛ࡞੒͢Δʹ͸ɺҎԼͷߏจΛ࢖༻͠·͢ TUNU 
    TRM 13&1"3&
    TRM  §ม਺TUNU͸ɺεςʔτϝϯτΛ࣮ߦ͢Δࡍʹ࢖༻͞Ε·͢ɻ 38
39. IBM Cloud 39 Prepared Statements §ステートメントを準備したら、以下の構文で実行できます。: %sql EXECUTE :stmt USING v1,v2,v3,.... §EXECUTE ステートメントにステートメント変数 :stmt を与える必要があります。 §USING節の後に続く値は、定数またはPythonの変数名をカンマで区切ったものです。 - 変数名の前にコロン : を置くと、その変数は直ちにステートメントに代入されます。 %sql EXECUTE :stmt USING 3,'asdsa',24.5,:x,y - :xは直接パラメータリストに実体化され、変数yはステートメントに紐付けされ、その内容が動的 に転送されます。 39
40. IBM Cloud 40 §1ZUIPOͷม਺Ͱ͸ɺҎԼͷछྨͷσʔλΛࢦఆͰ͖·͢ - DIBS จࣈσʔλܕʢσϑΥϧτʣ - CJO
    CJOBSZ όΠφϦσʔλ - EFD
    EFDJNBM  ਐ਺σʔλܕ - JOU
    JOUFHFS ਺஋σʔλܕ §͜ΕΒͷम০ࢠ͸ɺม਺໊ͷޙʹ!ه߸Λ࢖ͬͯ௥Ճ͞Ε·͢ɻ TRM &9&$65&
    TUNU 64*/(
    W!JOU
    W!CJOBSZ
    W!EFDJNBM §σϑΥϧτͰ͸ɺม਺Λจࣈྻͱͯ͠ѻ͍·͢ɻ 40 Prepared Statements
41. IBM Cloud 41 1SFQBSFE
    4UBUFNFOUTͷྫ 41
42. IBM Cloud 42 ͦͷଞͷεςʔτϝϯτɾΦϓγϣϯ §42-ͷ࣮ߦ࣌ʹ௥ՃΦϓγϣϯ͕ར༻Մೳ - E ୅ସεςʔτϝϯτσϦϛλ!ͷ࢖༻ - U UJNF
    εςʔτϝϯτͷ࣮ߦ࣌ؒ - R RVJFU ϝοηʔδΛදࣔ͠ͳ͍ - K  ྻ໨ͷ+40/ϑΥʔϚοτԽ - KTPO
    ݁ՌηοτΛ+40/Ϩίʔυͱͯ͠औಘ͢Δ - B BMM  ͢΂ͯͷग़ྗΛදࣔ - QC CBS ݁Ռͷ๮άϥϑදࣔ - QQ QJF ݁Ռͷԁάϥϑදࣔ - QM MJOF ݁Ռͷઢάϥϑදࣔ - TBNQMFEBUB αϯϓϧͷ&.1-0:&&ςʔϒϧͱ%&1"35.&/5ςʔϒϧΛσʔλϕʔεʹϩʔυ - S BSSBZ ݁ՌΛม਺ʢߦͷϦετʣʹ໭͢ - F FDIP  ϚΫϩͷஔ׵ͷΤίʔ - I IFMQ ϔϧϓ৘ใͷදࣔ - HSJE  εΫϩʔϧՄೳͳάϦουͰ݁ՌΛදࣔ 42
43. IBM Cloud 43 ྫ
    σʔλΛ+40/Ϩίʔυͱͯ͠औಘ 43
44. IBM Cloud 44 ϚΫϩ §TRMίϚϯυͰ͸ɺϚΫϩΛ࢖༻͢Δ͜ͱ΋Ͱ͖·͢ɻ - ϚΫϩ͸ɺ࣮ߦ͢Δ42-ίϚϯυʹςΩετΛ୅ೖ͢ΔͨΊʹ࢖༻͞Ε·͢ɻ - ϚΫϩͷஔ׵͸ɺ42-͕࣮ߦ͞ΕΔલʹߦΘΕ·͢ɻ - ͜ΕʹΑΓɺҰൠతʹ࢖༻͞ΕΔ42-ίϚϯυΛೖྗ͢Δ͜ͱͳ͘ɺͦΕΒΛؚΉϚΫϩΛ࡞੒͢Δ͜ͱ ͕Ͱ͖·͢ɻ - ϚΫϩ͸ύϥϝʔλʹΞΫηεͨ͠ΓɺݶΒΕͨϩδοΫػೳΛ͍࣋ͬͯ·͢ɻ TRM EFGJOF
    EFTDSJCF  
    5IF
    %&4$3*#&
    DPNNBOE
    DBO
    FJUIFS
    VTF
    UIF
    TZOUBY
    %&4$3*#&
    5"#-&
    OBNF
    PS
    %&4$3*#&
    5"#-&
    4&-&$5
     WBS
    TZOUBY
    4ZOUBY
    %&4$3*#&
    <5"#-&
    OBNF
    c
    4&-&$5
    TUBUFNFOU>
     
    $IFDL
    UP
    TFF
    XIBU
    DPVOU
    PG
    WBSJBCMFT
    JT
    .VTU
    CF
    BU
    MFBTU
    
    JUFNT  JG
    \BSHD^
    
     FYJU
    \TZOUBY^ FOEJG $"--
    "%.*/@$.% \ ^  44
45. IBM Cloud 45 ఆٛࡁΈϚΫϩ §%&4$3*#&
    <4&-&$5
    PS
    5"#-&> - ςʔϒϧ΍4&-&$5จͷ಺༰Λදࣔ͢Δ §-*45
    5"#-&4
    <'03
    "--
    c
    '03
    4$)&."
    OBNF> - ݱࡏͷεΩʔϚ·ͨ͸σʔλϕʔεͷςʔϒϧΛҰཡදࣔ 45
46. IBM Cloud 46 1BOEBT
    %BUBGSBNF UP
    %C §1BOEBT
    %BUBGSBNF͸%CͷςʔϒϧΛ࡞੒͠σʔλΛอଘ͢Δ͜ͱ͕Ͱ͖·͢ɻ §1BOEBT͸$47ϑΝΠϧΛΠϯϙʔτͰ͖·͢ɻ  §64*/(۟Λ࢖ͬͯɺ1BOEBTͷ%BUBGSBNF͔Β%CͷςʔϒϧΛ࡞੒͠·͢ɻ §NZGMJHIUTͱ͍͏%CςʔϒϧΛ࡞੒͠ɺશͯͷσʔλΛςʔϒϧʹίϐʔ͠·͢ɻ 46
47. IBM Cloud 47 1BOEBT
    %BUBGSBNF UP
    %Cͷྫ §サンプル出力 47
48. IBM Cloud 48 Pandas Dataframe to Db2 シンタックス §TRM 64*/(
    EBUBGSBNF <$3&"5&
    c
    "11&/%
    c
    3&1-"$&>
    5"#-&
    UBCMF <8*5)
    %"5"
    c
    $0-6./4
    "4*4
    c
    ,&&1
    <*/5
    c'-0"5>
    c-*.*5
    Y> §EBUBGSBNF ஋Λ֨ೲ͢ΔEBUBGSBNFͷ໊લɻ §$3&"5& ςʔϒϧͷ࡞੒  ςʔϒϧ͕ଘࡏ͢Δ৔߹͸ࣦഊɻ §3&1-"$& ςʔϒϧ͕ଘࡏ͠ͳ͍৔߹͸࡞੒͠ɺଘࡏ͢Δ৔߹͸ஔ׵ɻ §"11&/% طଘͷςʔϒϧʹσʔλΛ௥Ճɻςʔϒϧ͸࡞੒͠ͳ͍ɻ §UBCMF ςʔϒϧ໊ §8*5)
    %"5"  EBUBGSBNFͷσʔλΛ%Cςʔϒϧʹίϐʔ͢Δ §$0-6./4
    "4*4  %CϑϨϯυϦʔͳ໊લͰ͸ͳ͘ɺ EBUBGSBNFͷΧϥϜ໊Λ࢖ ༻͢Δ ༁஫
    %CϑϨϯυϦʔͳ໊લ͸࣍ϖʔδࢀর §,&&1
    */5
    ,&&1
    '-0"5  %C
    ͷϑϨϯυϦʔͳܕͷ୅ΘΓʹɺσʔλϑϨ ʔϜ͔Β */5
    ͓Αͼ '-0"5
    ϑΥʔϚοτΛ࢖༻͢Δɻ §-*.*5
    Y ςʔϒϧʹίϐʔ͢Δߦ਺Λ Y
    ʹ੍ݶ͢Δ 48
49. IBM Cloud 49 %C
    ϑϨϯυϦʔ WT 1BOEBT
    ͷྻ໊ §$0-6./4
    "4*4۟͸ɺݩͷEBUBGSBNF໊Λ࢖༻͠·͢ɻ 49
50. IBM Cloud 50 %C
    42-
    ฒྻॲཧ §%C
    .BHJDͷίϚϯυʹ͸ɺ42-Λෳ਺ϓϩηεͰ࣮ߦ͢Δػೳ͕͋Γ·͢ - σʔλൣғΛҰҙʹऔಘͰ͖ΔΩʔ͕͋Ε͹ɺ%CΤϯδϯͰ42-Λฒྻ࣮ߦ͢Δ͜ͱ͕ ՄೳͰ͢ɻ - େྔͷσʔλΛऔಘ͢Δඞཁ͕͋Δ৔߹ʹɺॲཧ଎౓Λ޲্ͤ͞Δ͜ͱ͕Ͱ͖Δ·͢ɻ - %C
    ΫΤϦͷ࣮ߦΛߴ଎Խ͢ΔͷͰ͸ͳ͘ɺϫʔΫϩʔυΛෳ਺ͷεϨουʹ෼ࢄͤ͞ɺ %C
    ͷύΠϓϥΠϯԽʹΑΓݕࡧ࣌ؒΛվળ͠·͢ɻ - %C
    %1'#-6
    ͷ୅ସʹ͸ͳΒͳ͍͕ɺ͜ΕΒͷγεςϜͱซ༻͢Δ͜ͱ͕Ͱ͖·͢ɻ §4ZOUBY TRM 64*/(
    SBOHF
    <4&-&$5
    c
    8*5)
    
    4&-&$5> XIFSF
    DPMVNOSBOHF
    BOE
     - SBOHFͷ஋͸ɺ42-
    ΫΤϦΛ࣮ߦ͢Δࡍʹ࢖༻͢Δ஋ΛؚΉ 1ZUIPO
    ͷϦετ·ͨ͸഑ྻ Ͱ͢ɻ 50
51. IBM Cloud 51 %C
    42-
    ฒྻॲཧ §ฒྻεϨουΛ࢖༻͢ΔͨΊʹ͸ɺ࢖༻Ͱ͖ΔεϨουͷ࠷େ਺Λઃఆ͠·͢ɻ TRM 4&5
    5)3&"%4
    <>
    ·ͨ͸ TRM 015*0/4
    5)3&"%4
    <> §
    ·ͨ͸ 
    Λࢦఆ͢Δͱɺ୯ҰεϨουͰΫΤϦΛ࣮ߦ͠·͢ɻ TRM 4&5
    5)3&"%4
     §ΑΓେ͖͍஋Λࢦఆ͢ΔͱɺYݸͷεϨου͕ੜ੒͞ΕɺͦΕͧΕͷεϨου͕ SBOHFύϥϝʔλͰࢦఆ͞Εͨൣғͷ͏ͪͷͭͷ42-จΛ࣮ߦ͠·͢ɻ §ྫ͑͹ɺ࣍ͷΑ͏ͳม਺͕ઃఆ͞Ε͍ͯΔͱ͠·͢ EFQBSUNFOUT
    
    <" " # #> §࣍ͷ42-͸ɺΫΤϦΛճʢ֤஋ʹճʣ࣮ߦ͠·͢ TRM 64*/(
    EFQBSUNFOUT
    4&-&$5
    %&15/0
    $06/5
    '30.
    %&154 8)&3&
    %&15/0EFQBSUNFOUT 51
52. IBM Cloud 52 -JWF
    -BCT §JCNDPNEFNPT
    ʹΞΫηεͯ͠%CΛݕࡧ §৽͍͠-JWF -BC͸ؒ΋ͳ͘ར༻Մೳ - %C
    .BHJD
    $PNNBOET
    BOE
    1SPHSBNNJOH
    JO
    1ZUIPO - %C
    
    42-
    'FBUVSFT
    BOE
    'VODUJPOT - %C
    
    42-
    'FBUVSFT
    BOE
    'VODUJPOT - "O
    *OUSPEVDUJPO
    UP
    &YUFSOBM
    5BCMFT - 6TJOH
    UIF
    /FX
    +40/
    *40
    'VODUJPOT
    JO
    %C - 5IF
    %C
    %BUB
    .BOBHFNFOU
    $POTPMF
    BOE
    3&45GVM
    "1*T - %C
    PO
    $MPVE
    5VUPSJBM - 6TJOH
    7JTVBM
    4UVEJP
    $PEF
    BOE
    UIF
    (0
    -BOHVBHF §खॱ - 
    *#.ͷϢʔβʔ*%ͰαΠϯΞοϓ͢Δ - 
    ϥϘͷબ୒ - 
    ϥϘͷ४උ͕Ͱ͖ͨͱ͍͏ϝʔϧΛ଴ͭʢʙ෼ʣɻ - 
    ୳ݕ͠Α͏ 52
53. IBM Cloud 53 ௥ՃϦιʔε § %JHJUBM
    5FDIOJDBM
    &OHBHFNFOU
    4JUFʹΞΫηε - %JHJUBM
    5FDIOJDBM
    &OHBHFNFOU
    HSPVQ
    %5& ͸ɺϏσΦɺ੡඼πΞʔɺ੡඼ϥϘΛఏڙ͠ɺ͓ ٬༷͕ࣗ༝ʹٕज़Λࢼ͢͜ͱ͕Ͱ͖ΔΑ͏ʹ͍ͯ͠·͢ɻ - ੡඼ϥϘ͸ɺ͓٬༷ͷͨΊʹ༻ҙ͞Εͨ׬શʹػೳ͢ΔαʔόʔͰ͢ɻ - ͜ΕΒͷαʔόʔʹ͸ɺجຊ੡඼ʢ%Cʣͱࣗश༻ͷαϯϓϧؚ͕·Ε͍ͯ·͢ɻ - IUUQTXXXJCNDPNEFNPT § ৽͍͠%C
    +40/
    #PPL - JCNCJ[ECKTPO § (JU)VC
    %C4BNQMFT - %CͷαϯϓϧϓϩάϥϜ͸(JU)VCʹଟ਺ެ։͞Ε͍ͯ·͢ɻ - IUUQTHJUIVCDPN*#.ECTBNQMFT
54. IBM Cloud 54 Db2 and Jupyter Notebooks — George Baklarz Db2 Digital Technical Engagement ೔ຊޠ༁ ੢ށ ژࢠ ,ZPLP
    /JTIJUP ೔ຊΞΠɾϏʔɾΤϜגࣜձࣾ ςΫϊϩδʔࣄۀ෦ %BUB
    
    "*
    5FDIOJDBM
    4BMFT