To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.

Get date with European format..

DB2 command line utility has different options. In this post we show how to disable the autocommit of DML statements that by default is active. In case you want to do some test, for example, simulating the use of locks could be helpful to disable this feature.

Options from DB2 command line can be obtained with the following sentences: