UltraLite User's Guide
  Developing Applications for the Palm Computing Platform
    Building multi-segment applications

Explicitly assigning segments

This section describes how to explicitly assign the generated code for SQL statements to segments. You must first enable multi-segment code generation as described in Enabling multi-segment code generation.

The mechanism for assigning the code is different for the embedded SQL and C++ API development models.

Explicit segment assignment requires a database upgraded to version 8 standards.

To explicitly assign generated statement code to segments (embedded SQL)

• Split your .sqc files into separate files. The generated code for the statements in each .sqc file is placed into a separate segment.

To explicitly assign generated statement code to segments (C++ API)

• Do one of the following:

  • Call the ul_set_codesegment procedure for each SQL statement, providing the name of the segment to which the statement should be assigned.

    For example, the following statement assigns the statement mystmt, in the project myproject, to the segment MYSEG1.

    call ul_set_codesegment( 
         'myproject', 'mystmt', 'MYSEG1' )

    For more information, see ul_set_codesegment system procedure.

  • From Sybase Central, open the UltraLite Project folder. Right click the statement and choose Properties from the popup menu. Enter a code segment name in the box.