Summary

Fully Qualified Name:	Zend\Db\Sql\Platform\IbmDb2\SelectDecorator
Extends:	Select
Implements:	PlatformDecoratorInterface

Description

Methods

Name	Description	Defined By
__clone()	__clone	Select
__construct()	Constructor	Select
__get()	Variable overloading	Select
columns()	Specify columns from which to select	Select
combine()		Select
from()	Create from clause	Select
getIsSelectContainDistinct()		SelectDecorator
getRawState()		Select
getSqlString()	{@inheritDoc}	AbstractSql
getSupportsLimitOffset()		SelectDecorator
group()		Select
having()	Create having clause	Select
isTableReadOnly()	Returns whether the table is read only or not.	Select
join()	Create join clause	Select
limit()		Select
offset()		Select
order()		Select
prepareStatement()	{@inheritDoc}	AbstractPreparableSql
quantifier()		Select
reset()		Select
setIsSelectContainDistinct()		SelectDecorator
setSpecification()		Select
setSubject()		SelectDecorator
setSupportsLimitOffset()		SelectDecorator
where()	Create where clause	Select

Method Details

__clone()

__clone

Resets the where object each time the Select is cloned.

Returns: void

__construct()

Constructor

Parameter Name	Type	Description
$table	null|string|array|\TableIdentifier

Returns:

__get()

Variable overloading

Parameter Name	Type	Description
$name	string

Returns: mixed

columns()

Specify columns from which to select

Possible valid states:

array(*)

array(value, ...) value can be strings or Expression objects

array(string => value, ...) key string will be use as alias, value can be string or Expression objects

Parameter Name	Type	Description
$columns	array
$prefixColumnsWithTable	bool

Returns: self Provides a fluent interface

combine()

Parameter Name	Type	Description
$select	\Select
$type	string
$modifier	string

Returns: self Provides a fluent interface

from()

Create from clause

Parameter Name	Type	Description
$table	string|array|\TableIdentifier

Returns: self Provides a fluent interface

getIsSelectContainDistinct()

Returns: bool

getRawState()

Parameter Name	Type	Description
$key

Returns: void

getSqlString()

{@inheritDoc}

Parameter Name	Type	Description
$adapterPlatform

Returns:

getSupportsLimitOffset()

Returns: bool

group()

Parameter Name	Type	Description
$group	mixed

Returns: self Provides a fluent interface

having()

Create having clause

Parameter Name	Type	Description
$predicate	\Where|\Closure|string|array
$combination	string	One

Returns: self Provides a fluent interface

isTableReadOnly()

Returns whether the table is read only or not.

Returns: bool

join()

Create join clause

Parameter Name	Type	Description
$name	string|array|\TableIdentifier
$on	string|\Predicate\Expression
$columns	string|array
$type	string	one

Returns: self Provides a fluent interface

limit()

Parameter Name	Type	Description
$limit	int

Returns: self Provides a fluent interface

offset()

Parameter Name	Type	Description
$offset	int

Returns: self Provides a fluent interface

order()

Parameter Name	Type	Description
$order	string|array|\Expression

Returns: self Provides a fluent interface

prepareStatement()

{@inheritDoc}

Parameter Name	Type	Description
$adapter
$statementContainer

Returns: \StatementContainerInterface

quantifier()

Parameter Name	Type	Description
$quantifier	string|\Expression	DISTINCT|ALL

Returns: self Provides a fluent interface

reset()

Parameter Name	Type	Description
$part	string

Returns: self Provides a fluent interface

setIsSelectContainDistinct()

Parameter Name	Type	Description
$isSelectContainDistinct	bool

Returns:

setSpecification()

Parameter Name	Type	Description
	$specification
$index
$specification

Returns: self Provides a fluent interface

setSubject()

Parameter Name	Type	Description
$select	\Select

Returns:

setSupportsLimitOffset()

Parameter Name	Type	Description
$supportsLimitOffset	bool

Returns:

where()

Create where clause

Parameter Name	Type	Description
$predicate	\Where|\Closure|string|array|\Predicate\PredicateInterface
$combination	string	One

Returns: self Provides a fluent interface