SQS2DB

 Top 

The function reads Sicad-material data from a SQS file (incl. subsequent files.002 etc.) and transfers the material data into a data bank.

Condition

An ODBC connection with the data bank must exist.

(s.auch function SQLconnect.)

Parametre

ODBC/NAME

Name of the data bank in the material data should be written.

SQS/FILE NAME

Name of the SQS file incl. path

/NOFIELDS

In the data bank available tables are not extended by required fields.

INDEX / Feldname1, Feldname2...

For generated tables an index is generated.

This counter has no effect on tables available in the data bank!

Name / index name

Name of the index.

Default: newIndex.

/UNIQUE

unequivocal index put on.

/PRIMARY

Primary index put on.

/H

Short help

Return value

Value

Description

0

Call was carried out successfully

But

Mistake appeared

Examples

SQS2DB ODBC/SQS SQS / C:\Sachdaten\Adresse. SQS/NOFIELDS

SQS2DB ODBC/SQS SQS / C:\Sachdaten\Adresse.001

Remark

If the required tables do not exist in the data bank, they are automatically generated.

In the data bank available tables are extended by required fields. This functionality can be switched off by counter/NOFIELDS.