Release Notes (FixPak 3)

3Command Reference

3

3EXPORT command
3

3Location in the DB2 Information Center accessed from a browser
3Reference -> Commands -> Command Line Processor 3(CLP). This topic was last updated at DB2 Version 38.1.2.

3Location in PDF and printed manuals
3Book Title: Command Reference
3Chapter Title: CLP Commands

3Correction
3striplzeros is a new delimited ASCII file type modifier 3supported by the EXPORT command. It removes the leading zeros from all 3exported decimal columns, as shown in the following example: 

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

3db2sqljcustomize - DB2 SQLJ Profile Customizer command
3

3Location in the DB2 Information Center accessed from a browser
3Reference -> Commands -> System. This topic was 3last updated at DB2 Version 8.1.2.

3Location in PDF and printed manuals
3Book Title: Command Reference
3Chapter Title: System Commands

3Correction
3The db2sqljcustomize command, also known as the 3db2profc command, has had the following options changed or 3added: 3
  • 3A new option, -datasource, has been added. -datasource 3jndiName specifies a JNDI registered DataSource name for establishing 3the database connection for online checking or automatic binding. The 3registered name must map to a Universal Driver data source configured for Type 34 connectivity.
  • 3The default value of the -staticpositioned option is NO.
  • 3A new option, -path, has been added. It identifies the absolute 3path to the root of the .ser file name provided in 3profilename. The path is added in front of the file name 3provided. 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 
3
3
3

[ Top of Page | Previous Page | Next Page | Table of Contents ]