Answer:
decimal(5,2):
Means, decimal number consists of 5 places which exclude decimal point(.)
Example:
decimal(5,2)==999.99
But
decimal(5.2): Means, decimal number consists of 5 places which include decimal
point(.)
Example:
decimal(5.2)==99.99
Both
will truncate after decimal place(.) and add 0 if less.
2. Meaning of \r\n?
Answer:
\r = CR (Carriage Return) // Used as a new
line character in Mac OS before X
\n = LF (Line Feed) // Used as a new line character in Unix/Mac OS
X
\r\n = CR + LF // Used as a new line character in Windows
Answer:
m_db unload <dbcfilepath> -select
"select fieldname from table" -dml "record decimal('\n')
filename; end")
