I have used it like this:
Prodtr_lev:
Load
AcYrPr
as Avstämmningsperiod
,
Replace
(trim(upper(InvoRef)),' ','')
as InvoRef
,
DAm
as DAm
,
OrdNo
,
SupNo
,
TransSt
,
ExcPrint
,
Num
(TransSt,'(bin)')
as Transstatus
,
Num
(ProcMt,'(bin)')
as Bitvalue1
,
Num
(ExcPrint,'(bin)')
as Bitvalue2
,
Num
(EditPref,'(bin)')
as Bitvalue3
,
Num
(EdFmt,'(bin)')
as Bitvalue4
,
Num
(SpecFunc,'(bin)')
as Bitvalue5
;
SQL
SELECT *
FROM
$(Company) .dbo.ProdTr
Where
TrTp = 6 and FinDt >= 20100501 and (SupNo <> 0 or SupNo = 1001);
//and OrdNo <> 1;// and Ctrl = 0;
Temp:
Noconcatenate
Load
*
,
if
(16384 Bitand Bitvalue2 = 16384,1,0)
as Bv2
,
if
(16 Bitand Transstatus = 16,1,0)
as Trst
Resident
Prodtr_lev;
and in Where clause:
WHERE
OrdNo > 35600
AND TrTp = 1
AND applymap('mOrdTp',OrdNo) <= 4
And OrdLnSt bitand 8 = false() ;
