COZZI - Retrieve SQL Source (RTVSQLSRC)

Where allowed to run: All environments (*ALL)
Threadsafe: No
Parameters
Examples
Error messages

Parameters

Keyword Description Choices Notes
FILE File name Qualified object name Required, Positional 1
Qualifier 1: File name Name
Qualifier 2: Library Name, *CURLIB, *LIBL
SRCFILE Source file name Qualified object name Optional, Positional 2
Qualifier 1: Source file name Name, QSQLSRC
Qualifier 2: Library Name, *CURLIB, *LIBL
SRCMBR Source member Name, *FILE Optional, Positional 3
REPLACE Replace source member Logical value, *YES, *NO, *ON, *OFF, *REPLACE, *NOREPLACE Optional, Positional 4
NAMING Qualified name syntax *SYS, *SQL Optional, Positional 5
SQLLVL SQL Standards syntax *SYS, *DB2SQL, *ANSISQL Optional, Positional 6
GENDROP Generate DROP file statement *NO, *YES Optional, Positional 7
COMMENT Generate header comments *YES, *NO Optional, Positional 8
MSGLVL Message generation level 0-39, 30 Optional, Positional 9
SEVLVL Error severity level to fail 0, 10, 20, 30, 40 Optional, Positional 10
Top

Examples

None
Top

Error messages

Unknown
Top