Search results

Hi , A little more explanation on the word "packet" , i am not using it for the packet send/recived in this case. When you are using a Break by / First-Of / Last-Of , your query know the "next" record to evaluate the "Last" , i am using the word "packet" for the records that your query "know"...

Hi Adding an index will solve the isuse in most of case . But if the record is in the "packet" received it will not work , You can try the code below there is only 3 record in the Temp-Table instead of 4 and the update is on record "3" . def temp-table tt-test field id as int field...

Hi It is a little bit difficult without the index But You should/could: - replace the CAN-DO by LOOKUP . - (int(substr(corpdata.AFI_FORM_UPDATER.ACTION_DATE,1,4)) = YEAR(mSYSDATE) By corpdata.AFI_FORM_UPDATER.ACTION_DATE Begins String(YEAR(mSYSDATE) , "9999" ) (and perhaps By...

Hi The "truncate area" will not decrease its size , If you want to decrease it , i Think You could use Something like that proutil [db] -C dump proutil [db] -C truncate area [table_area] proutil [db] -C truncate area [idx_area] proutil [db] -C idxbuild table …...