Package DE_EPAGES::ShopTransfer::API::DBISybase
Functions
- getAllColumns
- getAllPrimaryKeys
- getAllReferences
- getGeneralizeDateTimeStatement
- getTypesOfColumns
- getUniqueIndexes
- isColumnAutoIncrement
- reserveIdentifier
getAllColumns
Returns all columns of all tables in the current database.
Syntax |
$hTableColumns = $dbi->getAllColumns; |
Return |
|
getAllPrimaryKeys
Returns all primary keys of all tables in the current database.
Syntax |
$hTablePrimaryKeys = $dbi->getAllPrimaryKeys; |
Input |
|
Return |
|
getAllReferences
Returns all foreign keys of all tables in the current database.
Syntax |
$hTableReferences = $dbi->getAllReferences; |
Return |
|
getGeneralizeDateTimeStatement
Returns a statement for querying datetime columns in a generalized format. Instead of returning the plain column name, a convert statement like 'convert(char(19), $TablePrefix$Column, 117)' is returned and can be integrated into a 'SELECT $statement from table where bla' query.
Syntax |
$statement = $dbi->getGeneralizeDateTimeStatement($Column); |
Input |
|
Return |
|
getTypesOfColumns
Returns types of columns. Currently used types: bit,char,datetime,float, int,money,nchar,numeric,nvarchar,text,tinyint,varchar
Syntax |
$hTypes= $dbi->getTypesOfColumns($Table); |
Input |
|
Return |
|
getUniqueIndexes
Returns first columns of all unique indexes.
Syntax |
@Columns = $dbi->getUniqueIndexes($Table); |
Input |
|
Return |
|
isColumnAutoIncrement
Returns 1 if the table has an auto increment column or an _nextid table
Syntax |
$isAutoInc = $dbi->isColumnAutoIncrement(); |
Input |
|
Return |
|
reserveIdentifier
Updates the _nextid table, to define a gap for bcp input.
Syntax |
$FirstNextID = $dbi->reserveIdentifier($Table, $CountOfRows); |
Input |
|
Return |
|