Package DE_EPAGES::ShopTransfer::API::DBISybase
Functions
- getColumnPosition
- getColumns
- getDBName
- getGeneralizeDateTimeStatement
- getMasterOfReference
- getReferences
- getTypesOfColumns
- getUniqueIndexes
- isColumnAutoIncrement
- reserveIdentifier
getColumnPosition
Returns the position of the column (start with 0). Returns undef if column does not exist.
Syntax |
$Position = $dbi->getColumnPosition($Table, $Column); |
Input |
|
Return |
|
getColumns
Returns all columns.
Syntax |
@Columns = $dbi->getColumns($Table); |
Input |
|
Return |
|
getDBName
returns the current db name.
Syntax |
$DbName = getDBName(); |
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 |
|
getMasterOfReference
Returns the master of foreign key. Returns undef unless there is no reference.
Syntax |
($MasterTable, $MasterColumn) = $dbi->getMasterOfReference($Table, $Column); |
Input |
|
getReferences
Returns the reference info of a table.
Syntax |
$ahReferences = getReferences($Table); |
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 |
|