How to convert VARCHAR to SMALLINT using DB2?
ans:CAST(B.mySmallIntAsString AS DECIMAL)
How to run sql script from db2 console?
db2 -tvf script_name.sql -z logfile_name.log
Prevent db2 attempts to process all the SQL in the file
and posts errors as they occur.
Use -s option. It will stop at the first error.
db2 -s -tvf
No comments:
Post a Comment