Index for Building Queries and Data Views

Symbols

../design.html#1049351 1

A

ad hoc query 1

advanced view

on Conditions tab 1

understanding scope in 1

aggregate

definition 1

in example query 1

application view

as supported data source 1

automatic type casting 1

C

Complex Parameter Types, Using 1

components

accessing components of a query from Toolbox tab 1

constants

accessing from Toolbox tab 1

count function

in example query 1

CPT (Complex Paramater Type) 1

custom functions

accessing from Toolbox tab 1

use cases for 1

D

data sources

order optimization 1

supported in Liquid Data 1

data view

as supported data source 1

data views

simple and parameterized 1

using as data sources 1, 2

date-time

example query 1

DB2

names for Liquid Data data types 1

Design tab 1

F

functions

accessing from Toolbox tab 1

count used in example query 1

date and time in example query 1

introduction to use of in Data View Builder 1

W3C XQuery links 1

H

hints

for parameter passing 1

merge 1

optimizing queries with 1

ppleft 1

ppright 1

I

IBM DB2

stored procedure support 1

Informix

names for Liquid Data data types 1

stored procedure support 1

J

JDBC

names for Liquid Data data types 1

supported data types for Liquid Data 1

join

adding hints for optimizing query performance 1

definition 1

in example query 1

M

Microsoft SQL Server

stored procedure support 1

minus

in example query 1

MSQL

server names for Liquid Data data types 1

N

namespaces, XML 1

naming conventions

for queries 1

for stored queries to be generated as Web services 1

O

optimization

data source order in query 1

hints for joins 1

Optimize tab 1

Oracle

names for Liquid Data data types 1

stored procedure support 1

P

parameter

types 1

parameters

introduction to use of in functions 1

ppleft 1

ppright 1

Q

query

ad hoc 1

optimizing source order in 1

plans 1

result 1

running 1

saving 1

saving as a stored query 1

stopping while running 1

stored 1

testing 1

query parameters

defining 1

defining in Toolbox tab 1

introduction to use of in functions 1

submitting at query runtime 1

types 1

query plan

definition 1

S

schemas

off-line (unavailable) 1

source-introduction 1

target-introduction 1

scope

defining in Advanced view on Conditions tab 1

source

order optimization 1

source schema

introduction 1

stored procedure

support by database 1

Stored Procedure Description file

DB2 multiple result sets 1

elements and attributes 1

Oracle cursor as a return_value 1

Oracle cursor output parameter 1

overview 1

rules for specifying 1

sample files 1

schema definition file 1

stored procedures

as supported data source 1

defining to Liquid Data 1

example 1

overview 1

Stored Procedure Description file 1

using in queries 1

stored query

definition 1

saving as 1

Sybase

names for Liquid Data data types 1

stored procedure support 1

T

target schema

introduction 1

namespaces 1

understanding 1

Test tab 1

type casting

automatic in Data View Builder 1

U

union

definition 1

in example query 1

W

W3C

relationship to XQuery and Liquid Data 1

Web services

definition 1

naming conventions for queries 1

X

XML

role in XQuery 1

XML files as supported data source 1

XML file

definition 1

XML namespaces 1

XQuery

as used in Liquid Data 1

definition 1

links to more information 1