Re: Return code in SPL

Posted in 1997

Pete Harris — 3 Oct 1997 00:05:45 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Adam, Take a look at the dbinfo() function. It is written up in the expression part of the guide to sql syntax. It should do the trick. Pete. Adam Pribek <apribek@quality.hu> wrote in article <3433A91D.ADE5E7@quality.hu>... > Hi All, > > can somebody tell me how can I check the sqlcode in SPL? > I think it should be something like this: > if sqlca.sqlcode < 0 then ... > endif, > but when I tried this, the SQL Editor (OnLine Workgroup Server 7.2) said > it had syntax error. > > Suggestions? > > Thanks > Adam > >