Data Movement Utilities Guide and Reference

Index

A B C D E F G H I K L M N O P R S T U V W Z
A
  • add database wizard (1097)
  • anyorder (827)
  • application record, PC/IXF (996)
  • ASC data type descriptions (972)
  • ASC file
  • format (968)
  • sample (971)
  • ASC, as an import file type (740)
  • authorities
  • required for AutoLoader utility (902)
  • required for export utility (682)
  • required for import utility (716)
  • required for load utility (805)
  • AutoLoader utility
  • authorities and privileges required to use (904)
  • limitations (906)
  • overview of (895)
  • restrictions (905)
  • troubleshooting (907)
    • B
  • backup database wizard (1099)
  • binarynumerics (849)
  • books (1069), (1082)
  • buffered inserts
  • import utility (722)
    • C
  • changed syntax and behavior
  • load utility (801)
  • character string delimiter (962)
  • chardel (701), (767), (857)
  • code page considerations
  • import utility (781)
  • load utility (881)
  • code page conversion
  • files (1034)
  • when importing or loading PC/IXF data (1035)
  • codepage (842)
  • coldel (702), (768), (858)
  • column
  • specifying for import (742)
  • column descriptor record, PC/IXF (990)
  • column values, invalid (1032)
  • columns, incompatible (1030)
  • command syntax
  • interpreting (949)
  • completion messages (1062)
  • compound (748)
  • configure multisite update wizard (1101)
  • constraints checking (813)
  • continuation record, PC/IXF (1008)
  • create database wizard (1103)
  • create table space wizard (1107)
  • create table wizard (1105)
    • D
  • data record, PC/IXF (993)
  • data transfer
  • across platforms (917)
  • AutoLoader utility (896)
  • between host and workstation (923)
  • data type descriptions
  • ASC (973)
  • DEL (965)
  • PC/IXF (1024)
  • data types
  • PC/IXF (1018)
  • Data Warehouse Center (DWC)
  • overview (937)
  • database
  • recoverable and non-recoverable, load options for use with (800)
  • warehouse (939)
  • Database Movement Tool (921)
  • dateformat (757), (843)
  • datesiso (703), (769), (859)
  • DB2 Data Links Manager
  • export utility (908)
  • exporting between instances (910)
  • import utility (911)
  • load utility (913)
  • troubleshooting the load utility (915)
  • DB2 library
  • books (1068)
  • Information Center (1090)
  • language identifier for books (1073)
  • late-breaking information (1075)
  • online help (1083)
  • ordering printed books (1081)
  • printing PDF books (1078)
  • searching online information (1116)
  • setting up document server (1114)
  • structure of (1067)
  • viewing online information (1085)
  • wizards (1093)
  • db2LoadQuery - Load Query (823)
  • DB2LOADREC (815)
  • db2move (922)
  • decplusblank (704), (770), (860)
  • decpt (705), (771), (861)
  • DEL data type descriptions (964)
  • DEL file
  • format (958)
  • sample (961)
  • delimited ASCII (DEL) file format (956)
  • moving data across platforms (919)
  • delimiter
  • character string (963)
  • delprioritychar (772), (862)
  • differences between PC/IXF and System/370 IXF (1053)
  • dldel (706), (773), (863)
  • dump file
  • load utility (871)
  • dumpfile (844)
  • DWC (Data Warehouse Center) (938)
    • E
  • environment variables
  • DB2LOADREC (816)
  • error messages (1061)
  • example
  • forcein (1047)
  • exception table
  • load utility (869)
  • export message files (710), (789), (892)
  • export operations
  • supported by Data Warehouse Center (940)
  • export utility
  • authorities and privileges required to use (684)
  • DB2 Data Links Manager (909)
  • identity columns (685)
  • large objects (LOBS) (689)
  • overview of (681)
  • parallel export using db2batch (691)
  • recreating an exported table (687)
  • restrictions (708)
  • transferring data between host and workstation (924)
  • export utility file formats (953)
  • exporting
  • file type modifiers for (697)
  • specifying column names (695)
    • F
  • fastparse (828)
  • file format
  • delimited ASCII (DEL) (957)
  • non-delimited ASCII (ASC) (967)
  • PC version of IXF (PC/IXF) (975)
  • worksheet (WSF)) (1058)
  • file formats
  • for exporting table to file (693)
  • for importing file to table (741)
  • file type modifiers
  • export utility (698)
  • import utility (746)
  • load utility (825)
  • forcein (776), (866)
  • code page semantics (1044)
  • data type semantics (1048)
  • example (1046)
  • general semantics (1042)
  • option (1040)
  • summary of PC/IXF file import with (1050)
    • G
  • generated column (726), (811)
  • generatedignore (749), (829)
  • generatedmissing (750), (830)
  • generatedoverride (831)
    • H
  • hashing algorithm (901)
  • header record, PC/IXF (984)
  • hierarchy record, PC/IXF (1002)
  • HTML
  • sample programs (1072)
    • I
  • IBM Relational Data Replication Tools
  • components (936)
  • overview (935)
  • identity column (686), (724), (809)
  • identity record, PC/IXF (1014)
  • identityignore (751), (832)
  • identitymissing (752), (833)
  • identityoverride (834)
  • implieddecimal (758), (845)
  • import
  • of PC/IXF files, with forcein (1052)
  • import message files (711), (790), (893)
  • import of PC/IXF files
  • data type-specific rules (1039)
  • general rules (1027)
  • import utility
  • authorities and privileges required to use (718)
  • buffered inserts (721)
  • client/server (719)
  • code page considerations (780)
  • compared to load utility (950)
  • DB2 Data Links Manager (912)
  • generated columns (725)
  • identity columns (723)
  • large objects (LOBS) (733)
  • limitations (786)
  • optimizing performance (782)
  • overview of (713)
  • performance (783)
  • recreating an exported table (728)
  • remote database (720)
  • restrictions (785)
  • table locking (737)
  • transferring data between host and workstation (925)
  • user-defined distinct types (UDTs) (735)
  • import utility file formats (954)
  • importing
  • file type modifiers for (745)
  • PC/IXF file to table (739)
  • incompatible columns (1029)
  • index record, PC/IXF (999)
  • index wizard (1109)
  • indexfreespace (835)
  • indexixf (777)
  • indexschema (778)
  • indicator
  • record length (981)
  • Information Center (1091)
  • installing
  • Netscape browser (1088)
  • Integration Exchange Format (IXF) (977)
  • invalid PC/IXF column values (1031)
  • invalid PC/IXF data type (1020)
    • K
  • keepblanks (774), (864)
  • keywords
  • syntax for (947)
    • L
  • language identifier
  • books (1074)
  • large objects (LOBS)
  • export utility (690)
  • import utility (734)
  • late-breaking information (1076)
  • LOAD
  • temporary files (818)
  • load delete start compensation log record (878)
  • load message files (712), (791), (894)
  • load operations
  • supported by Data Warehouse Center (941)
  • load pending list log record (879)
  • LOAD QUERY (819)
  • LOAD QUERY (db2LoadQuery) (822)
  • load start log record (876)
  • load utility
  • authorities and privileges required to use (807)
  • build phase (795)
  • changed syntax and behavior (802)
  • code page considerations (880)
  • compared to import utility (951)
  • database recovery (797)
  • DB2 Data Links Manager (914)
  • delete phase (796)
  • dump file (870)
  • exception table (868)
  • generated columns (810)
  • identity columns (808)
  • limitations (890)
  • load phase (794)
  • log records (874)
  • optimizing performance (887)
  • overview of (792)
  • parallelism (804)
  • process overview (793)
  • recovery from failure (814)
  • restrictions (889)
  • temporary files (872)
  • load utility file formats (955)
  • loading
  • file type modifiers for (824)
  • loading data
  • AutoLoader utility for loading data on database partitions (898)
  • lobsinfile (700), (753), (836)
  • locking
  • import utility (738)
  • log records
  • load utility (875)
    • M
  • message files: export, import, and load (709), (788), (891)
  • messages (1063)
  • modifiers, file type
  • for export utility (699)
  • for import utility (747)
  • for load utility (826)
  • moving data
  • across platforms (916)
    • N
  • Netscape browser
  • installing (1089)
  • nochecklengths (762), (779), (850), (867)
  • nodefaults (755)
  • nodoubledel (707), (775), (865)
  • noeofchar (759), (848)
  • noheader (837)
  • non-delimited ASCII (ASC) file format (966)
  • non-identity generated column (727), (812)
  • non-recoverable database
  • load options for use with (799)
  • norowwarnings (838)
  • no_type_id (754)
  • nullindchar (763), (851)
    • O
  • online help (1084)
  • online information
  • searching (1118)
  • viewing (1087)
  • option
  • forcein (1041)
    • P
  • packeddecimal (852)
  • pagefreespace (839)
  • parallel export
  • using db2batch (692)
  • parallelism
  • load utility (803)
  • parameters
  • syntax for (946)
  • partitioning data
  • AutoLoader utility (897)
  • partitioning keys (899)
  • PC version of IXF (PC/IXF) file format (974)
  • PC/IXF
  • code page conversion files (1036)
  • contrasted with System/370 IXF (1054)
  • data type descriptions (1023)
  • data types (1017)
  • invalid column values (1033)
  • invalid data type (1022), (1028)
  • record types (979), (982)
  • valid data type (1021)
  • PC/IXF file
  • format (976)
  • PC/IXF file format
  • moving data across platforms (918)
  • PC/IXF file import
  • data type-specific rules (1038)
  • general rules (1026)
  • with forcein (1051)
  • PC/IXF record type
  • application (997)
  • column descriptor (991)
  • continuation (1009)
  • data (994)
  • header (985)
  • hierarchy (1003)
  • identity (1015)
  • index (1000)
  • subtable (1006)
  • table (988)
  • terminate (1012)
  • PDF (1079)
  • pending states (882)
  • performance
  • import utility (784)
  • load utility (888)
  • performance configuration wizard (1111)
  • printing PDF books (1080)
  • privileges
  • required for AutoLoader utility (903)
  • required for export utility (683)
  • required for import utility (717)
  • required for load utility (806)
    • R
  • reclen (764), (853)
  • record length indicator (980)
  • record type, PC/IXF
  • application (998)
  • column descriptor (992)
  • continuation (1010)
  • data (995)
  • header (986)
  • hierarchy (1004)
  • identity (1016)
  • index (1001)
  • subtable (1007)
  • table (989)
  • terminate (1013)
  • record types
  • PC/IXF (978), (983)
  • recoverable database
  • load options for use with (798)
  • recreating an exported table
  • export utility (688)
  • import utility (729)
  • table attributes not stored in an IXF file (732)
  • table attributes stored in an IXF file (731)
  • release notes (1077)
  • replication
  • types supported by Data Warehouse Center (942)
  • restore wizard (1113)
  • rules governing PC/IXF file import (1025), (1037)
    • S
  • sample ASC file (970)
  • sample DEL file (960)
  • sample programs
  • cross-platform (1071)
  • HTML (1070)
  • searching
  • online information (1092), (1117)
  • SELECT statement
  • in EXPORT command (694)
  • semantics
  • forcein, code page (1045)
  • forcein, data type (1049)
  • forcein, general (1043)
  • setting up document server (1115)
  • SmartGuides
  • wizards (1094)
  • splitting data (900)
  • SQL messages (1064)
  • SQL-UEXPT-OUT structure (696)
  • SQLCODE (1065)
  • SQLSTATE (1066)
  • SQLUIMPT-IN structure (743)
  • SQLUIMPT-OUT structure (744)
  • SQLULOAD-IN structure (820)
  • SQLULOAD-OUT structure (821)
  • states
  • backup pending (883)
  • check pending (884)
  • delete pending (885)
  • load pending (886)
  • stored procedures
  • transformer (944)
  • striptblanks (765), (854)
  • striptnulls (766), (855)
  • structure
  • delimited ASCII (DEL) file (959)
  • non-delimited ASCII (ASC) file (969)
  • subtable record, PC/IXF (1005)
  • summary table
  • import restriction (787)
  • syntax diagrams (945)
  • System/370 IXF (1056)
  • contrasted with PC/IXF (1055)
    • T
  • table
  • exported, recreating an (730)
  • table load delete start log record (877)
  • table record, PC/IXF (987)
  • temporary files
  • load utility (817), (873)
  • terminate record, PC/IXF (1011)
  • timeformat (760), (846)
  • timestampformat (761), (847)
  • totalfreespace (840)
  • transformer stored procedures (943)
  • traverse order (714)
  • default (931)
  • typed tables (930)
  • user-specified (932)
  • typed tables
  • data movement examples (934)
  • export utility (927)
  • import utility (928)
  • moving data between (926)
  • selection during data movement (933)
  • traverse order (715), (929)
    • U
  • usedefaults (756), (841)
  • user-defined distinct types (UDTs)
  • import utility (736)
  • utility file formats (952)
    • V
  • valid PC/IXF data type (1019)
  • variables
  • syntax for (948)
  • viewing
  • online information (1086)
    • W
  • warning messages (1060)
  • wizards
  • add database (1096)
  • backup database (1098)
  • completing tasks (1095)
  • configure multisite update (1100)
  • create database (1102)
  • create table (1104)
  • create table space (1106)
  • index (1108)
  • performance configuration (1110)
  • restore database (1112)
  • worksheet file format (WSF) (1057)
  • WSF file
  • format (1059)
  • WSF file format
  • moving data across platforms (920)
    • Z
  • zoneddecimal (856)

    • [ Top of Page | Previous Page ]