Setting User Preferences

Use the Preferences window to customize groups of settings in Sybase IQ InfoPrimer Development.

  1. From the main Sybase IQ InfoPrimer Development interface, select File > Preferences.
  2. Select Appearance, and set these options:
    • Locale for user interface display – select the locale language for your environment: _de (German), _en_US (US English, the default), or _en_GB (UK English).

    • Show assistant for creating projects – view the assistant that guides you through completing a project, and displays information on the current state of the open project.

    • Default font for displaying text – select the font for displaying text file contents in the Text Data Provider and Text Data Sink component windows. This setting is useful when you work with non-Western character sets, such as Unicode. The default font is Monospaced. The recommended fonts for displaying text are Dialog or Monospaced.

    • Default font for displaying data – select the font for displaying port data throughout the application. This setting is useful when you work with non-Western character sets, such as Unicode. If you are installing Sybase IQ InfoPrimer Development for the first time, the default font is Tahoma. If you have previously installed this version of Sybase IQ InfoPrimer Development, the font is set to the previously defined value. Sybase recommends that you set the font to Tahoma.

      Note:

      To use “Default font for displaying text” and “Default font for displaying data” options, Sybase recommends that you install the files for East Asian languages. In the Windows Control Panel, click the Regional and Language Options, select the Languages tab, then select Install Files for East Asian Languages. Enabling this option installs the required fonts for displaying Unicode characters.

    • Create links automatically when components are added – automatically create links between an existing component and new components added to the project.

    • Default action on double-clicking a connection (ETL project type only) – specify whether to open the Mapping window (default) or the Preview window when you double-click a connection during simulation. The Mapping window displays the mapping information and the Preview window provides a preview of the connection data.

    • Display qualified transformation objects – add a prefix consisting of the owner name to the name of the objects in the Navigator. For example, if this option is selected, a project name appears in the Navigator as:
      TRANSFORMER.Demo Character Mapper

      where TRANSFORMER is the name of the client user who created the project.

    • Use unique object names – enforce unique project and job names on a repository connection.

    • Show password in component tooltips – display in component tooltips, the password used to log in to the underlying database. By default, the password appears in the tooltips as a series of asterisks.

    • Use enhanced color accessibility – change the color of the component ports to enhance support for users with color disabilities. Selecting this option changes the default color of the port from yellow to blue, enabling users with color disabilities to distinguish between port states.

    • Use vertical component layout – display the alignment of projects and jobs vertically instead of left to right, which is the default.

    • Show information dialogs – perform actions without being interrupted by information prompts, unselect this option.

    • Show Quick Start – display the Quick Start pane on start-up.

    • Number of recently opened projects, jobs, and templates to display – specify the number of recently accessed objects to view in the Navigator and the File menu.

    • Open the last repository automatically – connect automatically to the last logged on repository, on restart.

    • Save repository client password – save the client password after you log in to the repository. If selected, you do not have to provide the password during your next login.

  3. Select Data Viewer and specify the maximum length of an exported data field. The default value is 255. Data fields longer than the value you specify here are truncated in the export files.
  4. Select Query Designer and set these options:
    • Enable delete functionality of database objects – delete all records of a selected table when you right-click the table in the Query Designer and select Truncate Object.

    • Default number of records to retrieve from the Query Designer. The default is 25.

    • Create joins automatically – automatically create joins between identical attribute names used within tables or views.

    • Use brackets when creating joins – automatically surround join clauses with brackets in the generated query. For example, the select statement would appear as:
      select * FROM SALES ((<join statement 1>)
      <join statement 2>)
    • Default number of recently accessed tables and views to display – specify the number of recently accessed tables and views you want the Query Designer to display in the Recent tab. The default value is 25.

  5. Select Engine and set these options:
    • Start local engine during application start-up.

    • Interval between engine monitor updates (sec)– specify the number of seconds to wait between updates of the Engine Monitor. The default is 5 seconds.

    • Rate of simulation (msec) – set simulation trace delay. The simulation trace delay option accepts values between 10 and 9999 milliseconds. The default is 250 milliseconds.

    • Grid engine ping timeout (sec) – specify the number of seconds allowed for accessing the grid engine before starting or restarting a local grid engine. The default is 60 seconds.

    • Interval between progress monitor updates (sec) – specify the number of seconds to wait between updates of the progress monitor for a job execution. The default is 5 seconds.

    • Allow selection of the execution engine – specify the grid engine to be used for project execution.

    • Execution engine server – specify the IP address of the primary grid engine server.

    • Execution engine port – specify the port address of the primary grid engine server.

  6. Select Performance Logging and specify the detail level for logging performance data:
    • 0 – performance data is not written to the repository.

    • 1 – performance data is written to the repository. This is the default value.

  7. Click Save. For some of the changes to take effect, you may be prompted to restart Sybase IQ InfoPrimer Development. If you select not to restart when prompted, the changes take effect the next time you start the application.