{"id":4312,"date":"2018-11-05T09:17:13","date_gmt":"2018-11-05T00:17:13","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=4312"},"modified":"2018-11-05T09:17:13","modified_gmt":"2018-11-05T00:17:13","slug":"dbmoto%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88%e3%82%ab%e3%83%a9%e3%83%a0%e3%82%92%e7%b5%90%e5%90%88%e3%83%bb%e5%88%86%e5%89%b2%e3%81%97%e3%81%9f%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/4312","title":{"rendered":"[DBMoto][\u30b9\u30af\u30ea\u30d7\u30c8]\u30ab\u30e9\u30e0\u3092\u7d50\u5408\u30fb\u5206\u5272\u3057\u305f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3"},"content":{"rendered":"

\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u9593\u306e\u53cc\u65b9\u5411\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30ebDBMoto<\/a>\u3067\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u30ab\u30e9\u30e0\u306e\u7d50\u5408\u30fb\u5206\u5272\u3092\u884c\u3044\u306a\u304c\u3089\u30c7\u30fc\u30bf\u3092\u540c\u671f\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\u4eca\u56de\u306e\u8a18\u4e8b\u3067\u306f\u53cc\u65b9\u5411\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u304a\u3044\u3066\u30ab\u30e9\u30e0\u306e\u7d50\u5408\u30fb\u5206\u5272\u3092\u5b9f\u73fe\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u3068\u305d\u306e\u8a2d\u5b9a\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3044\u305f\u3057\u307e\u3059\u3002<\/p>\n

\uff11\uff0e\u30ab\u30e9\u30e0\u306e\u7d50\u5408<\/strong><\/p>\n

\u4eca\u56de\u306f\u4f8b\u3068\u3057\u3066\u3001\u4e0b\u8a18\u56f3\u306e\u3088\u3046\u306bAS\/400\u306e\uff12\u3064\u306e\u6570\u5024\u578b\u30ab\u30e9\u30e0\u3092\u7d50\u5408\u3057\u3066\u3001SQL Server\u306e\u65e5\u4ed8\u578b\u30ab\u30e9\u30e0\u3078\u3068\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3044\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n

\u307e\u305a\u306fDBMoto\u7ba1\u7406\u753b\u9762\u5de6\u4e0a\u306b\u3042\u308b\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u3055\u308c\u305fDBMoto\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u753b\u9762\u3067\u4e0b\u8a18\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002VB\u30b9\u30af\u30ea\u30d7\u30c8\u306a\u306e\u3067\u30b9\u30af\u30ea\u30d7\u30c8\u8a00\u8a9e\u306fVB\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n

\r\nImports System\r\nImports System.Data\r\nImports Microsoft.VisualBasic\r\nImports DBMotoPublic\r\nImports DBMotoScript\r\n\r\nNamespace DBRS\r\n    Public Class GlobalScript : Inherits IGlobalScript        \r\n        \r\n        'AS\/400 to SQL Server CONVERTTODATETIME\r\n        Public Shared Function CONVERTTODATETIME (objDate As Object, objTime As Object) As Object              \r\n            If (objDate Is Nothing OrElse objDate Is System.DBNull.Value) Or (objTime Is Nothing OrElse objTime Is System.DBNull.Value)  Then\r\n                CONVERTTODATETIME = System.DBNull.Value\r\n            Else  \r\n                CONVERTTODATETIME = New DateTime(Left(objDate.ToString(),4) , Mid(objDate.ToString(),5,2), Right(objDate.ToString(),2), Left(objTime.ToString(),2), Mid(objTime.ToString(),3,2), Right(objTime.ToString(),2))\r\n            End If\r\n        End Function\r\n        \r\n    End Class\r\n\r\n    Public Class MappingRule : Inherits IMappingRule\r\n\r\n    End Class\r\n\r\n    Public Class CreateTableRule : Inherits ICreateTableRule\r\n\r\n    End Class\r\n\r\n    Public Class GlobalEvents : Inherits IGlobalEvents\r\n\r\n    End Class\r\nEnd Namespace\r\n\r\n<\/pre>\n
\u305d\u306e\u5f8c\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u30de\u30c3\u30d4\u30f3\u30b0\u8a2d\u5b9a\u304b\u3089\u7d50\u5408\u3059\u308b\u30ab\u30e9\u30e0\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u4eca\u56de\u306fC2\u30ab\u30e9\u30e0\u3068C3\u30ab\u30e9\u30e0\u3092\u7d50\u5408\u3059\u308b\u306e\u3067\u3001C2\u30ab\u30e9\u30e0\u304b\u3089\u51fa\u3066\u3044\u308b\u77e2\u5370\u3092\u53f3\u30af\u30ea\u30c3\u30af > \u95a2\u6570\u3078\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u3067\u4e0b\u8a18\u95a2\u6570\u3092\u5165\u529b\u3057\u307e\u3059\u3002
\nCONVERTTODATETIME([C2],[C3])<\/strong>
\n\"\"<\/a><\/p>\n
\u95a2\u6570\u5165\u529b\u5f8c\u3001\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u304b\u3089\u30de\u30c3\u30d4\u30f3\u30b0\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n
\u8a2d\u5b9a\u304c\u5b8c\u4e86\u3057\u305f\u3089\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002AS\/400\u306e\u30c7\u30fc\u30bf\u304c\u7d50\u5408\u3055\u308cSQL Server\u306b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3055\u308c\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n
\uff12\uff0e\u30ab\u30e9\u30e0\u306e\u5206\u5272<\/strong>
\n\u4eca\u5ea6\u306f\u9006\u306bSQL Server\u306e\u65e5\u4ed8\u578b\u30ab\u30e9\u30e0\u3092\u5206\u5272\u3057\u3001AS\/400\u306e\uff12\u3064\u306e\u6570\u5024\u578b\u30ab\u30e9\u30e0\u306b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n
\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u4e0b\u8a18\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n
\r\nImports System\r\nImports System.Data\r\nImports Microsoft.VisualBasic\r\nImports DBMotoPublic\r\nImports DBMotoScript\r\n\r\nNamespace DBRS\r\n    Public Class GlobalScript : Inherits IGlobalScript        \r\n        \r\n        'AS\/400 to SQL Server CONVERT TO DATETIME\r\n        Public Shared Function CONVERTTODATETIME (objDate as Object, objTime as Object) as Object              \r\n            If (objDate Is Nothing OrElse objDate Is System.DBNull.Value) Or (objTime Is Nothing OrElse objTime Is System.DBNull.Value)  Then\r\n                CONVERTTODATETIME = System.DBNull.Value\r\n            Else  \r\n                CONVERTTODATETIME = new DateTime(Left(objDate.ToString(),4) , Mid(objDate.ToString(),5,2), Right(objDate.ToString(),2), Left(objTime.ToString(),2), Mid(objTime.ToString(),3,2), Right(objTime.ToString(),2))\r\n            End if\r\n        End Function\r\n        \r\n        'SQL Server to AS\/400 CONVERT TO NUMBER(yyyymmdd)\r\n        Public Shared Function CONVERTDATETONUMBER(objDate as Object) as Object\r\n            Dim dtDate as DateTime               \r\n            If objDate Is Nothing OrElse objDate Is System.DBNull.Value Then\r\n                CONVERTDATETONUMBER = System.DBNull.Value\r\n            Else  \r\n                dtDate = objDate\r\n                CONVERTDATETONUMBER = dtDate.Year * 10000 + dtDate.Month * 100 + dtDate.Day            \r\n            End if\r\n        End Function\r\n        \r\n        'SQL Server to AS\/400 CONVERT TO NUMBER(hhmmss)\r\n        Public Shared Function CONVERTDATETOTIME (objDate as Object) as Object\r\n            Dim dtDate as DateTime               \r\n            If objDate Is Nothing OrElse objDate Is System.DBNull.Value Then\r\n                CONVERTDATETOTIME = System.DBNull.Value\r\n            Else  \r\n                dtDate = objDate\r\n                CONVERTDATETOTIME = dtDate.Hour * 10000 + dtDate.Minute * 100 + dtDate.Second           \r\n            End if\r\n        End Function\r\n        \r\n    End Class\r\n\r\n    Public Class MappingRule : Inherits IMappingRule\r\n        \r\n    End Class\r\n\r\n    Public Class CreateTableRule : Inherits ICreateTableRule\r\n\r\n    End Class\r\n\r\n    Public Class GlobalEvents : Inherits IGlobalEvents\r\n\r\n    End Class\r\nEnd Namespace\r\n\r\n<\/pre>\n
\u305d\u306e\u5f8c\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u30de\u30c3\u30d4\u30f3\u30b0\u8a2d\u5b9a\u306b\u5206\u5272\u3059\u308b\u30ab\u30e9\u30e0\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u77e2\u5370\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u9006\u5411\u304d\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8a2d\u5b9a\u753b\u9762\u306b\u3057\u305f\u5f8c\u3001\u5404\u30ab\u30e9\u30e0\u306b\u30c9\u30e9\u30c3\u30af&\u30c9\u30ed\u30c3\u30d7\u3067\u30de\u30c3\u30d4\u30f3\u30b0\u3057\u3001\u5404\u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u3067\u305d\u308c\u305e\u308c\u4e0b\u8a18\u95a2\u6570\u3092\u5165\u529b\u3057\u307e\u3059\u3002
\nCONVERTDATETONUMBER([C2])<\/strong>
\nCONVERTDATETOTIME([C2])<\/strong>
\n\"\"<\/a><\/p>\n
\u4e0b\u306e\u753b\u9762\u306fSQL Server\u306eC2\u30ab\u30e9\u30e0\u304b\u3089AS\/400\u306eC3\u30ab\u30e9\u30e0\u306b\u30c9\u30e9\u30c3\u30b0&\u30c9\u30ed\u30c3\u30d7\u3067\u30de\u30c3\u30d4\u30f3\u30b0\u3057\u305f\u5f8c\u306b\u95a2\u6570\u8a2d\u5b9a\u3092\u884c\u3063\u3066\u304a\u308a\u307e\u3059\u3002
\n\"\"<\/a>\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u3001SQL Server\u306e\u30c7\u30fc\u30bf\u304c\u5206\u5272\u3055\u308cAS\/400\u306e\u5404\u30ab\u30e9\u30e0\u306b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3055\u308c\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u9593\u306e\u53cc\u65b9\u5411\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30ebDBMoto\u3067\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u30ab\u30e9\u30e0\u306e\u7d50\u5408\u30fb\u5206\u5272\u3092\u884c\u3044\u306a\u304c\u3089\u30c7\u30fc\u30bf\u3092\u540c\u671f\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\u4eca\u56de\u306e\u8a18\u4e8b\u3067\u306f\u53cc\u65b9\u5411\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u304a\u3044\u3066\u30ab\u30e9\u30e0\u306e\u7d50\u5408\u30fb\u5206\u5272\u3092\u5b9f … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[197,286,287,288],"class_list":["post-4312","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-197","tag-286","tag-287","tag-288"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/4312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=4312"}],"version-history":[{"count":4,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/4312\/revisions"}],"predecessor-version":[{"id":4859,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/4312\/revisions\/4859"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=4312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=4312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=4312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}