# Index for Building Queries and Data Views

# Symbols

../admin/userdefineddatatype.html#1047392 1, 2, 3

# A

ad hoc query 1

application view

as supported data source 1

automatic type casting 1

# C

comma separated value (CSV) files

as supported data source 1

compile query 1

complex parameter types

defining in Toolbox tab 1

Complex Parameter Types, Using 1

components

accessing from the Toolbar 1

constants

accessing from Toolbox tab 1

CPT (Complex Paramater Type) 1

custom functions

accessing from Toolbox tab 1

use cases for 1

# D

data sources

order optimization 1

data view

as supported data source 1

data views

simple and parameterized 1

using as data sources 1, 2

Design tab 1

# F

functions

accessing from Toolbox tab 1

introduction to use of in Data View Builder 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

stored procedure support 1

# J

join

adding hints for optimizing query performance 1

definition 1

# M

Microsoft SQL Server

stored procedure support 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

optional element, suppress when empty 1

Oracle

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

running 1

saving 1

saving as a stored query 1

stopping while running 1

stored 1

testing 1

query parameters 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, 2

resolving imported schemas 1

source-introduction 1, 2

target-introduction 1, 2

source

order optimization 1

source schema

introduction 1, 2

SQL Call 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

SQL query in scdf file 1

stored procedure

support by database 1

stored procedures

as supported data source 1

defining to Liquid Data 1

example 1

overview 1

using in queries 1

stored query

definition 1

saving as 1

Sybase

stored procedure support 1

# T

target schema

introduction 1, 2

namespaces 1

understanding 1

Test tab 1

type casting

automatic in Data View Builder 1

# U

union

definition 1

# W

Web services

definition 1

naming conventions for queries 1

# X

XML

XML files as supported data source 1

XML file

definition 1

XML namespaces 1