View Attach (1) Info

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
rpgle
 XJAC05_SM.rpgle 112.3 kB 1 14-Apr-2010 14:30 MattiaRocchi SQLRPGLE per Web.up

This page (revision-16) was last changed on 14-Apr-2010 14:30 by MarcoDePasquale  

This page was created on 14-Apr-2010 14:30 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 115 added 27 lines
----
Due annotazioni...
!! Clausola Order in inserimento
insert into QTEMP.XJAC05_SM
select distinct MPCD01 as CLI,MPCD02 as ART from SMEUP_TPER.MPPIAN0F where MPCDPI='BUD09' and MPCD01='005948' and MPCD02 like '6028005%'
union
(select distinct CLCC06 as CLI,CLCA15 as ART from SMEUP_TPER.XCOCLM0F where (CLANNO BETWEEN 07 and 08) and CLCC06='005948' and CLCA15 like '6028005%')
order by CLI,ART
la __order by CLI,ART__ non dovrebbe essere (almeno a livello generale) significativa giusto?
!! Meglio nella WHERE O nella JOIN?
Da quello che ho capito l'istruzione di WHERE è riferita ad una tabella joinata.
Se viene effettuata una "inner join" dovrebbero essere equivalenti
Se viene effettuata una "left join" verrebbero invece esclusi tutti i record non presenti nella tabella joinata, riconducendola quindi ad una "inner join".
Non sarebbe meglio utilizzare come "best practice" la selezione a livello di clausola JOIN?
Cosa ne pensate?
WHERE A§CLGE='F'
--MarcoDePasquale, 30-ott-2008
Version Date Modified Size Author Changes ... Change note
16 14-Apr-2010 14:30 5.25 kB MarcoDePasquale to previous Comment by MarcoDePasquale
15 14-Apr-2010 14:30 4.218 kB MattiaRocchi to previous | to last
14 14-Apr-2010 14:30 4.218 kB MattiaRocchi to previous | to last
13 14-Apr-2010 14:30 4.216 kB MattiaRocchi to previous | to last
12 14-Apr-2010 14:30 3.758 kB MattiaRocchi to previous | to last
11 14-Apr-2010 14:30 3.736 kB MattiaRocchi to previous | to last
10 14-Apr-2010 14:30 3.658 kB MattiaRocchi to previous | to last
9 14-Apr-2010 14:30 3.605 kB MattiaRocchi to previous | to last
8 14-Apr-2010 14:30 3.466 kB MattiaRocchi to previous | to last
7 14-Apr-2010 14:30 3.399 kB MattiaRocchi to previous | to last
6 14-Apr-2010 14:30 3.398 kB Administrator to previous | to last
5 14-Apr-2010 14:30 3.383 kB Administrator to previous | to last
4 14-Apr-2010 14:30 3.328 kB Administrator to previous | to last
3 14-Apr-2010 14:30 3.31 kB Administrator to previous | to last
2 14-Apr-2010 14:30 3.311 kB Administrator to previous | to last
1 14-Apr-2010 14:30 0.067 kB Administrator to last
« This page (revision-16) was last changed on 14-Apr-2010 14:30 by MarcoDePasquale