vb操作db2存储过程
发布时间:2020-12-16 22:58:30 所属栏目:大数据 来源:网络整理
导读:Dim db2Conn As New DB2Conn() db2Conn.cmd = db2Conn.con.CreateCommand() db2Conn.cmd.CommandType = System.Data.CommandType.StoredProcedure db2Conn.cmd.CommandText = "{ CALL DB2ADMIN.GENERATE_SPLITDATA_BY_PRECINCT(?) }" Dim p1 As Odbc.OdbcPar
Dim db2Conn As New DB2Conn() db2Conn.cmd = db2Conn.con.CreateCommand() db2Conn.cmd.CommandType = System.Data.CommandType.StoredProcedure db2Conn.cmd.CommandText = "{ CALL DB2ADMIN.GENERATE_SPLITDATA_BY_PRECINCT(?) }" Dim p1 As Odbc.OdbcParameter = db2Conn.cmd.CreateParameter() p1.OdbcType = Odbc.OdbcType.Date p1.Value = "2010-07-21" db2Conn.cmd.Parameters.Add(p1) db2Conn.cmd.ExecuteNonQuery() (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |