GET_SQL_SCRIPT_CHUNK¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command returns a chunk of the script generated from the restructuring done inside of ENABLE_SCRIPTING and DISABLE_SCRIPTING. Since some scripts can be very large, the script can be looped through, grabbing chunks at a time.

Syntax

GET_SQL_SCRIPT_CHUNK OFFSET {offset} to {variable} [{length}]

Parameter	Description
offset	Specifies the offset to start at for the chunk
variable	Variable to hold the chunk
length	Length of chunk returned (optional)

Example

ENABLE_SCRIPTING
    //Table restructuring would go here
DISABLE_SCRIPTING

GET_SQL_SCRIPT_CHUNK OFFSET 0 to sChunk sLength
Showln sChunk

ENABLE_SCRIPTING
DISABLE_SCRIPTING
GET_INT_CHUNK