EDBI Routines for Microsoft SQL Server

Data mapping (any COMP type could be used, mapping is done according to the digits):

PIC X(n)	VARCHAR(n)
PIC 9(1-4)	SMALLINT
PIC 9(5-9)	INT
PIC 9(>9)	BIGINT
PIC 9(n)V9(m)	DECIMAL(n+m,m)
PIC S9(n)V9(m)	DECIMAL(n+m,m)

Peculiar jdbc settings:

iscobol.jdbc.cursor.concurrency = 1009

Lock Timeout:

By default the SQL Server JDBC driver waits for locks to be released. If you wish to receive a ‘record locked’ error, you can configure the lock timeout in the connection URL, for example:

iscobol.jdbc.url=jdbc:sqlserver://my-server:1433;user=sa;password=manager;lockTimeout=1000