To generate the SQL statements for an i5/OS SQL object, enter the RTVSQLSTMT command from the i5/OS system where PowerExchange is installed. The PowerExchange

dtllib

library must be in the current library list for the i5/OS job. The RTVSQLSTMT command prompts you for a series of parameters that control what SQL statements are generated. The RTVSQLSTMT command validates your entries to reduce the risk of errors.

The command can generate DDL statements for re-creating many types of objects, including aliases, constraints, indexes, procedures, schemas (libraries or collections), tables, triggers, and views. The command can also generate GRANT statements that provide the authority required to use the objects. Options are available to control the types of SQL statements to generate. For example, you can control whether to generate DROP statements that precede the CREATE statements for the selected object types. Also, the command can generate SQL statements even for some objects that were not created with SQL. For example, if you used data description specifications (DDS) to define physical and logical database files, the command can generate equivalent SQL CREATE statements to re-create those files.

The following sample command shows all of the required and optional parameters:

RTVSQLSTMT

SQLOBJNAM

(SQL_OBJECT_NAME)

SQLOBJLIB

(OBJECT_LIB)

SQLTYPE

(*TYPE)

SRCFILE

(SOURCE_LIB/QSQLSRC)

SRCMBR

(SQLOBJNAM)

RPLSRCMBR

(*NO)

CRTDROP

(*NO)

CRTCOMMENT

(*NO)

CRTHEADER

(*NO)

CRTTRIGGER

(*NO)

CRTCONSTR

(*NO)

CRTRENAME

(*NO)

CRTGRANT

(*NO)

GENCCSID

(*NO)

CRTORRPL

(*NO)

CRTOBFSTM

(*NO)

ACTROWCOL

(*NO)

CRTMSKPRM

(*NO)

CRTQUALSTM

(*NO)

CRTADDINDX

(*NO)

CRTVWINDX

(*NO)

After you run the command, the command writes the SQL statements to the source file member that you specified. If a member that has the same source member name already exists, you can configure the RPLSRCMBR parameter to indicate whether to replace it.

Send the source file member that contains the SQL statements to Informatica Global Customer Support. Support personnel can then run the SQL statements on another machine to re-create the environment in which your error occurred.

For information about the validation messages that PowerExchange generates when you use the interface, see messages DTL5001 through DTL5008 in the

PowerExchange Message Reference Volume 3

.