Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Transformation of update

  1. #1
    Join Date
    Feb 2011
    Posts
    240

    Default Transformation of update

    Hi,

    I've a table (sins_acc) of this fields: ANNO, MESE, CARTELLA, COGNOME_NOME, DATA_NASC, ETA, SESSO, CODICE_FISCALE, COD_COMUNE, COMUNE, COD_AREADIS, AREADIS, COD_ZONA, ZONA, COD_DISTRETTO, DISTRETTO, COD_OPERATORE, OPERATORE, COD_TIPO_OPER, TIPO_OPER, COD_QUAL_OPER, QUAL_OPER, COD_PRESIDIO, PRESIDIO, AMBDOM, NUMERO, T_ACCESSI, T_TEMPOGO

    and I've this:
    update sins_acc set (prestazione_qta, t_prestazioni, c_prestazioni)=
    (select nvl(sum(pre_numero),1),
    nvl(sum(pre_tempo),0),
    nvl(sum(pre_numero*pre_importo),0)
    from sins.intpre, sins.interv
    where to_char(int_data_prest, 'YYYY') = to_char(anno_elab)
    and mese = to_number(to_char(int_data_prest,'MM'),'99')
    and int_anno = pre_anno
    and int_contatore = pre_contatore
    and int_cartella = cartella
    and int_cod_oper = cod_operatore
    and int_tipo_oper = cod_tipo_oper
    and int_qual_oper = cod_qual_oper
    and int_cod_comune = cod_comune
    and int_cod_areadis = cod_areadis
    and int_codpres = cod_presidio
    and int_ambdom = ambdom)
    where anno=anno_elab;
    your opinion, what steps should I use?
    Thanks
    Mariarita

  2. #2
    Join Date
    Oct 2008
    Posts
    23

    Default

    hi mariarita,
    if you want to copy/paste the code, you should put in the job the sql script step

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.