在SQL中如何写一个事务?这样就不让其他请求操作这张表了?
解决方案 »
- HttpServletResponse里如何取HttpServletRequest对象?
- sencha touch 中URL传参问题?
- 求助。。jsp问题
- Hibernate主键一对一的保存出现问题
- Glassfish 事务超时问题请教
- 关于list查值的问题`
- 那个好心人给介绍一份J2EE的工作了
- Spring配置置入WebService的问题(急)
- 请教高手们,我是初学者,J2SE中运行简单的"Hello World!"出现错误"Exception in thread "main" java.lang.NoClassDefFoundError: program/
- 请问一个关于JDK的问题
- JSP如何通过JNDI连接SQL Server数据库?(在线等)
- .jsp必须放在tomcat目录下才能运行吗?
错误信息:
Create stored procedure returns -104.
FOS.PR_REUTERS_TTSFX: 210: [IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token "summary" was found following "begin transaction". Expected tokens may include: ":". LINE NUMBER=210. SQLSTATE=42601FOS.PR_REUTERS_TTSFX - Build failed.
begin transaction abc
select LAST_ORDER_NUMBER into refno from ORDER_NUMBER
where ACTIVE_FLAG = 'A' and NUMBER_TYPE = 'ORDER';
update ORDER_NUMBER set LAST_ORDER_NUMBER = LAST_ORDER_NUMBER +1
where ACTIVE_FLAG = 'A' and NUMBER_TYPE = 'ORDER';
end;
commit transaction abc ; 这个语法有问题吗?怎么老报错?
where ACTIVE_FLAG = 'A' and NUMBER_TYPE = 'ORDER';
应该不对,INTO是到一个变量中,这个直接存成表的写法是SQL SERVER的语法,