Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Location
    Blumenau - SC - Brazil
    Posts
    11

    Question Unanswered: Informix 7.30.TC3 and 7.31.UC4

    Hello!
    I have the select below that runs OK on my Informix Dynamic Sever 7.30.TC3
    When I run it on 7.31.UC4 on dbaccess, it hangs and I have no return.
    If I change
    AND (R034FUN.NUMCAD = 4602 OR R034FUN.NUMCAD = 4024)
    to AND (R034FUN.NUMCAD = 4602) (using only one value)
    the command goes OK.

    Is there a bug in 7.31 that was not in 7.30?

    Thanks to all!

    SELECT DISTINCT
    R034FUN.NUMEMP R034FUNNUMEMP,
    R034FUN.TIPCOL R034FUNTIPCOL,
    R034FUN.NUMCAD R034FUNNUMCAD,
    R038HCA.NUMEMP R038HCANUMEMP,
    R038HCA.TIPCOL R038HCATIPCOL,
    R038HCA.NUMCAD R038HCANUMCAD,
    R038HCA.DATALT R038HCADATALT,
    R038HCA.CODCAR R038HCACODCAR,
    R038HCA.ESTCAR R038HCAESTCAR,
    R038HFI.NUMEMP R038HFINUMEMP,
    R038HFI.TIPCOL R038HFITIPCOL,
    R038HFI.NUMCAD R038HFINUMCAD,
    R038HFI.DATALT R038HFIDATALT,
    R038HFI.CODFIL R038HFICODFIL,
    R038HFI.EMPATU R038HFIEMPATU,
    R016HIE.TABORG R016HIETABORG,
    R016HIE.NUMLOC R016HIENUMLOC,
    R016HIE.DATINI R016HIEDATINI,
    R016HIE.CODLOC R016HIECODLOC,
    R034FUN.ESTCAR R034FUNESTCAR,
    R034FUN.CODCAR R034FUNCODCAR,
    R034FUN.CODCHA R034FUNCODCHA,
    R034FUN.NOMFUN R034FUNNOMFUN,
    R034FUN.DATADM R034FUNDATADM,
    R038HLO.NUMEMP R038HLONUMEMP,
    R038HLO.TIPCOL R038HLOTIPCOL,
    R038HLO.NUMCAD R038HLONUMCAD,
    R038HLO.DATALT R038HLODATALT,
    R038HLO.TABORG R038HLOTABORG,
    R038HLO.NUMLOC R038HLONUMLOC,
    R030EMP.NUMEMP R030EMPNUMEMP,
    R016HIE.POSLOC R016HIEPOSLOC,
    R038HVI.NUMEMP R038HVINUMEMP,
    R038HVI.TIPCOL R038HVITIPCOL,
    R038HVI.NUMCAD R038HVINUMCAD,
    R038HVI.DATALT R038HVIDATALT,
    R038HVI.CODVIN R038HVICODVIN,
    '000' NIV00,
    R034FUN.TIPCON R034FUNTIPCON,
    R034FUN.CODEST R034FUNCODEST,
    R030EMP.NOMEMP R030EMPNOMEMP
    FROM R034FUN, R038HCA, R038HFI, R016HIE,
    R038HLO, R030EMP, R038HVI, R016ORN, R022VIN
    WHERE R034FUN.NUMEMP = 1
    AND R034FUN.TIPCOL = 1
    AND (R034FUN.NUMCAD = 4602 OR R034FUN.NUMCAD = 4024)
    AND R038HLO.NUMEMP = R034FUN.NUMEMP
    AND R038HLO.TIPCOL = R034FUN.TIPCOL
    AND R038HLO.NUMCAD = R034FUN.NUMCAD
    AND R038HFI.NUMEMP = R034FUN.NUMEMP
    AND R038HFI.TIPCOL = R034FUN.TIPCOL
    AND R038HFI.NUMCAD = R034FUN.NUMCAD
    AND R038HCA.NUMEMP = R034FUN.NUMEMP
    AND R038HCA.TIPCOL = R034FUN.TIPCOL
    AND R038HCA.NUMCAD = R034FUN.NUMCAD
    AND R016HIE.TABORG = R038HLO.TABORG
    AND R016HIE.NUMLOC = R038HLO.NUMLOC
    AND R016HIE.DATINI <= DATETIME(2003-6-30)YEAR TO DAY
    AND R016HIE.DATFIM >= DATETIME(2003-6-30)YEAR TO DAY
    AND R038HLO.TABORG = R016ORN.TABORG AND
    R038HLO.NUMLOC = R016ORN.NUMLOC
    AND R030EMP.NUMEMP = R034FUN.NUMEMP
    AND R034FUN.NUMEMP = R038HVI.NUMEMP
    AND R034FUN.TIPCOL = R038HVI.TIPCOL
    AND R034FUN.NUMCAD = R038HVI.NUMCAD
    AND R038HVI.CODVIN = R022VIN.CODVIN
    AND R022VIN.CALFOL = 'S'
    AND R038HLO.DATALT =
    (SELECT MAX(DATALT)
    FROM R038HLO TABELA001
    WHERE TABELA001.NUMEMP = R038HLO.NUMEMP
    AND TABELA001.TIPCOL = R038HLO.TIPCOL
    AND TABELA001.NUMCAD = R038HLO.NUMCAD
    AND TABELA001.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
    AND R038HFI.DATALT =
    (SELECT MAX(DATALT)
    FROM R038HFI TAB2
    WHERE TAB2.NUMEMP = R038HFI.NUMEMP
    AND TAB2.TIPCOL = R038HFI.TIPCOL
    AND TAB2.NUMCAD = R038HFI.NUMCAD
    AND TAB2.NUMEMP = TAB2.EMPATU
    AND TAB2.NUMCAD = TAB2.CADATU
    AND TAB2.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
    AND R038HCA.DATALT =
    (SELECT MAX(DATALT)
    FROM R038HCA TABELA002
    WHERE TABELA002.NUMEMP = R038HCA.NUMEMP
    AND TABELA002.TIPCOL = R038HCA.TIPCOL
    AND TABELA002.NUMCAD = R038HCA.NUMCAD
    AND TABELA002.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
    AND R038HVI.DATALT =
    (SELECT MAX(DATALT) FROM R038HVI TABELA003
    WHERE TABELA003.NUMEMP = R038HVI.NUMEMP
    AND TABELA003.TIPCOL = R038HVI.TIPCOL
    AND TABELA003.NUMCAD = R038HVI.NUMCAD
    AND TABELA003.DATALT <= DATETIME(2003-6-30)YEAR TO DAY)
    AND 0 = 0 AND 1 = 1 ORDER BY 1 ASC,23 ASC,3 ASC

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hi,

    I would suggest you test this qry with the lastest version of Informix.
    It is always possible there was a bug - but in that case it wil certainly be fixed by now (9.40.UC2).
    rws

  3. #3
    Join Date
    Mar 2003
    Location
    Blumenau - SC - Brazil
    Posts
    11
    Unfortunetly the I can't change the DB version.
    Which is the latest patch for this version?

    It's only one report in the role system that doesn't works...

    Thanks so far
    Regards!

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I think development is currently at level 7.31.UD7.
    UD6 should be GA soon.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •