Code: Select all
CREATE SET TABLE decimalerror ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Col1 DECIMAL(5,2))
PRIMARY INDEX ( Col1 );
- 50.00
124.00
12.00
167.09
- 0.05000
0.16709
0.12400
0.01200
Moderators: chulett, rschirm, roy
Code: Select all
CREATE SET TABLE decimalerror ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Col1 DECIMAL(5,2))
PRIMARY INDEX ( Col1 );
You might want to expand a little bit on that... 'changed the code' from what? Didn't this come up in your testing before you did a wholesale change to 'more than 2000 jobs'?shershahkhan wrote:its a migration project, i have changed the code to Teradata for more then 2000 jobs.