Centura SQLWINDOWS / ORACLE Database 7.3 SQL Statements

From: Hans-Jürgen Fillbach <juergen.fillbach_at_snafu.de>
Date: Fri, 2 Jul 1999 13:30:32 +0200
Message-ID: <7li7sc$5js$1@unlisys.unlisys.net>

Hi folks,

I'am working in converting SQLStatements originally designed for Centura sqlwindows for ORACLE Database. The following statement ist too much for me, I need help.

sqlwindows:
insert into STUBUS ( kenner, spalte01, spalte02, spalte03, spalte04, spalte05, spalte06,

                             spalte07, spalte09, spalte11, spalte12,
                             spalte14, spalte15 )

 SELECT '1003', '?', @YEARNO(u.um_27unfallzeit) || '/' || @MONTH(u.um_27unfallzeit),0,
0,
count(*),

sum(u.um_azeittage+@if(@isna(u.um_azeitoffen),0,sysdate-u.um_azeitoffen)),
sum(@if(@EXACT(UM_ISBAGATELL,'1'),1,0)),
sum(@if(@EXACT(UM_MELDEPFLICHTIG,'1'),0,1)),
sum(@if(@EXACT(UM_MELDEPFLICHTIG,'1'),0,u.um_azeittage+@if(@isna(u.um_azeito

ffen),0,sysdate-u.um_azeitoffen))),
sum(@if(@EXACT(UM_MELDEPFLICHTIG,'1'),1,0)), sum(@if(@EXACT(UM_MELDEPFLICHTIG,'1'),u.um_azeittage+@if(@isna(u.um_azeitoff en),0,sysdate-u.um_azeitoffen),0)),
sum(@if(@EXACT(UM_24ISTERTOT,'1'),1,0)) from UM u, ujahrw j
  where u.kst_code = j.kst_code
    and @month(u.um_27unfallzeit) = j.UJAHRW_MONAT and @yearno(u.um_27unfallzeit) = j.UJAHRW_JAHR AND ( u.UM_UNFALL_BK = 'U' AND ( u.UM_27unfallzeit >= @datevalue('1999-06-01') AND u.UM_27unfallzeit <= @datevalue('1999-07-01') ) ) group by 3;

Really nice isn't it?

Can anyone help?
Please answer here or direct to juergen.fillbach_at_snafu.de

thanks Received on Fri Jul 02 1999 - 06:30:32 CDT