Versions Compared

Old Version 1

changes.mady.by.user Sandor Kertesz

Saved on

compared with

New Version 2

changes.mady.by.user Sandor Kertesz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column
width76px

worddav8997db344ad37b37c602ee089f4a83f1.pngImage RemovedImage Added


Column

This icon performs an ODB/SQL query on an ODB database (ODB-1) or file (ODB-2). The result is always an ODB file (in ODB-2 format).

Info

From Macro/Python the icon can be called as odb_filter().

Tip

A tutorial about using ODB in Metview can be found here.

What is ODB?

ODB is a database developed at ECMWF to store and retrieve large volumes of meteorological observational and feedback data efficiently for use within the IFS.

Currently, ODB comes in two flavours:

  • ODB-1 (the original hierarchical table format capable of running in a parallel environment within IFS)

  • ODB-2 (a new flat format with a modern API used for archiving in MARS).

The ODB Filter Editor

ODB Filename

Specifies the path to the input ODB

ODB Icon

Specifies the input ODB as an icon. If both an icon (in ODB Icon) and a filename (in ODB Filename) are specified the icon takes precedence.

ODB Query

Specifies the ODB/SQL query to run.

ODB NB Rows

accepts a macro program as input and builds a user interface ready to accept user input. The user enters the required input in this interface, saves and on a given icon action, the embedded macro program is executed.

The input macro program must have the required code for the building of the user interface and parsing of the input


The Macro Parameters Editor

The Macro Parameters editor is dynamic in that its layout and contents are determined by the user depending on what is specified in the macro program the user provides. The rationale is that the editor contents form a user interface accepting variable user input for execution by the macro provided. It is a circular process in that the Macro icon passed to the Macro Parameters specifies the user interface, the Macro Parameters builds it, accepts the input and passes it back to the Macro icon to be used in whatever calculations it specifies.

Macro

Specifies the macro program which determines the layout and contents of the remainder of the editor.

This macro program must contain code to build the user interface and code to accept and parse the input (and obviously code to use it). On dropping a suitably coded macro program, a user interface is builtSpecifies the maximum number of rows in the result. If -1 is given here the number of rows is not limited in the output. The default value is -1.