I will update the guide with what I found out. This is a very helpful debugging skill, should be documented.
Thanks, Ming -----邮件原件----- 发件人: Anoop Sharma [mailto:[email protected]] 发送时间: 2016年2月28日 3:56 收件人: [email protected] 主题: RE: 答复: how to abort for a given SQL Error? yes, will be good to add this kind of info to the guide. Would also suggest that the person who initially asked the question should collect/collate/document after testing that the solution works. They can also add an example of how they tested it. anoop -----Original Message----- From: Gunnar Tapper [mailto:[email protected]] Sent: Saturday, February 27, 2016 9:42 AM To: [email protected] Subject: Re: 答复: how to abort for a given SQL Error? It's always good to capture this type of information in the Contributor Guide How-To section. In this case: https://cwiki.apache.org/confluence/display/TRAFODION/How-To#How-To-ForceCoreDumponSpecificSQLError Please edit if needed. Thanks, Gunnar On Sat, Feb 27, 2016 at 8:53 AM, Liu, Ming (Ming) <[email protected]> wrote: > Thanks Anoop and Qifan, > > I tested, by modifying ms.evn, it works well. > This is a very convenient debug weapon! > > Best Regards, > Ming > > -----邮件原件----- > 发件人: Anoop Sharma [mailto:[email protected]] > 发送时间: 2016年2月27日 23:44 > 收件人: [email protected] > 主题: RE: how to abort for a given SQL Error? > > > from sqlci: > set ennvar abort_on_error '<errnum>'; > > Or set this envvar in shell before running your query. > > anoop > > -----Original Message----- > From: Liu, Ming (Ming) [mailto:[email protected]] > Sent: Saturday, February 27, 2016 7:38 AM > To: [email protected] > Subject: how to abort for a given SQL Error? > > Hi, all, > > I think it is possible to configure Trafodion to abort and core dump > for specific SQL Error, for debug purpose, could anyone share with me > how to do that? > For example, for a given SQL error 15001, I want compiler abort > immediately so that I can know in which code path that error is detected . > > Thanks, > Ming > > > -- Thanks, Gunnar *If you think you can you can, if you think you can't you're right.*
