db2 "select * from tn "SQL30020N Execution of the command or SQL statement failed because of asyntax error in the communication data stream that will affect the successfulexecution of subsequent commands and SQL statements: Reason Code"0x220A"("0100")"". SQLSTATE=58009

FEDDB is Federated database

db2 connect to FEDDB

db2 "CREATE NICKNAME n1 FOR SD3SERVER.user1.tn

DB21034E The command was processed as an SQL statement because it was

not a valid Command Line Processor command. During SQL processing it

returned:

SQL0901N The SQL statement failed because of a non-severe system error.

Subsequent SQL statements can be processed. (Reason "Invalid nickname

column length".) SQLSTATE=58004

Explanation

The maximum precision/scale the DB2/LUW supports is 31. You can NOT query numeric type with precision > 31. This is documented here:

A decimal value is a packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits.