Tagged Questions
2
votes
1answer
213 views
DB2 equivalent to T-SQL's REPLICATE?
In T-SQL there is a method, REPLICATE(char,N), which will make a string with N values of a certain character. This is very helpful when querying into JDE.
Does anyone know if there is a DB2 ...
4
votes
2answers
1k views
Why do I get leading zeros when converting from decimal to char in a db2 query?
I have a column named length defined as:
TYPE_NAME: DECIMAL
DATA_TYPE: 3
COLUMN_SIZE: 9
BUFFER_LENGTH: 11
DECIMAL_DIGITS: 5
NUM_PREC_RADIX: 10
When I run the following select:
select ...
