Re: Change opcodes to free format
Looks like your standard and mine are pretty close DAG0000
Looks like your standard and mine are pretty close DAG0000
IF (*IN22 = *ON)
And (@@PACT <> 'I')
Or (*IN23 = *ON)
And (@@PACT <> 'I');
IF *IN22 = *ON And @@PACT <> 'I' Or *IN23 = *ON And @@PACT <> 'I';
Update TAXLIB / f5706 b Set b.$f$nam = (Select a.$f$nam From f5706 A Join f57rel c On a.$f$pcl = c.rprcl1 Join f5706 b1 On c.rprcl2 = b1.$f$pcl Where b.$f$pcl = b1.$f$pcl And rtaxyr = :taxyr And b1.$f$fl1 = 'P' And a.$f$fl1 = 'P') Where b.$f$fl1 = 'P' And Exists (Select * From f57rel c1 Join f5706 b2 On c1.rprcl2 = b2.$f$pcl Where b2.$f$fl1 = 'P' And b.$f$pcl = b2.$f$pcl And rtaxyr = :taxyr);
Exec Sql
Update TAXLIB / f5706 b
Set b.$f$nam = (Select a.$f$nam
From f5706 A
Join f57rel c
On a.$f$pcl = c.rprcl1
Join f5706 b1
On c.rprcl2 = b1.$f$pcl
Where b.$f$pcl = b1.$f$pcl And
rtaxyr = :taxyr And
b1.$f$fl1 = 'P' And
a.$f$fl1 = 'P')
Where b.$f$fl1 = 'P' And
Exists
(Select *
From f57rel c1
Join f5706 b2
On c1.rprcl2 = b2.$f$pcl
Where b2.$f$fl1 = 'P' And
b.$f$pcl = b2.$f$pcl And
rtaxyr = :taxyr);
Comment