NIPO ODIN Version 5.17

Previous Topic

Next Topic

Advanced use of *SQLADD Command

With *SQLADD you can create new records in a database table. This may be the current Sample table, the Sample for another survey or any other table within the same database.

*SQLADD can be seen as an extension of the commands *SQLGET, *SQLPUT and *NEXTRECORD:

  • The command *SQLGET can retrieve data from any database table.
  • The command *SQLPUT can update existing records in any database table.
  • The command *NEXTRECORD can write new records in the current Sample table, that can automatically be used by the NIPO CATI / Web Master to interview multiple respondents on the same telephone contact.
  • The command *SQLADD can write new records in any database table.

See Also