Command Reference

db2profp - DB2 SQLJ Profile Printer

Prints the contents of a DB2 customized version of a profile in plain text.

Authorization

None

Required Connection

This command establishes a database connection.

Command Syntax

>>-db2profp----+-----------------------------------------+------>
               '--user=--username---password=--password--'
 
                        .----------------.
                        V                |
>-----url=--JDBC-url-------profilename---+---------------------><
 

Command Parameters

-user= username

Specifies the name used when connecting to a database to print the customized profile.

-password= password

Specifies the password for the user name.

-url= JDBC-url

Specifies a JDBC URL for establishing the database connection.

profilename

Specifies one or more profiles in which SQL statements are stored. When an SQLJ file is translated into a Java file, information about the SQL operations it contains is stored in SQLJ-generated resource files called profiles. Profiles are identified by the suffix _SJProfileN (where N is an integer) following the name of the original input file. They have a .ser extension. Profile names can be specified with or without the .ser extension.

Examples

   db2profp -user=username -password=password -url=JDBC-url
      pgmname_SJProfile1.ser                                          

Usage Notes

For more information about SQLJ, see the Application Development Guide.

See Also

db2profc - DB2 SQLJ Profile Customizer.