Configuring and Using PSDB

During the execution of a statement, you can display the statement in Infor M3 SWB description. This text is written by using a title definition line:

@TITLE=<Text describing statement>

The @CONVERTCHARS line is used to state that fields of type CHAR should be converted. The conversion means that all characters received from the database are converted to the actual Windows character set, and all characters sent to the database are converted from the actual Windows character set. To receive national characters from the database, you might require to use this option. Likewise you might require to use the option when inserting data with national characters into the database from Infor M3 SWB. The @CONVERTCHARS line has only effect within the statement is placed.

If @ARRAY is used an array buffer is used when sending or receiving data. This means that several lines are sent and received simultaneously. The PSDB keeps track of when to retrieve or send lines from the database again. This can give a performance gain.

The syntax of the @ARRAY line is:

Array size is the size of the used array buffer. The @ARRAY line has only effect within the statement is placed.

These types of lines define the mapping between the database fields and the Infor M3 SWB fields. A @COL or @WCOL line consists of six elements separated by semicolons. The @WCOL is used like the @COL when inside a WHERE clause in a statement. The syntax of the @COL and @WCOL lines are:

<Column definition>;<SQL type>;<Functions>;<APP field name>;<from position:To position>;<Comment>

Column definition:

This element contains, in addition to @COL= or @WCOL, the name of the database column in question. You can also state a fixed value.

SQL type:

This element defines the SQL type of the database column.

Functions:

Defines if one or more PSDB function is used.

APP field name:

This element states the Infor M3 SWB field name. The Infor M3 SWB field name is specified using symbolic names. A symbolic name contains both data type, offset and length information.

From position:To position:

If the Infor M3 SWB field is a character field, you can address only a part of the field by specifying a from and a to position within the field. If this element is left blank the whole field is used.

Comment:

Any comment.

These types of lines are used when data is taken from or inserted into Infor M3 SWB.

A parameter file statement defines one or more commands (SQL statements) that are sent to the database. The commands can be linked together within a statement by the @LINKED line. After the first command definition in the statement, write @LINKED on a line and define the next command.

The linked commands are executed sequentially.

This is used when you want to skip execution of a particular command.

This syntax of the BIT function is:

BIT(<Bit number>,<Bit set value>,<Bit not set value>) 

This result of this function depends on whether it is used during import or export:

When used during import the value of the database column field is compared with the <Bit set value>. If the match then the bit <Bit number> is set in the Infor M3 SWB field otherwise it is cleared.

When used during export the value of bit <Bit number> in the Infor M3 SWB field is examined. If the bit is set then the <Bit set value> is sent to the database, otherwise the <Bit not set value> is sent.

The type of the Infor M3 SWB field has to be LONG or SHORT.

This syntax of the IFEMPTY function is:

IFEMPTY (<value>)

This function converts an empty or blank value to another value. If the input to the function is empty or blank the argument value is returned instead. The type of the Infor M3 SWB field must be CHAR.

This function removes leading blanks from a string. The type of the Infor M3 SWB field must be CHAR.

This syntax of the MATH function is:

MATH(<Mathematical expression>)

This function can make simple calculations using ordinary arithmetic operators. You can perform several calculations on the same data.

These operators are available:

• + Addition
• - Subtraction
• * Multiplication
• / Division
• ! Inversion
• ^ Power
• # Square root

This function converts a date value in internal Infor M3 SWB format to a LONG representation of a date value in the format YYYYMMDD. The type of the Infor M3 SWB field must be LONG.

This function converts a time value in internal Infor M3 SWB format to a LONG representation of a time value in the format HHMMSS. The type of the Infor M3 SWB field must be LONG.

This function removes trailing blanks from a string. The type of the Infor M3 SWB field must be CHAR.

This function removes leading and trailing blanks from a string. The function combines the functionality of the LTRUNC and RTRUNC functions. The type of the Infor M3 SWB field must be CHAR.

This syntax of the TRANS function is:

TRANS(x1,y1)(x2,y2)...(Default)

This function transforms data from one value to another value. The function compares the input to the function with the value stated as the x value in the syntax. If these two values match, then the function will instead return the y value. You can state a default value. The default value is used if none of the x values equals the input value. If a default value is stated it must be placed at the end of the TRANS function.

This function converts a date on the format YYYMMDD to internal Infor M3 SWB format. The type of the Infor M3 SWB field has to be LONG.

This function converts a time value on the format HHMMSS to internal Infor M3 SWB format. The type of the Infor M3 SWB field has to be LONG.

This function converts a decimal point from "," to "." in a character representation of a decimal. The type of the Infor M3 SWB field has to be CHAR.

This function converts a decimal point from "." to "," in a character representation of a decimal. The type of the Infor M3 SWB field has to be CHAR.