3 db2 create table decimalTable ( c1 decimal( 31, 2 ) ) 3 db2 insert into decimalTable values ( 1.1 ) 3 3 db2 export to data of del select * from decimalTable 3 3 db2 export to data of del modified by STRIPLZEROS 3 select * from decimalTable
3In the first export operation, the content of the exported file data will 3be +00000000000000000000000000001.10. In the second operation, 3which is identical to the first except for the striplzeros 3modifier, the content of the exported file data will be +1.10. 3
3The updated syntax is as follows:
3>>-+-db2sqljcustomize-+--+-------+------------------------------> 3 '-db2profc---------' '--help-' 3 3>--+--url jdbc:db2://server:port/dbname---user--username---password--password-+--> 3 '--datasource--jndiName----------------------------------------------------' 3 3 .--automaticbind--+-YES-+-. 3 | '-NO--' | 3>--+-------------------------+----------------------------------> 3 3>--+------------------------------+--+-------------------+------> 3 '--bindoptions--"bind options"-' '--collection--name-' 3 3 .--onlinecheck--+-YES-+-. 3 | '-NO--' | 3>--+-----------------------+--+------------------+--------------> 3 '--qualifier--name-' 3 3 .--staticpositioned--+-NO--+-. 3 | '-YES-' | 3>--+----------------------+--+----------------------------+-----> 3 +--rootpkgname--name---+ 3 '--singlepkgname--name-' 3 3>--+-----------------------------------------------------------------------+--> 3 '--tracefile--name--+-------------------------------------------------+-' 3 | .-,------------------------------. | 3 | V .-TRACE_ALL------------------. | | 3 '--tracelevel----+----------------------------+-+-' 3 +-TRACE_CONNECTION_CALLS-----+ 3 +-TRACE_CONNECTS-------------+ 3 +-TRACE_DIAGNOSTICS----------+ 3 +-TRACE_DRDA_FLOWS-----------+ 3 +-TRACE_DRIVER_CONFIGURATION-+ 3 +-TRACE_NONE-----------------+ 3 +-TRACE_PARAMETER_META_DATA--+ 3 +-TRACE_RESULT_SET_CALLS-----+ 3 +-TRACE_RESULT_SET_META_DATA-+ 3 +-TRACE_SQLJ-----------------+ 3 '-TRACE_STATEMENT_CALLS------' 3 3>--+-------------+--profilename-------------------------------->< 3 '--path--path-' 3 33