DECLARE

You can declare variables for use inside the tiImport script, which can be used in expressions and other commands. Variables begin with @ and then have an alphabetic character, followed by an alphanumeric character. There are 5 supported types:

  • STRING
  • DATETIME
  • LONG
  • INT
  • DOUBLE

Note: a numeric character cannot be used immediately after the @ symbol, but can be used in any position subsequent to that.

Syntax:

DECLARE @variablename as datatype

Example:

DECLARE @cvar1 as STRING DECLARE @nvar1 as INT

Any command line parameter is available as a special variable called @param1 ,… @paramN of type STRING.

/* For this importation, within the mysample2.imp file, @param1 = “companyX” */
c:\Program Files\TARGIT\TARGIT InMemoryDB\tiImport.exe -> c:\Program Files\TARGIT\TARGIT InMemoryDB\tiImport.exe
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.