IBM InfoSphere DataStage andQualityStageV11.3
NetezzaPerformance Server,S8O
SC43-1052-00
���
IBM InfoSphere DataStage andQualityStageV11.3
NetezzaPerformance Server,S8O
SC43-1052-00
���
"
Z9C>JO0d'VDz7.0,kDAZ 653D:ywMLj;PDE"#
© Copyright IBM Corporation 2005, 2014.
?<
Z 1 B dCT Netezza }]bDCJ . . 1dCT Netezza }]bDCJ . . . . . . . . . 1Z Linux M UNIX OdCT Netezza }]bDCJ . . . . . . . . . . . . . . . . . 1Z Microsoft Windows OdCT Netezza }]bDCJ . . . . . . . . . . . . . . . . 2
hCb7673d? . . . . . . . . . . . . 3Z dsenv D~PhCb7673d? . . . . . 3Z Windows PhCb7673d? . . . . . . 4
(}9C ISA Lite $_bT}]b,S . . . . . 5
Z 2 B Netezza Enterprise WN . . . . 7XZ Netezza Performance Server 8000 . . . . . . 70k=( . . . . . . . . . . . . . . . 7CZCJ Netezza Performance Server DM'zSZ 8\'VDYw53r=( . . . . . . . . . 9
Netezza Enterprise WND$w== . . . . . . . 99C Netezza Enterprise WN . . . . . . . . . 10Hvu~ . . . . . . . . . . . . . . 10Netezza enterprise WNYw . . . . . . . . 129C Netezza Enterprise WN+}]4k NetezzaPerformance Server . . . . . . . . . . . 139C Netezza Enterprise WNS NetezzaPerformance Server PA!}] . . . . . . . 21Netezza enterprise WND}]`M . . . . . . 25
Z 3 B Netezza connector . . . . . . 299C Netezza connector hFw5 . . . . . . . 29<k Netezza *}] . . . . . . . . . . 30Netezza j6 . . . . . . . . . . . . . 30
'VDV{`k . . . . . . . . . . . . 31(e Netezza connector w5 . . . . . . . . 32
JOoO . . . . . . . . . . . . . . . 47
Z 4 B 73d?:Netezza Connector 51CC_GUARDIUM_EVENTS . . . . . . . . . 51CC_IGNORE_TIME_LENGTH_AND_SCALE . . . . 51CC_MSG_LEVEL . . . . . . . . . . . . 51CC_NZ_LOG_LEVEL . . . . . . . . . . . 51CC_TRUNCATE_STRING_WITH_NULL . . . . . 52CC_TRUNCATE_NSTRING_WITH_NULL . . . . 52CC_USE_EXTERNAL_SCHEMA_ON_MISMATCH . . 52TMPDIR . . . . . . . . . . . . . . . 52
=< A. z7(z&\!n . . . . . . . 53
=< B. A.|nPo( . . . . . . . . 55
=< C. gNA.o(< . . . . . . . . 57
=< D. *5 IBM . . . . . . . . . . 59
=< E. CJz7D5 . . . . . . . . . 61
=< F. a)PXz7D5D4! . . . . 63
ywMLj . . . . . . . . . . . . . 65
w} . . . . . . . . . . . . . . . . 69
© Copyright IBM Corp. 2005, 2014 iii
iv Netezza Performance Server ,S8O
Z 1 B dCT Netezza }]bDCJ
*dCT Netezza }]bDCJ,Xk20}]bM'zb,"+b)Q20bD76
|(Zb7673d?P#PXhC73d?D|`E",kNDhC73d?D`
Xwb#
}L
1. 20}]bM'zb#
2. dCT Netezza }]bDCJ#
dCT Netezza }]bDCJ*dCT Netezza }]bDCJ,Xk20MdC Netezza ODBC }/Lr,"4(
}]4#
Z Linux M UNIX OdCT Netezza }]bDCJ*dCT Netezza }]bDCJ,XkZ .odbcinst.ini D~P8(N}TdC Netezza
ODBC }/Lr,9Xk^D .odbc.ini D~TdC}]4#
*<.0
v 20M'zb#
XZKNq
g{fZ .odbcinst.ini dCD~,G4IT^D`,D~#g{;PVP
.odbcinst.ini dCD~,G4IT9C odbcinst.ini.sample T4( .odbcinst.ini
dCD~#Zs`}!0P,IT9C odbcinst.ini.sample D~DZ],x;xPN
N|D#+G,ZTB!0P,Xk|DdCD~:
v g{zDM'z53dC*9C Netezza ODBC }/Lr.bD ODBC }/Lr,
"Rz*Lx9Cb) ODBC }/Lr,kp^D .odbcinst.ini D~PDVPu
?#Z .odbcinst.ini D~DVPZ])2,mS Netezza ODBC }/LrDu?#
v g{ZM'z53O20K Netezza M'zm~M Netezza ODBC }/Lr,kl
iGqdCK N e t e z z a O D B C }/Lr#g{4dC,k+u?mS=
.odbcinst.ini D~DVPZ])2#
g{w?<(}g,/home/myname)PQfZ .odbc.ini dCD~,kli|Gq|
,*CJD Netezza h8}]4Du?#g{;|,,k+ odbc.ini.sample D~D
Z]4F=VP .odbc.ini dCD~D)2#;*^DD~PDNNVPu?#
g{}Z Linux O9C .odbc.ini dCD~D InfoSphere® Information Server f>,
kZCdCD~yZDD~PP4({E4ST7# Netezza ,Sw}7KP:
1. T InfoSphere DataStage®\m1m]G<#
2. *|D InfoSphere Information Server D20?<,kdkTB|n:cd /opt/IBM/
InformationServer/Server/DSEngine#
3. *4({E4S,kdkTB|n:ln -s .odbc.ini odbc.ini#
© Copyright IBM Corp. 2005, 2014 1
}L
1. 9CzDC'j6M\kG<#
2. dC Netezza ODBC }/Lr:
a. 4F /usr/local/nz/lib/odbcinst.ini.sample D~DZ]#
b. y]hs^DdCu?# I/ Netezza 53\m1,TliGqXk*zD2
0^DNNX(dCu?#
c. +D~mf* .odbcinst.ini#
3. dC Netezza h8}]4:
a. + odbc.ini.sample D~DZ]4F=w?<(}g,/home/myname),"+d
X|{* .odbc.ini#
b. I!: *+ Netezza }]4mS=VP .odbc.ini D~P,k+y>D~P
[NZSQL] sDPmS=VP .odbc.ini D~#Z [ODBC Data Sources] ?VP,
+ NZSQL = NetezzaSQL mS=}]4{FDPmP#
c. #f"XUD~#
4. hC73d?:
export ODBCINI=path_to_odbc.ini_fileexport NZ_ODBC_INI_PATH=location_of_odbc.ini_file
":g{Q+ Netezza u?mS=VP odbc.ini D~,kvhC NZ_ODBC_INI_PATHd?#
5. *XBt/~qw}fM ASB zmLr,kdkTB|n:
cd Install_directory/Server/DSEngine/bin./uv -admin -stop./uv -admin -startcd Install_directory/ASBNode/bin. ./NodeAgents_env_DS.sh./NodeAgents.sh stopAgent./NodeAgents.sh start
Z Microsoft Windows OdCT Netezza }]bDCJg{ InfoSphere Information Server Z Microsoft Windows Yw53OKP,G4Xk
Z20 Netezza ODBC }/Lrs4(MdC}]4#
*<.0
v 20}]bM'zb#
v Z 64 ; Windows FczO,7#KP 32 ;f>D Microsoft ODBC }]4\m
w C:\Windows\SysWOW64\odbcad32.exe,r* InfoSphere Information Server G 32
;&CLr#g{KP 64 ;f>D ODBC \mw&CLr,G4 Netezza ,Sw
^(R=8(D}]4{F#g{1!ivB^((}“D~”K%CJ ODBC \m
w&CLr,k9C Windows J4\mw4CJC&CLr#
– Z 32 ; Windows O,+Z C:\Windows\System32 ?<P20 32 ;}/Lr#
– Z 64 ; Windows O,IT,120 32 ;M 64 ;}/Lr# 32 ;}/Lr
20Z C:\Windows\SysWOW64 ?<P,64 ;f>20Z C:\Windows\System32 ?
<P#
2 Netezza Performance Server ,S8O
}L
1. 4(}]4:
a. y]Yw534PTB3nYw:
v Z 32 ; Windows 53O,%w*< > XFfe > \m$_ > }]4
(ODBC)#
v Z 64 ; Windows 53O,9CJ4\mw/@A C:\Windows\SysWOW64\
odbcad32.exe#
b. Z“53 DSN”3fO,%wmS#
c. Z“4(B}]4”3fO,+ NetezzaSQL !w*hCd}]4D}/Lr,;s%wjI#
2. dC ODBC }/Lr:
a. Z“Netezza ODBC }/LrhC”3fO,8(PX}]4Dj8E"#
b. Z~qwVNP,8( ODBC }/Lr,S=D Netezza 53Dwz{r IP X
7#
c. *bT,S,k8(C'{M\k,;s%wbT,S#
hCb7673d?
*+73d?&C=n?PDyPw5,kZ InfoSphere DataStage M QualityStage®
Administrator P(eC73d?#Zn?6prw56p*b7673d?M7673
d?8(D5+7S=b)d?DVP535P#
XZKNq
}g,Y(?< /opt/branded_odbc/lib 8(*n?6pDb7673d?D5#?<
/opt/IBM/InformationServer/Server/branded_odbc/lib(|,;Z;,;CD`,
b)Q;ZZYw536pr dsenv E>P(eDb76P#ZKivB,1w5KP
1,a0k?< /opt/IBM/InformationServer/Server/branded_odbc/lib PDb,r
*K?<Z*b7673d?(eD5PvVZ?< /opt/branded_odbc/lib .0#
b7673d?D{F!vZYw53#
Yw53 b7673d?
Microsoft Windows PATH
HP-UX SHLIB_PATH
IBM® AIX® LIBPATH
d{\'VD Linux M UNIX Yw53T0
HP-IA
LD_LIBRARY_PATH
Z Linux r UNIX Yw53O,ITZ dsenv E>P8(73d?#Windows Yw
53OD InfoSphere Information Server 20;|( dsenv E>#
Z dsenv D~PhCb7673d?Z Linux r UNIX Yw53O,ITZ dsenv E>P8(b7673d?#g{73
d?Z dsenv E>P8(,|G+&CZ InfoSphere Information Server }fBKPD
yP InfoSphere DataStage n?#
Z 1 B dCT Netezza }]bDCJ 3
*<.0
20M'zb#
}L
1. T DataStage \m1C'm](g{zG9C1!{F20D,r* dsadm)G<#
2. 8] IS_install_path/Server/DSEngine/dsenv E># IS_install_path G InfoSphere
Information Server 20?<(g{G9C1!7620D,r* /opt/IBM/
InformationServer)#
3. r* dsenv E>#
4. +|,M'zbD?<D76mS=b7673d?#
5. 9C|BD dsenv D~hC73#
. ./dsenv
6. (}dkTB|nXBt/ InfoSphere Information Server }f:
bin/uv –admin –stopbin/uv –admin –start
7. IC root C'X(,1S9C su |n,r_g{ DataStage \m1C'Z sudoers
PmP,G49C sudo |n#
sudo su - root
8. (}dkTB|nP;= ASB zmLrw?<:
cd Install_directory/ASBNode/bin
9. (}dkTB|nXBt/ ASB zmLrxL:
./NodeAgents.sh stopAgent
./NodeAgents.sh start
a{
XBt/ ASB zmLrxLs,InfoSphere Information Server ~qh*s<;VS1
d4"aB~#
Z Windows PhCb7673d?Z Windows Yw53O,b76M PATH 73d?yI PATH 73d?m>#*9
InfoSphere Information Server }fM ASB zmLrxL\;lb=73d?PD|D,
b)|DXkZ536pxP,"RXkXBt/ InfoSphere Information Server }f#
*<.0
20M'zb#
}L
1. *`- PATH 5373d?,k%w_653hCPD73d?,;s!q PATH#
2. %w`-,;s8(|,M'zbD?<D76#
3. %w“7(”#
4. XBt/ InfoSphere Information Server }f#
5. XBt/ ASB zmLrxL#
4 Netezza Performance Server ,S8O
(}9C ISA Lite $_bT}]b,S("k}]bD,Ss,(}KP IBM Support Assistant (ISA) Lite for InfoSphere Infor-
mation Server $_4bT}]b,S#
PX ISA Lite $_D|`E",kNDPX20i$MJOoODwb#
Z 1 B dCT Netezza }]bDCJ 5
6 Netezza Performance Server ,S8O
Z 2 B Netezza Enterprise WN
Netezza Enterprise WNG;v}]bWN#(}9C Netezza Enterprise WN,IT+
z?}]4k Netezza Performance Server 8000#
Z9C IBM InfoSphere DataStage +}]4k= Netezza 1,zITS,S!n/O
PxP!q#TZs`}w5,k9C Netezza Connector WN,k Netezza Enter-
prise WN`H,CWN\;a)|CD&\MT\#
g{P9C Netezza Enterprise WNDw5*9C,Sw,k9C“,Sw(F$_”(
Fw5T9C,Sw#
XZ Netezza Performance Server 8000Netezza Performance Server 8000 Gs56}]bh8#
BfG Netezza Performance Server Dw*&\MEc:
v Netezza Performance Server G(E*zcrZ6}]bD51L5G\ (BI) M5q
VvT\hsxhFD#
v (}9C Netezza Performance Server,MI{CICD*E=j<M.[i~#
v Netezza Performance Server 'V9Cj< SQL i/D BI,rxWZ9C#zIT
KPT:Xpi/,x^h<\5lD}]b\m1kTyPI\Di/4w{}
]b#
*{C Netezza Performance Server,k9CICD0k=(M\'VDM'zSZ#
0k=(
+}]4k Netezza Performance Server P=Vfz=(:b?mM nzload#
BfPvKb=V0k=(.dDw*nl:
m 1. Netezza Enterprise WNPD0k=(
b?m nzload
b?mG Netezza Enterprise WNZ}]bP4
(DY1m#bVm|,IC(gV{N=D
}],(g{*:E#g{!qbV0k=
(,G4}]4PD}]+(}b?m0k=
Netezza Performance Server PD?jm#
nzload G;vCZ+}]0k Netezza Perfor-
mance Server D(C>z5CLr#1!iv
B,Netezza Enterprise WNa9CbV0k=
(#
14mP|,1!5R}]ICId`kq=
(g UTF-8 M LATIN9)1,k9Cb?m0
k=(#
1}]IC;BD$(e`kq=R4mP4
|,NN1!51,k9C nzload 0k=(#
© Copyright IBM Corp. 2005, 2014 7
m 1. Netezza Enterprise WNPD0k=( (x)
b?m nzload
(}9C CREATE EXTERNAL TABLE |
n,IT+ Netezza }]bD}]4k;tZ
}]bDb?4r+b)}]SCb?4P}
%#b?m0k=((}TB 3 v|n45
V:
v CREATE TABLE:'V4mP?vPD1!5#
v SELECT:Sb?mA!}]#
v INSERT:bMD>5"7(*9CDdkq=#
nzload |nG;v ASCII q=Dz?}]0k
Lr,<ZlY0k}]",1t!vmsD
r;w7DZ]#nzload |n*sz8(D>
q="a?F#V;BT#
!\ nzload |nI?jmD#=}/,+|a
vTyP1!5f6#
b?m0k=(9C INSERT od40k}
]#*4P INSERT |n,;h DML X(
(CREATE TABLE"SELECT M INSERT X
()#
*9C nzload 0k=(,h*kT?jmD
CREATE TABLE M LOAD X(#
TZb?m0k=(,aZ Netezza Perfor-
mance Server 53D .../tmp ?<P4(U>D~#
TZ nzload 0k=(,aZM'z53D .../tmp ?<P4(U>D~#
":19C nzload 0k=(1,k7#4#=3rk?jmD#=3r`,#
CZCJ Netezza Performance Server DM'zSZIBM InfoSphere DataStage v'VT&Z Netezza ~qwDM'zSZ,}g,ODBC
Driver V2.05#ODBC Driver V2.05 {O ODBC 3.0 f6#
IT9CBfPvDM'zSZCJ Netezza Performance Server#
":CJ Netezza Performance Server 1h* ODBC }/Lr#
v CJ Netezza Performance Server 1yhDM'z:
– ODBC M'zSZ:*CJ Netezza Performance Server,Xk20 ODBC M'
zSZ#ODBC M'zJm&CLrMCZ9(&CLrD$_CJ SQL }]
b#
– Netezza M'zSZ:g{*9C nzload 0k=(+}]0k Netezza Perfor-
mance Server,G4Xk20 Netezza M'z#
v CZCJ Netezza Performance Server DI!M'z:
– Microsoft Windows M'zSZ:Windows M'zI NzAdmin(;VyZ GUI
D$_)iI#zIT9C Windows M'zSZ4KP53M}]bYw#
– Web M'zSZ:Web M'zI Webadmin(;VyZ/@wD\mw$_)i
I#zIT9C Web M'zSZ(}#CD Web /@w4`X"\m Netezza
Performance Server 53#
– Linux r Solaris M'zr|nPgf:zIT9C Linux r Solaris M'z4
dk SQL od#Linux r Solaris M'zr|nPgf9a)K;vS<,dP
|, Linux r Solaris M'z53M Netezza |nPgf|n5XDa{/,z
I9CCS<4\m53M}]b#
– JDBC M'zSZ:JDBC M'zJm Java™ LrCJ SQL }]b#
8 Netezza Performance Server ,S8O
\'VDYw53r=(
zITS}ZKP\'V=(D53,S= Netezza Performance Server#
\'VDYw53r=(|(:
v IBM AIX 6.1
v HP-UX (PA-RISC) 11.0
v Red Hat Linux AS 3.0
v SunOS 5.10
v Microsoft Windows 2008 Server 0|_f>
Netezza Enterprise WND$w==Netezza Enterprise WNG;vAM4DWN#
4WNaS}]4!vz?}],;s+b)}]4k Netezza Performance Server P
8(D?jm#Netezza Enterprise WNDdk}]4ITGm;v}]bWNMzID
D~H#IT9CTB=VICD0k=(.;+}]4k Netezza Performance Server:
b?mr nzload#PX0k=(Dj8E",kND0k=(?V#fsD8v?V+
j8hvgN!q0k=(#
BfD<VpT>K9Cb?mM nzload 0k=(D Netezza Enterprise WN$wwL:
Z 2 B Netezza Enterprise WN 9
AWNaS Netezza Performance Server D8(?jmPRvz?}],;s+b)}
]4k}]4rm;v}]bWN#
9C Netezza Enterprise WNZ9C Netezza Enterprise WN.0,h*Hi$Hvu~#
z9+Kb=gN+ Netezza Enterprise WNmS=w5P#
Hvu~
*9C Netezza Enterprise WN+}]4k Netezza Performance Server,Xk20yh
Di~#;s,XkJ1XdCCWNM53#
20MdCyhDi~
Z20yhD Netezza ~qwMM'zm~.s,Xk9C odbc.ini D~dC}]4#
XZKNq
BfPvK20MdChs:
}L
1. 20 Netezza ~qwMM'z#Netezza Enterprise WN'V Netezza Server 2.05 Patch
4 M|_f>#g{*9C nzload 0k=(,G4Xk20 Netezza M'z#
2. 20MdC Netezza Performance Server a)D nzload 5CLrM ODBC }/L
r#Netezza Enterprise WN9CC ODBC }/Lr4lw?jmrD~D*}]#
7#20C ODBC }/LrD 2.05 f>#C}/Lr{O 3.0 ODBC f6#
3. 7#Z UNIX 53O20"dC DataDirect D ODBC }/Lr\mw#
4. q!kT Netezza Performance Server P?jmDT= LOAD X(#
":PX20MdCOvi~Dj8E"roz,kNDm~f=DD5#
5. Z $DSHOME P4( odbc.ini D~#*4( odbc.ini D~,XkHdC;Z$DSHOME PD .odbc.ini D~,=(GmSX*DE",g}]b{F"wz{
"C'{M\k#PXdC .odbc.ini D~Dj8E",kNDZ UNIX =(Od
10 Netezza Performance Server ,S8O
C}]4?V#;s,+ .odbc.ini D~DZ]4F=;Z`,;CD odbc.ini D~#r_,IT4(8r .odbc.ini D~Dm4S#
6. J1XhCC'(eD73d?M#f73d?#Bma)KPXgNhCC'(
eD73d?M#f73d?DE"#
m 2. Netezza Enterprise WND73d?
73d? `M hC hv/?D >}
NETEZZA C'(e $NETEZZA 8( Netezza w?< $export NETEZZA=/disk3/
Netezza
NZ_ODBC_INI
_PATH
C'(e $NZ_ODBC
_INI_PATH
8r .odbc.ini D~yZD;C#bG
UNIX 53yhDX
(d?#
$DSHOME/.odbc.ini
APT_DEBUG
_MODULE_NAMES
C'(e $APT_DEBUG
_MODULE_NAMES
r!4TX(#iD
wT{"
o d b c s t m t o d b c e n v
n z e t w r i t e o p" n z u t i l s"
nzwriterep M nzetsubop
PATH #f NETEZZA/bin ;JC ;JC
LIBPATH/
LD_LIBRARY_PATH/
SHLIB_PATH
#f N E T E Z Z A / l i b r
NETEZZA/lib64
;JC ;JC
APT_NETEZZA
_LOAD_FILES
C'(e $APT_NETEZZA
_LOAD_FILES
Netezza U>/msD~D;C
/home/dsadm/nzlogs
APT_TMPDIR C'(e $APT_TMPDIR Netezza U>/msD~D;C
/home/dsadm/nzlogs
APT_NZ_UNIQUE_
KEY_NOT_
ALLOWED
C'(e $APT_NZ_UNIQUE
_KEY_NOT_
ALLOWED
2G<NC'gfP
8(D(;|
APT_NZ_UNIQUE
_KEY_NOT_
ALLOWED=1
a{
Xky]53OKPD=(4hC PATH/LIBPATH/LD_LIBRARY_PATH/
SHLIB_PATH#k9CBmPa)DE"4hC PATH/LIBPATH/LD_LIBRARY_PATH/
SHLIB_PATH#
m 3. X(=(D73d?
=( *hCD73d?
Microsoft Windows PATH
IBM AIX LIBPATH
Solaris M Linux LD_LIBRARY_PATH
HP-UX SHLIB_PATH
v 20 Netezza M'z.s,k|B .../etc/hosts D~#Xk9C Netezza ~qwM
IP X7E"4|BCD~#*9C|na>{CJCD~,k9C etc/hosts |nP#
Z Windows zwP,CD~;Z Windows/system32/drivers/etc P#
":zIT!q(} IBM InfoSphere DataStage !Cer9C|na>{4dC
Netezza Enterprise WN#>wbvhvKgN9C InfoSphere DataStage !Ce4d
Z 2 B Netezza Enterprise WN 11
CCWN#PX9C|na>{4dCCWNDj8E",kND6IBM InfoSphereDataStage and QualityStage "Pw5_6*"_8O7#
dC}]4
*K\;9C Netezza Enterprise WN,XkJ1XdC}]4#
XZKNq
z+(}TBZ]4KbgN* Microsoft Windows M UNIX dC}]4#
Z Windows =(OdC}]4:XZKNq
Z@fO,%w*< > XFfe > \m$_ > }]4 (ODBC)#
Z“ODBC }]4\mw”T0rP,mSBD}]4{F#*mSBD}]4{F,k
S“4(B}]4”T0rP!qJ1D ODBC }/Lr,;shC`&DN}#
hCN}1,k7#e};A!n#1!ivB,C!n;!P#
Z UNIX =(OdC}]4:XZKNq
*Z UNIX zwO* Netezza Enterprise WNdC}]4{F,XkZ $DSHOME P
4("dC odbc.ini D~#k+TBu?mS= .odbc.ini D~P#
[ODBC Data Sources]NZSQL = NetezzaSQL[NZSQL]Driver = /usr/local/nz/lib/libnzodbc.soDescription = NetezzaSQL ODBCServername = 127.0.0.1Port = 5480Database = devUsername = guestPassword = passwordReadOnly = falseShowSystemTables = falseLegacySQLTables = falseLoginTimeout = 0QueryTimeout = 0DateFormat = 1NumericAsChar = falseSQLBitOneZero = falseStripCRLF = falsesecurityLevel = preferredUnSecuredcaCertFile =
J1XhCC'(eD73d?M#f73d?#
Netezza enterprise WNYw
zIT9C Netezza enterprise WN44PTByPD}]bYw:
v S Netezza Performance Server A!}]#
v 9C nzload rb?m+}]4k Netezza Performance Server#
v |B/|Bek?jmPD}]#
12 Netezza Performance Server ,S8O
AYw
&ZA!==D Netezza enterprise ICZS Netezza Performance Server PA!m#
B<G;v|,&ZA!==D Netezza enterprise WNDy> InfoSphere DataStage w
5#
4Yw
Z4k==B9C Netezza enterprise WN4PTB|BekYw:+G<ekb?}
]4mP,Sb?}]4mP>}G<#
|B/>}/|BekYwZ upsert ==B9C Netezza Enterprise WNI4P upsert Yw#
upsert Yw|(:
v |Bb?}]4mPDG<#
v >}b?}]4mPDG<#
v |BG<"+dekb?}]4m#
v >}G<"+dekb?}]4m#
9C Netezza Enterprise WN+}]4k Netezza PerformanceServer
*+}]4k Netezza Performance Server,Xk9CICDOE!n4(w5,;s*
Netezza Enterprise WN0ddk4ShC`&DtT#
XZKNq
z+(}TBZ]4KbgN9CICD!n+}]4k Netezza Performance Server#
hCdk4SDtT
Z“WN”!n(O* Netezza Enterprise WNhCtT#
XZKNq
Netezza Enterprise WN;P;vdk4S,CZ+}]4k;vmP#
1Z IBM InfoSphere DataStage !CeP+w Netezza Enterprise WN<j1,aT>
;vT0r#CT0r+T>=v!n(:WNMdk#1!ivB,“dk”!n(
&Zn/4,,C!n(T>“dk”3f#
zIT9C%w“WN”!n(14=D“WN”3f4hC Netezza Enterprise WND#f
tT#PXhCK`tTDj8E",kNDhC Netezza Enterprise WNDtT?V#
zIT9CC3f4hCdk4SDtT,T7(+}]4k Netezza Performance Server
D==#zIT4PBPNq4hCdk4SDtT:
v 8( Netezza Enterprise WNDhv
v hC Netezza Enterprise WNDtT
v 8(+k}]DVxE"
v 8(+k}]DP(e
Z 2 B Netezza Enterprise WN 13
v 8(dk4SD:ehC
8( Netezza Enterprise WNDhv:XZKNq
9C“dk”3fOD“#f”!n(I8(dk4SDhv#bGI!&\#
hC Netezza Enterprise WNDtT:XZKNq
1!ivB,“dk”3fOD“tT”!n(&Zn/4,#Z“tT”!n(B,z+4
=;vtTPm,dPDtTQ;V* 3 v`p:?j",SM!n#*`-3;t
T,kSCPmP!qCtT#z+ZtTPmTDVNP4=PXy!tTDE
"#kDATBZ],TKbgNhCb)tT#ZKbgNhCb)tT.0,X
kHKb;BU>D~#
U>D~
*KbZNN}]bYwZd"zDmsT0b)YwI&kq,Xki$U>D
~#*KcZiRU>D~,kTb?mM nzload =(DU>D~|{<(gBy>:
v Netezza msU>D~+y]4EH63r(eD APT_NETEZZA_LOAD_FILES r
APT_TMPDIR 73d?4k3v?<#1!ivB,msU>D~+4k Netezza
Performance Server D .../tmp ?<P#b?m0k=(DU>D~{F*:
– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzlog M
– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzbad
v TZ nzload 0k=(,aZM'zzwD .../tmp ?<P4(U>D~#nzload 0
k=(DU>D~*:
– <}]b{F>.<m{F>.<1dAG.p<VxE>.log M
– <}]b{F>.<m{F>.<1dAG.p<VxE>.bad
?j
ZC`pB,Xk8(BP!nD5:
v 0k=(
v m
v 4k=(
v 4k==
Bf+j8hvb)tT#
v 0k=(
8(G*9C nzload 5CLr9G*9Cb?m44k}]#1!0k=(*
nzload#g{z_PkT Netezza Performance Server PD?jmDT= LOAD X
("RZ53P20K Netezza M'z,G4IT9C nzload#qr,&C!q ET(b?m)0k=(#ET 0k=(;*sz_PkT?jmD C R E A T E
TABLE"SELECT M INSERT X(#
14 Netezza Performance Server ,S8O
":1KPmSKIC ET 0k=(D Netezza Enterprise WNDw51,aZ
Netezza Performance Server D /tmp ?<P(x;G InfoSphere DataStage ~qw
P)4(U>D~#
v m
8(zk*4k}]DmD{F#k9CTBN;=(,TZCVNP8(m{
F:
– =( 1:Z“tT”3fR`DmVNPdkm{F#
– =( 2:ekZ{D5w*w5N}#%w“tT”3fnR`D8k4%,;s%
wekw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5t
T”T0rP4(J1D73d?#
(}9C IBM InfoSphere DataStage and QualityStage Administrator M'z,9
I*n?PDyPw54(n?6N}#
v 4k=(
a)K;vCZ+}]4k?jmrZ?jmP|B/|Bek/>}}]D!n#
g{!q4k=( = 4k,G4zIT!q9C>zz? nzload 5CLrr9Cb
?m40k}]#
– 4k==:8( Netezza enterprise WN&gN+}]4k Netezza Performance
Server#zITSTB!nP!q:
- 7S:7SyPP#
- 4(:4(Bm#
- f;:f;VPmrf;VPmPDyPP#g{Cm;fZ,G4+4(B
m#g{?jmfZ,G4+>}Cm"4(Bm#
- XO:XOVPmPDG<#
g{!q4k=( = |B,G4aT>|B==!n#g{!q|B== = |B"
|B;sekr>};sek,r“?j”`pB;aYT>4k==#
– |B==:a)K;vCZy]iO|Z?jmP|B(|B== = |B)G<
"|B;sek(|B== = |Bek)G<">}G<r>};sekG<D
!n#k8(TB5:
- |P:!qXk;S*|RtZiO|;?VD|P{F#
":g{iO||,`v|P,G4&!q;,D|P#g{y!|PX4,
G4 Netezza Performance Server aT>;ums{","R;axP|B#
- (;|P:!q*w*(;|DP#(;|P&CG;vUZ/1d"1dAG
rrE (int/bigint) P#z&Zdk Dataset P*yPG<8((;5#(;|
P;&GiO|D;?V,R;&!qiO|PD|Pw*(;|#Xk*(
;|P8(5#+G,zIT9C APT_NZ_UNIQUE_KEY_NOT_ALLOWED 7
3d?42GC!n#g{hCKC!n,G4|B1;a<G<NC'gf
Oy8(D(;|P#;PZ|B Netezza }]bPDm1Ea<GiO|PD
P#
Z 2 B Netezza Enterprise WN 15
- I|BDP:!qdk Dataset Ph*|BDP#
":kp!qQ!w|Pr(;|PDP#
- Y1$wm:8(Y1$wmD{F#1!ivB,Y1$wmGI Netezza
Performance Server PD Netezza Enterprise Edition |BekWN44(D#
- >}$wm:!q True I>}Cm0T&DP#!q False I#tCm0T&DP#
,S
ZC`pB,Xk8(BP5:
v }]4:8(}]4D{F#
v }]b:g{9C nzload 0k=(,G4k8(h*,SD?j}]bD{F#k
7#dkD{Fk}]4P8(D}]b{F`,#qr,;a4k}]#g{9
C ET 0k=(,G4;h*}]b{F#bGr* ET 0k=(9C ODBC
DataDirect }/Lr#
":g{za)D}]bj8E";}7,G4zaU=/(#
v \k:8(CZ,S}]bD\k#
v ~qw:8(Z+}]0k Netezza Performance Server 1*9CD~qwD{F#
v ;,}]bPD$wm (TWT):1!5* False#!q True T9C?jm}]b.bDd{}]bPDY1$wm (TWT)#"b,b)}]bXk;Z,;om
Netezza ~qwO#
v TWT }]b:8(h*9CD TWT }]bD{F#
v C':8(CZ,S}]4DC'{#
*8(OvVND5,k9CTBN;=(:
v =( 1:Z“tT”3fR`D`&VNPdkJ1D5#}g,1!q“}]4”1,
ITZT>ZC3fR`D}]4VNP1SdkZ{D}]4{F#
v =( 2:ekZ{D5w*w5N}#%w“tT”3fnR_D8k4%,;s%w
ekw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g{
#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”T
0rP4(J1D73d?#
!n
ZC`pB,Xk8(BP!nD5:
v XOP{F
v r*|n
v XU|n
v >};%dP
v (g{
v Netezza 0k!n
16 Netezza Performance Server ,S8O
1!ivB,!n`pBavVXU|nMXOP{FVN#I(}“tT”3fRB
GT>DI)mSDtTPm4mSOfa0Dd{tT#Bf+hvOvw!n#
v XOP{F
KVN*I!VN#!q“True”I+P{FXO* Netezza Enterprise WNJmDs!#!q“False”I{9XOVN{F#
v r*|n
KVN*I!VN#kZ%}EP8(J1D|n#Zr*4m.0,Netezza Enter-
prise WNaZyP&mZcOTC|nxPo(Vv"KPC|n#
*8(r*|nD5,k9CTBN;=(:
– =( 1:Z“tT”3fR`Dr*|nVNPdk|n#
– =( 2:ekZ{D5w*w5N}#%w“tT”3fnR_D8k4%,;s%
wekw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5t
T”T0rP4(J1D73d?#
v XU|n
KVN*I!VN#kZ%}EP8(J1D|n#Z&mCCm.s,Netezza
Enterprise WNaZyP&mZcOTC|nxPo(Vv"KPC|n#
*8(XU|nD5,k9CTBN;=(:
– =( 1:Z“tT”3fR`DXU|nVNPdk|n#
– =( 2:ekZ{D5w*w5N}#%w“tT”3fnR_D8k4%,;s%
wekw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5t
T”T0rP4(J1D73d?#
g{8(DXU|n'\,+"zB|ms#Cms+G<Z $DSHOME BD`
&U>D~P#;x,491i/'\1,z}Z4(Dw5D4,ZU>D~
PT+T>* OK#zXki4U>D~T7(i/GqI&#
":w5YwDU>D~;Z $DSHOME P#
v >};%dP
KVN*I!VN#!q“True”IC Netezza Enterprise WN>}kz!q7SDm
DP;%dDyPP#>};%dDP1,z;aU=NN/({"#1!5*
False#g{#tC1!5,G4ZKP1zaU=/({",xRw52+U9#
v (g{
ZCVNP8(VN5rPD(g{#k7#ZCVNP8( ASCII V{#1!(g
{* @#I9C}Uq(“ ”)M,V{(“-”)TbDNN ASCII V{#,V{Q
CwUZ/1d/1dAGD(g{#
*8((g{,k9CTBN;=(:
Z 2 B Netezza Enterprise WN 17
– =( 1:Z“tT”3fR`D(g{VNPdkZ{D ASCII V{#
– =( 2:ekZ{D5w*w5N}#%w“tT”3fnR_D8k4%,;s%
wekw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5t
T”T0rP4(J1D73d?#
":g{!q ET 0k=(,G4 Netezza Enterprise WN+kTQ4PD?vY
w4(b?m#g{4R=b)m,G4+ZU>D~PG<ms,xRCWN
a"T>}4R=Dm#;x,y"zDms;ah9z4(w5#(g{+Z
<NC'gfPxP,$,T'Vrsf]T#
v Netezza 0k!n:C!nICZ8(Z1!ivB ET r nzload 0k=(4a0
D0k!n#0k!na1S+]= nzload 5CLrr ET#
":g{0k=( = nzload,G4kp9CTB0k!n:
– -u
– -pw
– -db
– -df
– -1f
– -bf
– -t
– -delim
– -escapeChar
– -boolStyle
– -encoding
– -nullValue
– -maxErrors
g{0k=( = ET,G4kp9CTB0k!n:
– remotesource
– delimiter
– ignorezero
– ctrlchars
– escapechar
– logDir
– boolStyle
– encoding
– nullValue
Bmc\K Netezza Enterprise WNDtT#
18 Netezza Performance Server ,S8O
m 4. ?jtT
tT I)!qD5 1!5 GqXh?
0k=( v nzload
v ET
;JC G
m ;JC ;JC G
4k== v 7S
v 4(
v f;
v XO
7S G
|B== TZ|B== = |B/|B;sek:
v (;|P
v |P
v I|BDP
v Y1$wm
v >}$wm
TZ|B== = >}/>};sek:
v |P
v Y1$wm
v >}$wm
True G
m 5. ,StT
tT I)!qD5 1!5 GqXh?
}]4 ;JC ;JC G
}]b ;JC ;JC v G(g{0k=(
* nzload)
v q(g{0k=(
* ET)
\k ;JC ;JC G
~qw ;JC ;JC G
;,}]bPDY1
$wm (TWT)
True/False False v G(g{>}$w
m* True)
v q(g{>}$w
m* False)
TWT }]b ;JC ;JC G
C' ;JC ;JC G
m 6. !ntT
tT I)!qD5 1!5 GqXh?
XOP{F v True
v False
False q
Z 2 B Netezza Enterprise WN 19
m 6. !ntT (x)
tT I)!qD5 1!5 GqXh?
XU|n ;JC ;JC q
>};%dP True M False False q
Create od ;JC ;JC q
r*|n ;JC ;JC q
(g{ ;JC @ q
Netezza 0k!n ;JC ;JC q
8(+k}]DVxE":
XZKNq
9C“Vx”!n(I8(Z++k}]4k}]b.0gNTb)}]xPVx#
8(+k}]DP(e:
XZKNq
9C“P”!n(I8(+k}]+4k=dPDmDP(e#
8(dk4SD:ehC:
XZKNq
9C“_6”!n(I|Ddk4SD1!:ehC#
hC Netezza Enterprise WNDtTzXkhCtTE\9C Netezza Enterprise WN#
XZKNq
!q“WN”!n(T8(PXCWND#fE"#J1XhCCWNDtT|(:
v 8( Netezza Enterprise WNDhv#
v 8( Netezza Enterprise WNDKP==#
v 8( Netezza Enterprise WNDV{/3d#
TB8v?Vj8hvKOvNq#
8( Netezza Enterprise WNDhv#
bGI!&\#k9C“#f”!n(,Tdk Netezza Enterprise WNDhv#
8( Netezza Enterprise WNDKP==#
*8( Netezza Enterprise WNDKP==,Xk9C“_6”!n(J1XhCTBw
n:
v 4P==:IT+ Netezza Enterprise WNhC*T"P==r3r==4P#Z"
P==B,+IdCD~P8(DICZcy]9C“_6”!n(8(DyPZc
<x4&m*0kD}]#1!ivB,Netezza Enterprise WNT"P==KP#
Z3r==B,w<Zca&m*0kD}]#
20 Netezza Performance Server ,S8O
v iO==:1!ivB,iO==;hC*T/#(}9CCT/==,Netezza
Enterprise WN+O""PWNyyZDwVd{WN,Sx9b)"PWNZ,;x
LPKP(0aG Netezza Enterprise WN'Vb)"PWN)#
v dCD~:9CC!nI!qMhCJ1DdCD~#*hCdCD~,XkhC
BP!n#
– ZcXMJ4<x#!qC!nI"P4Pzy8(DZcXMJ4X#
– Zc3d<x#!qC!nI"P4PQ(eDZc3dPDZc#zIT(}
1SZZc3d<xVNPdkZc}4(eZc3d#r_,%w/@ [...] 4%,TS“ICZc...”0ZP!qZc"SPmP!qJ1DZc#
8( Netezza Enterprise WNDV{/3d#
v1Z53OtCK NLS(>XoT'V)1,EaZ“WN”3fOT>“NLS 3d”!
n(#9C NLS 3dI(e Netezza Enterprise WNDV{/3d#*(eV{/3
d,k9CTBN;=(:
v =( 1:Z3d{FVNPdkZ{D3d{F#
v =( 2:S3d{FPmP!qJ1D3d(g{P)#
v =( 3:ekZ{D5w*w5N}#%w“tT”3fR`D8k4%,;s%we
kw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g{
#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”T
0rP4(J1D73d?#
9C=( 2 a2G10}Z9CDn?rw5D1!V{/3d#
9C Netezza Enterprise WNS Netezza Performance ServerPA!}]
9C Netezza Enterprise WNS Netezza Performance Server PA!}]#
XZKNq
4(;vw5,;s* Netezza Enterprise WN0ddv4ShC`&DtT#
hCdv4SDtT
Z“dv”3fOhCdv4SDtT#
XZKNq
Netezza Enterprise WNP;vdv4S,CZ+}]Ak;vmP#
1Z IBM InfoSphere DataStage !CeP+w Netezza Enterprise WN<j1,aT>
;vT0r#CT0r+T>=v!n(:WNMdv#1!ivB,“dv”!n(
&ZtC4,,C!n(T>“dv”3f#
kZ“dv”3fOhCCZXFS Netezza Performance Server PA!}]D==Dt
T#zIT4PBPNq4hCdv4S:
v 8( Netezza Enterprise WNDhv
v hC Netezza Enterprise WNDtT
Z 2 B Netezza Enterprise WN 21
v 8(+v}]DP(e
v 8(dv4SD:ehC
8( Netezza Enterprise WNDhv:XZKNq
9C“dv”3fOD“#f”!n(I8(dv4SDhv#bGI!&\#
hC Netezza Enterprise WNDtT:XZKNq
1!ivB,“dv”3fOD“tT”!n(&ZtC4,#Z“tT”!n(B,z+4
=;vtTPm,dPDtTQ;V* 3 v`p:4",SM!n#*`-3;tT,
kSCPmP!qCtT#z+ZtTPmTDVNP4=PXy!tTDE"#
U>D~
*KbZNN}]bYwZd"zDmsT0b)YwI&kq,Xki$U>D
~#*KcZiRU>D~,kTb?mM nzload =(DU>D~|{<(gBy>:
v Netezza msU>D~+y]4EH63r(eD APT_NETEZZA_LOAD_FILES r
APT_TMPDIR 73d?4k3v?<#1!ivB,msU>D~+4k Netezza
Performance Server D .../tmp ?<P#b?m0k=(DU>D~{F*:
– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzlog M
– NZORCH.<1dAG >_<VxE>.<}]b{F>.nzbad
4
ZC`pB,Xk8(BP!nD5:
v A!=(
v m
Bf+j8hvb)tT#
v A!=(
8(gNA!}]#zIT9C Table 5CLr"T/zID SQL odrC'(e
D SQL od#1!5* Table#
v m
8(*SPA!}]DmD{F#
– Z“tT”3fR`DmVNPdkm{F#
– ek5w*w5N}#%w“tT”3fnR`D8k4%,;s%wekw5N
}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”
T0rP4(J1D73d?#
(}9C IBM InfoSphere DataStage and QualityStage Administrator M'z,9
I*n?PDyPw54(n?6N}#
22 Netezza Performance Server ,S8O
,S
ZC`pB,Xk8(BP5:
v }]4:8(}]4D{F#
v }]b:8(h*,SD?j}]bD{F#dkD{FXkk}]4P8(D}
]b{F`,#qr,;aA!}]#
v \k:8(CZ,S}]bD\k#
v ~qw:8(Z+}]i!= Netezza Performance Server 1*9CD~qwD{F#
v C':8(CZ,S}]4DC'{#
*8(OvVND5,k9CTBN;=(:
v Z“tT”3fR`D`&VNPdkJ1D5#}g,1!q“}]4”1,ITZ
T>ZC3fR`D}]4VNP1SdkXhD}]4{F#
v ekXhD5w*w5N}#%w“tT”3fnR_D8k4%,;s%wekw
5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g{
**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”T0
rP4(J1D73d?#
!n
k8(TBI!tTD5:
v r*|n
v XU|n
v (g{
v r*|n
kZ%}EP8(J1D|n#Zr*4m.0,Netezza Enterprise WNaZyP&
mZcOTC|nxPo(Vv"KPC|n#
*8(r*|nD5,k9CTBN;=(:
– Z“tT”3fR`Dr*|nVNPdk|n#
– ekXhD5w*w5N}#%w“tT”3fnR_D8k4%,;s%wek
w5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”
T0rP4(J1D73d?#
v XU|n
kZ%}EP8(J1D|n#Z&mCCm.s,Netezza Enterprise WNaZyP
&mZcOTC|nxPo(Vv"KPC|n#
*8(XU|nD5,k9CTBN;=(:
– Z“tT”3fR`DXU|nVNPdk|n#
Z 2 B Netezza Enterprise WN 23
– ekXhD5w*w5N}#%w“tT”3fnR`D8k4%,;s%w“ek
w5N}”#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”
T0rP4(J1D73d?#
g{8(DXU|n'\,+"z;IV4ms#Cms+G<Z $DSHOME B
D`&U>D~P#;x,491i/'\1,z}Z4(Dw5D4,ZU>
D~PT+T>* OK#zXki4U>D~T7(i/GqI&#
v (g{
k8( ASCII V{TCwVN5rPD(g{#1!(g{* @#I9C}Uq(“
”)M,V{(“-”)TbDNN ASCII V{#
*8((g{,k9CTBN;=(:
– Z“tT”3fR`D“(g{”VNPdkXhD ASCII V{#
– ekXhD5w*w5N}#%w“tT”3fnR`D8k4%,;s%w“ek
w5N}”#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g
{**Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”
T0rP4(J1D73d?#
":(g{+Z<NC'gfPxP,$,T'Vrsf]T#
8(+v}]DP(e:
XZKNq
9C“P”!n(I8(+v}]+Ak=dPDmDP(e#
8(dv4SD:ehC:
XZKNq
9C“_6”!n(I|Ddv4SD1!:ehC#
hC Netezza Enterprise WNDtT:
zXkhCtTE\9C Netezza Enterprise WN#
XZKNq
!q“WN”!n(T8(PXCWND#fE"#J1XhCCWNDtT|(:
v 8( Netezza Enterprise WNDhv#
v 8( Netezza Enterprise WNDKP==#
v 8( Netezza Enterprise WNDV{/3d#
TB8v?Vj8hvKOvNq#
8( Netezza Enterprise WNDhv#
bGI!&\#k9C“#f”!n(,Tdk Netezza Enterprise WNDhv#
24 Netezza Performance Server ,S8O
8( Netezza Enterprise WNDKP==#
*8( Netezza Enterprise WNDKP==,Xk9C“_6”!n(J1XhCTBw
n:
v 4P==:IT+ Netezza Enterprise WNhC*T"P==r3r==4P#Z"
P==B,+IdCD~P8(DICZcy]9C“_6”!n(8(DyPZc
<x4&m*0kD}]#1!ivB,Netezza Enterprise WNT"P==KP#
Z3r==B,w<Zca&m*0kD}]#
v iO==:1!ivB,iO==;hC*T/#(}9CCT/==,Netezza
Enterprise WN+O""PWNyyZDwVd{WN,Sx9b)"PWNZ,;x
LPKP(0aG Netezza Enterprise WN'Vb)"PWN)#
v dCD~:9CC!nI!qMhCJ1DdCD~#*hCdCD~,XkhC
BP!n#
– ZcXMJ4<x#!qC!nI"P4Pzy8(DZcXMJ4X#
– Zc3d<x#!qC!nI"P4PQ(eDZc3dPDZc#zIT(}
1SZZc3d<xVNPdkZc}4(eZc3d#r_,%w/@ [...] 4%,TS“ICZc...”0ZP!qZc"SPmP!qJ1DZc#
8( Netezza Enterprise WNDV{/3d#
v1Z53OtCK NLS(>XoT'V)1,EaZ“WN”3fOT>“NLS 3d”!
n(#9C NLS 3dI(e Netezza Enterprise WNDV{/3d#*(eV{/3
d,k9CTBN;=(:
v =( 1:Z3d{FVNPdkZ{D3d{F#
v =( 2:S3d{FPmP!qJ1D3d(g{P)#
v =( 3:ekZ{D5w*w5N}#%w“tT”3fR`D8k4%,;s%we
kw5N}#
K1+T>;v|,ICw5N}DPm,zISCPmP!qJ1DN}#g{
#{*Cw54(BN},kSCPm%w“[B(...]”,;sZvVD“w5tT”T
0rP4(J1D73d?#
9C=( 2 a2G10}Z9CDn?rw5D1!V{/3d#
Netezza enterprise WND}]`MTZA!"4kM|B/|BekYw,Netezza enterprise WN'VTB}]`M#
A!YwD}]`M
Netezza Performance Server"ODBC M Orchestrate PD,Hn'V`V Netezza AW
N}]`M#
m 7. Netezza A!WN}]`M
Netezza SQL `M ODBC SQL `M Orchestrate }]`M
INTEGER SQLINT4 Int32
BIGINT SQLINT8 Int64
SMALLINT SQLINT2 Int16
Z 2 B Netezza Enterprise WN 25
m 7. Netezza A!WN}]`M (x)
Netezza SQL `M ODBC SQL `M Orchestrate }]`M
NUMERIC SQLNumeric (p, s) decimal (p, s)
Decimal SQLDECIMAL decimal (p, s)
Real SQLFLT4 decimal (p, s)
Double SQLFLT8 decimal (p, s)
Char (n) SQLCHARACTER (n) string (n)
Varchar (n) SQLCHARACTER (n) string (max=n)
Nchar (n) SQLNCHAR ustring (n)
Nvarchar (n) SQLNCHAR ustring (max=n)
Date SQLCHARACTER Date
Time SQLCHARACTER Time
Timestamp SQLCHARACTER Timestamp (n)
BOOLEAN SQLCHAR (1) char (1)
4kYwD}]`M
Netezza Performance Server"ODBC M Orchestrate PD,Hn'V;) Netezza 4W
N}]`M#
m 8. Netezza 4kWN}]`M
Netezza SQL `M ODBC SQL `M Orchestrate }]`M
INTEGER SQLINT4 Int32
BIGINT SQLINT8 Int64
SMALLINT SQLINT2 Int16
NUMERIC SQLNumeric (p, s) decimal (p, s)
Decimal SQLDECIMAL decimal (p, s)
Real SQLFLT4 decimal (p, s)
Double SQLFLT8 decimal (p, s)
Char (n) SQLCHARACTER (n) string (n)
Varchar (n) SQLCHARACTER (n) string (max=n)
Nchar (n) SQLNCHAR ustring (n)
Nvarchar (n) SQLNCHAR ustring (max=n)
Date SQLCHARACTER Date
Time SQLCHARACTER Time
Timestamp SQLCHARACTER Timestamp (n)
|B/|BekYwD}]`MNetezza Update WN'V`V NetezzaSQL }]`M(g INTEGER M BIGINT)#
Bmc\K Netezza Performance Server"ODBC M Orchestrate }]`M.dD;T;
3d#
26 Netezza Performance Server ,S8O
m 9. Netezza |B/|BekYwD}]`M
Netezza SQL `M ODBC SQL `M Orchestrate }]`M
INTEGER SQLINT4 Int32
BIGINT SQLINT8 Int64
SMALLINT SQLINT2 Int16
NUMERIC SQLNumeric (p, s) decimal (p, s)
Decimal SQLDECIMAL decimal (p, s)
Real SQLFLT4 decimal (p, s)
Double SQLFLT8 decimal (p, s)
Char (n) SQLCHARACTER (n) string (n)
Varchar (n) SQLCHARACTER (n) string (max=n)
Nchar (n) SQLNCHAR ustring (n)
Nvarchar (n) SQLNCHAR ustring (max=n)
Date SQLCHARACTER Date
Time SQLCHARACTER Time
Timestamp SQLCHARACTER Timestamp (n)
Text SQLText ;JC
Z 2 B Netezza Enterprise WN 27
28 Netezza Performance Server ,S8O
Z 3 B Netezza connector
IZ Netezza connector DfZ,IBM InfoSphere Information Server $_IT,S Netezza
}]b,+}]b*}]<k= InfoSphere Information Server *}]f"bP,"C
J}]bPD}]#,Swa)hFw519C Netezza }]D%;=(#
zIT9C Netezza connector 4PTBYw:
v A!"4k"iR Netezza }]bmPD}]#
v 4(">}MXOm#
v 4P#fiRM!hiRYw#
v +TB*}]<kw5P:
– mMP(e
– Netezza }]bDPm
– m
– S<
– }]bp{
v &myP Netezza }]`M(1ddt`M}b)#
v &m>XoT}]#
9C Netezza connector hFw5zIT9C IBM Netezza connector *"A!"4kM0k}]Dw5,T0+;vw
5PDi~f"Zf"bPTcZm;vw5P4C#
*<.0
i$CZ,S Netezza }]bDC'{Gq_P4Pw5*sDYwyhD(^MX
(#
}L
1. S Netezza 4<k*}]#
2. (e Netezza connector w5#
3. *+ Netezza Connector WNhC*A! Netezza mPD}]:
a. + Netezza connector dC*4#
b. hCdv4SODP(e
c. (e}]A!DC(tT#
d. I!: (e}]Vx==#
4. *+ Netezza Connector WNhC*r Netezza mP4k}]:
a. + Netezza connector dC*?j#
b. hCdv4SODP(e,g{P4*4S8(P(eD0#
c. (e}]4kDC(tT#
d. I!: (e}]Vx==#
© Copyright IBM Corp. 2005, 2014 29
5. 9C}C4SiR}]#
6. `k"KPw5#
<k Netezza *}]Z9C Netezza ,SwA/4riR}].0,ITH9C InfoSphere Metadata Asset
Manager <km> Netezza }]4PmMS<D*}]#;sa+<kD*}]#fZ
*}]f"bP#
*<.0
v Z Linux M UNIX OrZ Windows O,y]h*dCT Netezza }]bDCJ#
v 7#TBP}]bTs_P SELECT X(:
– _T_ATTRIBUTE
– _T_CONSTRAINT
– _T_CONST_REFATTR
– _T_CONST_RELATTR
– _T_DESCRIPTION
– _T_OBJECT
– _V_DATABASE
– _V_OBJ_RELATION
– _V_RELATION_COLUMN
– _V_SYNONYM
– _V_VIEW
XZKNq
(}9C Netezza ,Sw,IT<kXZTBJz`MD*}]:
v |, Netezza }]bDwz#
v }]b#
v }]b#=#
v }]bm"53mMS<#yP<kDm<T}]bmDN=f"Z*}]f"b
P#
v }]bP#
}L
9C InfoSphere Metadata Asset Manager <k*}]# PX9C InfoSphere Metadata
Asset Manager <k*}]D|`E",kND IBM Knowledge Center r IBM
InfoSphere Information Server Guide to Managing Common Metadata PD*zz7D
5#
Netezza j6Z Netezza connector P,j6zmZwVm{FtTPdkDm{F,rZV/dk
D SQL odP}CDm{F#j69m>mP#
30 Netezza Performance Server ,S8O
Netezza 'V|{j6D SQL 1999 (e,|Gn`I|, 128 vVZ#j6P=V
`M:
v #f
v (g
Netezza connector 'Vm{FtTMC'(eDodPD#fj6M(gj6#
#fj6
#fj6xVs!4,Ts4DN=f"Z}]bP##fj6XkTV8*7;|
GD*7;\*}V"B._r@*{E##fj69;\G SQL #tV#Netezza ?
<PD`kIC UTF-8;NNT>D`k+!vZM'z##fj6;\|,TBn:
v V8(NNV8m,x;v^Z-!V8m)
v tZ(}gUo=Y{tZ)
v sNDV
v .xF}V
v B._
v @*{E
(gj6
(gj6C+}E(p,w*Xb<Gn#|GGxVs!4D#Netezza 53;a+(
gj6*;*1!53s!4,2;+CZ(pV{.D+}E#fZ}]bP#(
gj6IT+`,DV8"tZ"sNDV".xF}V"B._w*#fj6|,
Z+}EP,+|9IT|,Uq"XbV{(}g,VEMYVE)T0 SQL #t
X|V#(gj6ITTNNV8"}Vr{E*7#
}C}]bTs
Netezza 'V=6M}6|{#
=6|{CZ}C,;}]bPDTs#}g schema.object-name#
}6|{CZ}C,;om Netezza ~qwOm;v}]bPDTs#}g database-
name.schema.object-name#
9'VYG}6q=#}g database-name..object-name#ZbVivB,58#={
F"hC*10#={F#
":g}]bCJ'Vv^ZA!Yw#Netezza ;'V^D;,}]bPDm#
'VDV{`k
InfoSphere DataStage >XoT'V (NLS) 9z\;9C Unicode V{/&mT>Xo
Tm>D}]#i$?jFczDYw53Gq9C\'VDV{`k#
Netezza ~qw'VTB=VV{`k:
v Latin-9 - CHAR M VARCHAR
v UTF-8 - NCHAR M NVARCHAR
Z 3 B Netezza connector 31
;\xPdC#(}\@rD~"MrSU}]1,9C`,D`k#
(e Netezza connector w5(} Netezza connector,9C InfoSphere DataStage and QualityStage Designer M'z
(ew5#
}L
1. S Designer M'zP,!qK%ODD~ > B(#
2. Z“B(”0ZP,!q"Pw5r~qww5<j,;s%w7(#
3. Z!CeK%PhFwM'zDs_,!q}]b`p#
4. R=IC}]bPmPD Netezza connector,;s%wrB}7Ti4ICDWN#
5. + Netezza Connector WN<jO/=w5hF-<O#
6. dkr^DTBtT:
v Netezza Connector WNr4SD{F:^D,Swr4SD1!{F#zn`
ITdk 255 vV{#mb,z2ITZw5hF-<P^DWNr4SD{
F#
v hv:dkWNr4SDI!hv#
7. %w#f#
B;=v24
(etTT+ Netezza connector w*49C#
A!}]
*9C Netezza connector A! Netezza mPD}],zh*+ Netezza connector d
C*+}]w*44&m#Netezza connector KP SQL od,"+a{5X*cPr
|`P#w*4,,Swi!rA!b? Netezza }]4D}]#
B<T>9C Netezza connector A!}]D>}#ZK}P,Netezza connector
Netezza_Connector_1 A!4T Netezza ~qwD}],;s sequential file WN+
d4k Sequential_File_3 D~#dC Netezza connector A!}]1,;4(;vd
v4S DSoutputLink(gB<y>),|+ Netezza_Connector_1 PDP+d=Sequential_File_3 P#
32 Netezza Performance Server ,S8O
+ Netezza connector dC*4:
(}+ Netezza connector dC*+}]w*44&m,zIT9C Netezza Connector
WNA!}]#
}L
1. Zw5hF-<O,+w Netezza Connector WN<j#
2. %wdv!n(,;s!q*`-Ddv4S# (}`-dv4S,+ Netezza Con-
nector WNhC*4#
3. !qtT!n(#
4. Z,S?V,8((",Sh*9CD}]4"}]b"C'{M\k#
5. %w#fT#f8(D,ShC#
hCP(e:
zIT9C`FD=(*AYwM4YwhCP(e#9IT(FPxq"#fP(
eT8sC,T0Sf"b0kQ$(eDP(e#
}L
1. Zw5hF-<O,+w Netezza connector <j#
2. ZWN`-wP,!qdv!n(rdk!n(#
3. ZP!n(O,^DPxqT8(*(eD*}]#
a. ZxqZR|%w,"SK%P!qtT#
b. Z“xqtT”0ZP,!qk*T>DtTT0tTDT>3r#;s,%w
7(#
4. 9CTB=(.;4dkmDP(e:
!n hv
=( 1 1. ZP{FPPD`&%*qZ+w,"d
kP{F#
2. TZPPD?v%*q,Z%*qZ+w
"!qyh!n#
3. ZhvPPD`&%*qZ+w,"dk
hv#
< 1. A!}]>}
Z 3 B Netezza connector 33
!n hv
=( 2 1. Z%*qZR|%w,;sSK%P!q
"4`-#
2. Z“`-P*}]”0ZP,dkP*}]#
5. *Z`vP.d2m*}],k!q*2m*}]DwP#
a. R|%w"!q+%5#
b. Z“+%P5”0ZP,!qzk*!(DP2mDtT#
6. *Zf"bP+P(e#f*m(e,k%w#f#
a. Z“#fm(e”0ZPdkJ1DE",;s%w7(#
b. Z“+m(emf*”0ZP,!qzk*CZ#fm(eDD~P,;s%w
#f#
7. *Sf"b0kP(e,%w0k#
a. Z“m(e”0ZP,!qzk*0kDm(e,;s%w7(#
b. Z“!qP”0ZP,9C=r4%+PSICPPmPF/=!(PPmP#
%w7(#
(eA!}]DtT:
zXk(}(eC(tT,dC Netezza connector A!}]1Zw5PDYw==#
*<.0
zXk* Netezza connector dC;v}]b,S(w*4)#
}L
1. Zw5hF-<O,+w Netezza connector <j#
2. %wdv!n(,;s!q*`-Ddv4S#
3. %wtT!n(#
4. ZtT!n(D9Civ?V,8(,SwZw5PgNKP#
a. ZzI SQL VNP8(Gq*ZKP1zI SQL od#
b. ZmVN,8(k*A!Dm#
c. ZtCS}EDj6VNP,8(GI#t DDL M DML odPyPTs{F
Ds!4# 1!5*q#
d. Z Before/After SQL odVN,8(GqZ}]&m.0/.sKP SQL o
d#
5. %w7(T#fywD|D#
Vx}]Tc Netezza connector "PA!}]:
zXk+ Netezza connector dC*4P"PA!;1!ivB,,Sw43rKP#
"PA!8+}].V*}]S/s,(};,D&mZc,1A!}]#Netezza con-
nector 'V#}Vx#(}#}Vx,akTXb Netezza P datasliceid +#}mo=mS= WHERE Sd,TZ&mZc.dV<P#PXVxdCM_-ZcD|`E
",kND6"Pw5*"_8O7#
34 Netezza Performance Server ,S8O
XZKNq
}L
1. Zw5hF-<O,+w Netezza connector <j#
2. S4SB-PmP!q}C4S(vJC#fiR),;s+iR`M!*#f;
r_!qk*dC*"PA!Ddv4S#
3. +tCVxA!hC*G#
4. %w7(#
a{
KPKw51,SELECT odPD WHERE Sd^D*5XI?v&mZcA!DP
S/#
>}
g{P 4 v&mZc,?v&mZcP<P SELECT od,G4aT>gBZ]:
SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=0SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=1SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=2SELECT col1, col2 FROM table WHERE mod(datasliceid,4)=3
g{z9CC'(eD SQL,"R,SwT"P==A!,G4zPpN7#J1DV
x#*K(zb;}L,,Sw(eK=v<;{TZKP1C5J5f;:
<;{ hv 3rKP1D5
[[node-count]] &mZcD\}#C<;{m>
Netezza connector WND"PT6p,
d5HZ&mZc}#
1
[[node-number]] 10&mZcDSc*<Dw}#}
g,P 4 v&mZc,&mZcw}
* 0"1"2"3#
0
zIT9C<;{ZzD SQL odP4(VxSd#}g:
SELECT * FROM table WHERE mod(datasliceid,[[node-count]])=[[node-number]]
[[node-count]] f;*&mZc\},[[node-number]] f;*10&mZcDSc*<
Dw}#
":datasliceid PGX(Z?vmDXb Netezza P,|;aT/|(ZS<P,g
{h*D0,Xkw7XmS=S<i/D!qPmP#
dC#fiRYw:
}]bWNA!D}]ITw* Lookup WND}C}]#1!ivB,+C}C}]
qd{}C4S;y0kZfP#14P#fiRYw1,Netezza connector lwyP
G<,"Jm Lookup WN&mG<#
*<.0
zXkWH4(;viRYww5#9XkZ Lookup WNDdkMdvWNP(eP#
Z 3 B Netezza connector 35
}L
1. +w Netezza Connector WNTr*4StT0Z#
2. SiR`MB-PmP,!q#f#
3. %wP!n(,"(ek*Sk,Sw,SD}]b9CDP#
4. dCtT!n(ODtT#
a. (e"bT,S?VD,StT#
b. ZC(?V,zIT8(G9CT/zID SQL od9GC'(eD SQL o
d#+zI SQL 8(*Grq#
v g{+zI SQL8(*G,rh*8(m{F,;sZ Lookup WN!qP
!n(PD|P#*8(|P,I+yhDPSw4SO/=}C4S#k
!hiRYwPlwDG<`4,KdCb6Ealwm`G<#
v g{+zI SQL8(*q,rh*Z Lookup WN!qP!n(PD|P#
*8(|P,I+yhDPSw4SO/=}C4S#8(!qodtT#
Z!qodtTPdkTBq=D SELECT od:select * from
table_name#k!hiRYwPlwDG<`4,KdCb6Ealwm`
G<#
c. I!: dCtT!n(ODNNd{tT#
5. %w7(I#f|D#
6. *+dk4S3d=dv4S,IT+w Lookup WNTr*WN`-w#
a. +dk4SPDPO/r4F=dv4SP,T+PmS=dv4S
b. (}%wK%PD<x<j,(eiR'\DNNu~#
c. *iR'\P!qOJD5,"%w7(#g{!q\x,rw5dCPXk
|,\x4SM?jWN,T6qb)G<#
7. %w7(#
8. #f"`k"KPCw5#
dC!hiRYw:
}]bWNA!D}]ITw* Lookup WND}C}]#1!ivB,+C}C}]
qd{}C4S;y0kZfP#g{+ Netezza connector dC*1Sw*}C4S
,S= Lookup WN,zIT+ Netezza connector D iR`MtTdC*“!h”,"
kTiRmP?v+kDPr}]b"Mvp SQL od#
*<.0
zXk4(;viRYww5#
XZKNq
g{;vWNDdkP}?66!Z}]bmPD}CP}?(1:100 rTO),zI
T+ Netezza connector dC*4P!hiRYw,"kTiRmP?v+kDPr}
]b"Mvp SQL od#ZiRYww5P,,SwSUdkWNDG<,;s,S
w1STb?J44PiRYw#;s,,Sw+zIdvG<#
;PZ"Pw5PIT9C!hiR=(#
36 Netezza Performance Server ,S8O
}L
1. +w Netezza Connector WNTr*4StT0Z#
2. !qiR`MB-Pm,!q!h#
3. %wP!n(,"(ek*Sk,Sw,SD}]b9CDP#
4. dCtT!n(ODtT#
a. (e"bT,S?VD,StT#
b. ZC(?V,zIT8(G9CT/zID SQL od9GC'(eD SQL o
d#+zI SQL 8(*Grq#
v g{+zI SQL8(*G,rh*8(m{FMP!n(PD|Pj8E"#
v g{+zI SQL8(*q,rh*8(!qodtT#Z SELECT odD
select ?V,Pvz#{5X=w5DP#(#CPmaMP!n(PDP%
d#g{CPmkP;%d,G4zh*Zdk3fDtT!n(P!qJ
1D #=-wtT,T5VZ{DP*#TBo(G SELECT odDZ;?
V>}:select Field001,Field002,Field003#
c. ZtT!n(P8(m{F,;s8( WHERE SdT4PiR#WHERE Sd
sfD|PXk|,%J ORCHESTRATE,xRP{F*7XkmS;vdc#
ORCHESTRATE ITGs4r!4V8,}g:ORCHESTRATE.Field001# TB
S E L E C T odG W H E R E SdD;v}7o(>}: s e l e c t
Field001,Field002,Field003 from MY_TABLE where ORCHESTRATE.Field001 =
Field001#X|J ORCHESTRATE .sDP{F&Ck“P”!n(PDP{F
%d#g{CPmkP;%d,G4zh*Zdk3fDtT!n(P!qJ
1D #=-wtT,T5VZ{DP*#
d. I!: dCtT!n(ODNNd{tT#
5. %w7(I#f|D#
6. *+dk4S3d=dv4S,IT+w Lookup WNTr*WN`-w#
a. +dk4SPDPO/r4F=dv4SP,T+PmS=dv4S
b. (}%wK%PD<x<j,(eiR'\DNNu~#
c. *iR'\P!qOJD5,"%w7(#g{!q\x,rw5dCPXk
|,\x4SM?jWN,T6qb)G<#
7. %w7(#
8. #f"`k"KPCw5#
4k}]
*9C Netezza connector +}]4k Netezza m,zh*+ Netezza connector dC
*+}]w*?j4&m#Netezza connector KP SQL od",Sb? Netezza }]
4,,1y]*sek"|Br>}}]#
B<T>9C Netezza connector 4k}]D>}#ZKivB,Sequential File WNA
! Sequential_File_1 D~PD}],;s Netezza C
onnector WNy]h*T Netezza }]bD}]4Pek"|Br>}Yw#
Z 3 B Netezza connector 37
+ Netezza connector dC*?j:
(}+ Netezza connector dC*+}]w*?j4&m,zIT9C Netezza connec-
tor WN4k}]#
}L
1. Zw5hF-<O,+w Netezza Connector WN<j#
2. %wdk!n(,;s!q*`-Ddk4S# (}`-dk4S,+ Netezza Con-
nector WNdC*?j#
3. !qtT!n(#
4. Z,S?V,8((",Sh*9CD}]4"}]b"C'{M\k#
5. 8( TWT 9C%@,S,TmwGqk*9C%@,S"Z%@D}]bP|,Y1$wm (TWT) Mb?m (ET)#
6. %w#fT#f8(D,ShC#
hCP(e:
zIT9C`FD=(*AYwM4YwhCP(e#9IT(FPxq"#fP(
eT8sC,T0Sf"b0kQ$(eDP(e#
}L
1. Zw5hF-<O,+w Netezza connector <j#
2. ZWN`-wP,!qdv!n(rdk!n(#
3. ZP!n(O,^DPxqT8(*(eD*}]#
a. ZxqZR|%w,"SK%P!qtT#
b. Z“xqtT”0ZP,!qk*T>DtTT0tTDT>3r#;s,%w
7(#
4. 9CTB=(.;4dkmDP(e:
< 2. 4k}]>}
38 Netezza Performance Server ,S8O
!n hv
=( 1 1. ZP{FPPD`&%*qZ+w,"d
kP{F#
2. TZPPD?v%*q,Z%*qZ+w
"!qyh!n#
3. ZhvPPD`&%*qZ+w,"dk
hv#
=( 2 1. Z%*qZR|%w,;sSK%P!q
"4`-#
2. Z“`-P*}]”0ZP,dkP*}]#
5. *Z`vP.d2m*}],k!q*2m*}]DwP#
a. R|%w"!q+%5#
b. Z“+%P5”0ZP,!qzk*!(DP2mDtT#
6. *Zf"bP+P(e#f*m(e,k%w#f#
a. Z“#fm(e”0ZPdkJ1DE",;s%w7(#
b. Z“+m(emf*”0ZP,!qzk*CZ#fm(eDD~P,;s%w
#f#
7. *Sf"b0kP(e,%w0k#
a. Z“m(e”0ZP,!qzk*0kDm(e,;s%w7(#
b. Z“!qP”0ZP,9C=r4%+PSICPPmPF/=!(PPmP#
%w7(#
dCX4P&m:
Netezza connector (}}Kdk}]PDX4P";ek?jmP;fZDP4&mX
4P#zITdC,Sw4liX4P#,Sw9CnbD SQL _-4lbX4P#
XZKNq
,Sw4|5TPxPVi,"y] ROWID PD5TdEr#n|mSDP_POs
ROWID 5#1EPK?v|iOPDPTs,,Swa!qdP;viO"}Ktd
`iO#19C(;|PhC*G1,,Swa9C8(PTzf ROWID#
}L
1. +w Connector WN<jTr*,SwtT#
2. !qdk!n(#
3. !qtT!n(#
4. 8(4k==!n#
5. +liX4P!nhC*G#
6. +X4PYw!nhC*}K# ,Sw;*?v|iO#t;P"}Ktd`P#
1C!nhC*'\1,g{lb=NNX4P,G4w5'\#
Z 3 B Netezza connector 39
a{
Bmc\KtCX4P&m1;,4k==BD,SwP*:
4k== P*
ek !q?v|iODZ;P,vTd`P#g{
?jmP;P|,G4+eky!P#qr,
;I!Yw#
|B !q?v|iODns;P,vTd`P#g
{?jmPfZ%dP,G4+9Cy!P|
B?jm#qr,;I!Yw#
>} P*4Dd#+>}yP%dP#
|B;sek |B:!q?v|iODns;P,vT
d`P#g{?jmPfZ%dP,G4
+9Cy!P|B?jm#qr,;I!
Yw#
ek:!q?v|iODns;P,vT
d`P#g{?jmP;P|,G4+e
ky!P#qr,;I!Yw#
>};sek >}:P*4Dd#+>}yP%dP#
ek:!q?v|iODns;P,vT
d`P#+y!Pek?jm#
YwP y]YwPD5Md{rX,+dkPpVI
iTZ;, SQL odP4P#byM\7#a
{kTnuD+k3r?N&C;P1C=D
a{`,#
dCG<Er:
1!ivB,Netezza connector ;4w73rr?jmekG<#zITtCG<Er
tT8(;vr`v3rP#
XZKNq
G<Er!nICZek"|Bsek">}sekMYwP4k==#tCG<&
m!ns,G<ZS TWT ek=?jm0axPEr#
}L
1. +w Connector WN<jTr*,SwtT#
2. !qdk!n(#
3. !qtT!n(#
4. 8(4k==!n#
5. g{!qKek4k==,G4+1Sek!nhC*q#
6. +tCG<Er!nhC*G#
7. !qP{FtT,;s%w!qP4%T8(Z;v3r|PD{F# Z;v|t
TaT/tC"RGXhD#
8. SPmP!qz*DP#
40 Netezza Performance Server ,S8O
":zXkAY(e4SOD;vPT9C!nz'
9. I!: R|%w|[1],!qmStT5,;smSd{|P#
10. R|%w|[n]tT(dP,n 8*>}D|Dw},;s!q}%tT5T>}
|#
(e4k}]DtT:
zXkdC4k}]1 Netezza connector Zw5PDYw==#
*<.0
zXk* Netezza connector dC;v}]b,S(w*?j)#
}L
1. Zw5hF-<O,+w Netezza connector <j#
2. %wdk!n(,;s!q*`-Ddk4S#
3. %wtT!n(#
4. ZtT!n(D9Civ?V,8(,SwZw5PgNKP#
a. 8(4k==#
b. Zm{FVNP,8(CZ4k}]D SQL odP9CD?jmD{F# Kt
TGXhtT#zIT9C4(rf;mYwZKP14(m#m{CZzI
}](eoT(DDL)od#zXk+KP1zI4(/>}/XOodtT8(*G,TZKP1zI DDL od#zXk+KP1zI4(/>}/XOodtT8(*q,T9CC'(eD DDL od#
c. ZzI SQL VNP8(Gq*ZKP1zI SQL od#
d. ZtCS}EDj6VNP,8(GI#t DDL M DML odPyPTs{F
Ds!4# 1!5*q#
e. Z SQL VNP,8(OJD SQL od#
f. ZmYwVNP,8(mD4(==,rZVP?jmP`-rekPD=
=#
g. Z Before/After SQL odVN,8(GqZ}]&m.0/.sKP SQL o
d#
5. %w7(#
*4YwxP}]Vx:
zITZ+}]4k Netezza }]b.0,8(VxrU/+k}]D==#z9IT
8(4k}].0&T}]xPEr#
*<.0
VxrU/`MDICT!vZz+ Netezza connector w5hF*"PKP==9G
3rKP==#
v g{+ Netezza Connector WNhC*"PKP==,rVx`MPmIC#g{S
CPmP!q3V=(,G4C=(+2GNN10Vx=(#
v g{+ Netezza Connector WNhC*3rKP==R0;vWNhC*"PKP=
=,rU/`MPmIC#
Z 3 B Netezza connector 41
}L
1. Zw5hF-<O,+w Netezza connector <j#
2. ZWN`-wDsOG,!q*`-Ddk4S#
3. %wVx!n(#
4. SVx`M/U/`MPmP!qVx`M#!qk*4k}]DVxrU/=(`
M#%wVx`MPmT_DtT<j,T8(yhD}]b"5}Mm#
5. %w7(#
9C%@}]bPDY1$wm4P|BekYw:
Netezza connector 'VZm;v}]bP|,Y1$wm (TWT) D&\#*4PNN
|BekYw,Netezza connector Z4P SQL od.0,9CY1$wm (TWT) U
/dk}]#
g{Z%@D}]bPEkY1$wm,rIT=c,$MUd\m#Netezza P;v^
F,4;\|Dm;v}]bPDm,rK19Cb?m1,,Sw9C%@D,S
4kY1$wm#g{+dk,StT TWT 9C%@,S8(*G"dCN},rC&\;$n#g{tC,,Sw+("m;v,S,"9CC,S4r TWT 4k}
]#
|BekYw
*4PNN|BekYw(|B">}"ek;s|B"|B;sekr>};se
k),,SwZ4P SQL od.0,9CY1$wm (TWT) U/dk}]#Xp1
`v&mZcq!}]1,9C TWT IT7#|BekodC=I$bDa{#B<
5w|BekYw:
,Swr;v_LPD\@4kdk}](|MNN|BP),"Zm;v_LP4
P INSERT od(= TWT P),}g:
INSERT INTO TemporaryWorkTable SELECT * FROM ExternalTable
���� ���
���
Netezza ��
��� 2
Netezza Connector
��� 1
���
SQL ��
�����
����
�� INSERT
�� UPSERT
���
< 3. upsert Yw
42 Netezza Performance Server ,S8O
,Sw*?v&mZc4(;v|{\@M;vb?m#&mZcD}?I APT dC
D~P(eD_-Zc}?v(#;s,Swr*|{\@"*<Zm;v_LP4
P INSERT od(1=&mjyP}]*9)#;\&mZcP`Y,,Sw<4(;
v TWT#;s,Sw+dk}]4k\@P#g{;fZdk}],r,Sw+XU\
@,SxjI INSERT odD4P,x,Swa;Bq#1yP&mZc<ek= TWT
Ps,,SwS4PwxL4P|Bekod#
9C}C4SiR}]
zIT(}+ Netezza Connector WN4S= Lookup WND}C4S,9C IBM
Netezza connector 1SiR Netezza mPD}]# Lookup WNG;v&mWN#CZ
iRSd{ITdv}]D"Pw5WNA!=ZfPD Dataset#zIT8(?v}C
4SDu~,TcZzcu~1WNvTC}C4S4PiRYw#
XZKNq
}C4Sm>miRYw#zIT+}C4Sw* Lookup WNDdk4SMd{`M
WN(}g Netezza Connector WN)Ddv4S49C#
}L
1. Zw5hF-<O,+ Netezza connector <jM Lookup WN<jO=w5hF-<O# (Lookup WN;Z!CeK%D&m`pB#)
2. (}+4SS Netezza Connector WNO/= Lookup WN,,Sb=vWN#
3. R|%wC4S,"SK%P!q*;*}C# _d*i_,Tm>K4SG;v
}C4S#
4. (}+w Netezza connector <j,r* Netezza Connector WN`-w#
5. ZWN`-wP,(eWND}]b,SE",;s(e}C4SDAYw# jI
1,%w7(#
6. +iR`M!*#fr!h#
7. (}+w Lookup WN<jTr* Lookup WN`-w#
8. (e Lookup WNDiRYw# `-ws0qT>dk4S,R0qT>dv4
S#b)0qBfT>Kb)4SD*}]#TZ4Tw4SD4 Dataset D?uG
<,Lookup WNTC}C4S,SD?viRm4PmiRYw#miRyZ;i
iR|PD5(?vm;i)#
9. %w7(#
hF1Z,SwPzI SQL odzIT+,SwdC*ZhF1* SQL odtTzI SQL odD>#
*<.0
4(+,Sww*4r?j|,Dw5#
XZKNq
zvI*Z“9(”PmP_PzI SQL od!nDodtTzI SQL odD>#
":Z3)ivB,,Swh*;v,S4zI SQL od#4a)C'{M\kRh
*,S1,I}ZKP ASB zmLr~qDC'(",S#
Z 3 B Netezza connector 43
}L
1. +ww5-<OD,SwTr*WN`-w#
2. Z<=wP,%wdvrdk4S,_e!vZzy4(Dw5`M#
3. +KP1zI SQL hC*q#
4. Zm{FtTP* SQL oddkm{F#
5. kT?jOBDPDw5(dk4S),!qz*Z4==tTPzIDod`
M#
6. ZP3fO,(e*Z SQL odP9CDP#
7. %wtT!n(#
8. %wkodtTX*D9(4%,"SPmP!qzI SQL od#
":zI SQL od!nvICZC,Sw'VZhF1zIDod#Z3)ivB,
,SwvI'VZKP1Dw54PZdzI SQL#
9. %w7(T#fw5#
ZhF1i$,SwPD SQL odzIr`4 SQL ods,ITZw5hFZdi$Kod#
XZKNq
zvI*Z“9(”PmP_P“i$ SQL”!nDodtTi$ SQL odD>#
":Z3)ivB,,Swh*;v,S4i$ SQL od#4a)C'{M\kRh
*,S1,I}ZKP ASB zmLr~qDC'(",S#
}L
1. #fw5#
2. %wkodtTX*D9(4%,"!qi$ SQL#v1odtT|,51,EatC“i$ SQL”!n,"RK!nvICZ?j RDBMS 'Vi$Dod#
a{
,Sw(}9Cd'VD RDBMS $`k SQL od4i$Kod#g{ SQL |,m
s,G4aT>ms{"#
}]`M*;
IBM InfoSphere DataStage 'V;i;,Z Netezza SQL }]`MD SQL }]`M#
(} Netezza connector <k*}]r9C Netezza connector A!}]1,Netezza Con-
nector WN+ Netezza }]`M*;* InfoSphere DataStage }]`M#`4,1(}
Netezza connector +}]4k ?j Netezza m1,InfoSphere DataStage }]`M+*
;* Netezza }]`M#
}]`MS Netezza *;* DataStage:
A!}]1,Netezza Connector WN+ Netezza }]`M*;* InfoSphere DataStage
}]`M#
44 Netezza Performance Server ,S8O
,y,(} Netezza connector <k*}]s,Netezza }]`M2+*;* IBM
InfoSphere DataStage }]`M#BmT> Netezza }]`MM InfoSphere DataStage }
]`M.dD3dfr#
m 10. Netezza }]`M0dT&D InfoSphere DataStage }]`M
Netezza }]`M InfoSphere DataStage }]`M(SQL `M)
BYTEINT TinyInt
SMALLINT SmallInt
INT Integer
BIGINT BigInt
NUMERIC(p, s) Numeric
FLOAT(p) Float
REAL Real
DOUBLE PRECISION Double
CHAR(n) Char
VARCHAR(n) VarChar
NCHAR(n) NChar
NVARCHAR(n) NVarChar
BOOLEAN Bit
DATE Date
TIME Time
TIME WITH TIME ZONE
":5X;x1xE"D TIME WITH TIME
ZONE 5#
VarChar
TIMESTAMP TimeStamp
INTERVAL
":^(Sb?m0k INTERVAL }]`M#
VarChar
ROWID BigInt
TRANSACTION ID BigInt
DATASLICE Integer
(}Z*}]<kZd!q+ XML Pw* LOB !n,IT+ XML }]`M<k*
LOB#XML PITm>*NNV{."ustring r LOB }]`M#
}]`MS DataStage *;* Netezza:
Z4k}]1,Netezza Connector WNa+ InfoSphere DataStage }]`M*;*
Netezza }]`M#
Z;)ivB,;\<7X5VS InfoSphere DataStage }]`M= Netezza }]`M
D*;#
BmT> InfoSphere DataStage }]`MM Netezza }]`M.dD3dfr#
Z 3 B Netezza connector 45
m 11. InfoSphere DataStage }]`M0dT&D Netezza }]`M
InfoSphere DataStage }]`M(SQL `M) Netezza }]`M
Bit BOOLEAN r BOOL
Char CHAR(64000)"CHAR(n)"NCHAR(16000)
"NCHAR(n)
VarChar V A R C H A R ( 6 4 0 0 0 ) " V A R C H A R ( n )
"NVARCHAR(16000)"NVARCHAR(n)
LongVarChar V A R C H A R ( 6 4 0 0 0 ) " V A R C H A R ( n )
"NVARCHAR(16000)"NVARCHAR(n)
NChar NCHAR(16000)"NCHAR(n)
NVarChar NVARCHAR(16000)"NVARCHAR(n)
LongNVarChar NVARCHAR(16000)"NVARCHAR(n)
Binary ;\'V
VarBinary ;\'V
LongVarBinary ;\'V
Decimal NUMERIC(p)"NUMERIC(p, s)
Double DOUBLE PRECISION r FLOAT(15)
Float REAL r FLOAT(6)"FLOAT(p)
Real REAL r FLOAT(6)
TinyInt BYTEINT
SmallInt SMALLINT
Integer INT
BigInt BIGINT
Numeric NUMBER(38,0)"NUMBER(p, 0)"NUMBER
(38, s)"NUMBER(p, s)
Date DATE
Time TIME(<U|("k)
Timestamp TIMESTAMP(<U|("k)
Unknown VARCHAR(64000)
`k"KP Netezza connector w5+ Netezza connector w5`kIIwH"KPDI4PE>#
}L
1. Z InfoSphere DataStage and QualityStage Designer M'zO,r*k*`kDw5#
2. %w`k4%#
3. g{“`k4,”xrT>ms,k`-Cw5Tbvms#bvmss,%wXB
`k4%#
4. g{w5`kI&,r%wKP4%,"8(w5KP!n:
a. y]h*dkw5N}#
b. %wi$4%i$w5Gq+I&KP,K}L5JO;aT}]xPi!"
*;r4Yw#
c. %wKP4%T}]xPi!"*;r4Yw#
46 Netezza Performance Server ,S8O
5. *i4i$rKPw5Da{:
a. Z Designer M'zP,!q$_ > KP8>wr* Director M'z#
b. Z“4,”PP,i$w5GqQ(}i$rI&jI#
c. g{w5ri$'\,k!qi4 > U>T7(NNKP1Jb#
6. g{w5fZKP1Jb,k^}Jb"XB`k"i$(I!),;sKPw
5,1=w5I&jI#
JOoO
9C Netezza connector }LP,zI\av=;)ms,(}JOoOMw{tTr
dCD5IhT^}#
,Sms
zI\av=TB,Sms:
m 12. ,Sms
ms`M msj8E" JOoOj8E"
^(0k ODBC
}/Lr
KP Netezza connector DataStage w5
r*}]<kr<r_4Pi4}]
1,zI\av=TBms:9C DSN
NZSQL T testuser C'm],S=}
]b t e s t d b '\#-r:
[ S Q L C O D E = I M 0 0 3 ] [ N a t i v e = 0 ]
[DataDirect][ODBC lib] ^(0k8
(D}/Lr
ms-rI\gB:
v Z Windows 64 ;O20K 64 ;
f>D Netezza }/Lr#b;\
KP,r* Information Server G
Windows OD 32 ;&CLr#
v Z Unix O4}7hCbQw76#
TZ Windows 64 ;53PDms:
1. 7# 32 ;M 64 ;}/Lr<Q
20#
2. 7#9C 32 ;f>D}]4
(ODBC) (eK DSN#32 ;f>
D O d b c a d 3 2 . e x e D~;Z
%systemdrive%\Windows\SysWoW64
D~PP#*Kb Windows 64 ;
OD DSN `XJbD|`j8E
",kNDTBDB: h t t p : / /
support.microsoft.com/kb/942976
TZ U n i x 53ODms,k+
Netezza ODBC }/Lr?< (<nz-
odbc-home>/lib64) |(Z76Qw7
3d?P#
Z AIX 53O,g{}7hCbQw
76sT;"zms,G4zXk*
= Netezza ODBC }/Lr?<
(<nz-odbc-home>/lib64) B"4(T
B{E4S(y]zDhC,I\h
* root C'X():
cd <nz-odbc-home>/lib64ln -s libnzodbc.a libnzodbc.so
Z 3 B Netezza connector 47
m 12. ,Sms (x)
ms`M msj8E" JOoOj8E"
}]4{F
(DSN) ;}7
KP Netezza connector DataStage w5
r*}]<kr<r_4Pi4}]
1,zI\av=TBms:9C DSN
NZSQL T testuser C'm],S=}
]b t e s t d b '\#-r:
[ S Q L C O D E = I M 0 0 2 ] [ N a t i v e = 0 ]
[DataDirect][ODBC lib] }]4{F
R;="R48(1!}/Lr
Z U n i x 53O,g{
NZ_ODBC_INI_PATH 4}7hC,z
I\av=TBms:9C DSN NZSQL
T testuser C'm],S=}]b
t e s t d b '\#-r:
[SQLCODE=HY000][Native=33] ~qw
M/rKZtT*U
TZ Windows 53ODms,kt/
}]4 (ODBC) "li DSN {F#
TZ MDI Mi4}],kliCZK
P ASBAgent ~qDJ'#g{
ASBAgent ~qZ53J'BKP,G
4 DSN {FXk(e*53 DSN#
qr,53 DSN MC' DSN <IT
9C#InfoSphere DataStage w5IT
CJ53 DSN MC' DSN#
TZ Unix 53ODms,zXk7#
DSN s!4%d#mk7# ODBCINI
M NZ_ODBC_INI_PATH 73d?hC
}7#ODBCINI Xk8r}7D
odbc.ini D~;NZ_ODBC_INI_PATH
XkhC*}7D odbc.ini D~yZ
D?<#
C'{ /\kJ
b
KP Netezza connector DataStage w5
r*}]<kr<r_4Pi4}]
1,zI\av=TBms:9C DSN
NZSQL T testuser C'm],S=}
]b t e s t d b '\#-r:
[SQLCODE=28000][Native=24]
“testuser1”C'D\kO$'\
ki$Zw5/MDI r<PGq}7d
kC'{/\kiO#mk7#8(D
C'_P,S=y!}]bD}7(
^#
@p=Jb g{ Netezza ~qw&Z@p=D#$
B"RZzKP Netezza connector w
5r*}]<kr<r_4Pi4}
].04xPO$,G4zI\av
=TBms#9C DSN NZSQL T
testuser C'm],S=}]b
t e s t d b '\#-r:
[ S Q L C O D E = H Y 0 0 0 ] [ N a t i v e = 0 ]
[DataDirect][ODBC lib] Unicode *
;wXOV{
ZKP Netezza connector w5r*}
]<kr<r_4Pi4}].0r
@p=O$#
48 Netezza Performance Server ,S8O
KP1ms
Netezza connector I&,S= Netezza ~qws,zI\av=TBms:
m 13. KP1ms
ms`M msj8E" JOoOj8E"
#=-wJb 1. nbD4SP
KP Netezza connector w51,z
I\av=TBms:test_table
mPR;=TBdk4SP:col2
2. nbDmP
KP Netezza connector w51,z
I\av=TBms:dk4S#
=PR;=TBP:4T
test_table mD COL2
1w5}C?jmrY1$wmP;
fZDP1,a"znbD4SPm
s#zXk7#zDw5Mm_P`
,DP,r_IT(}+,Swt
T:#=-w → ;%dD4SPYw
hC*>},+,SwdC*>}n
bP#
1?jmrY1$wPD;vr`v
PZ4S#=PR;=1,a"zn
bmPms#zXk7#zDw5M
m_P`,DP,r_IT(}+,
SwtT:#=-w → ;%dDmP
YwhC*vTIUrvTyP,8
>,SwvTnbP#g{nbP;
I*Ur;_P1!5,G4w5T
PI\'\#
Y1$wm
(TWT) ;Z%
@}]bP
Z%@}]bP9CVPY1$wm
1,Netezza connector w5I\'\,
msgB:
R;= twttable m
zXk7#8(K}7D TWT {F,
g{x(j<{F,G4{FDyP
?V<}7#mk7#,SwtTk
T TWT 9C%@,ShC*G,"RStThC*}75#
Z 3 B Netezza connector 49
50 Netezza Performance Server ,S8O
Z 4 B 73d?:Netezza Connector
Netezza Connector WN9CTB73d?#
CC_GUARDIUM_EVENTShCC73d?T8(,SwGq+ InfoSphere DataStage OBDE"(fx InfoSphere
Guardium Database Activity Monitor#
1C73d?D5QhC1,,Swa+ InfoSphere DataStage OBDE"(}g,}
ZKPWNDwz"n?"w5{"WN{MZcj6)(fx InfoSphere Guardium
Database Activity Monitor#1C73d?Q(e"RhC*NN51,Z("u<,S
.s,,Swa+OBDE"(fx Guardium ~qw#
1C73d?4(e1,,Sw;a"T+OBDE"(fx Guardium ~qw#C7
3d?DhCJCZw5PDyP}]b,Sw#
CC_IGNORE_TIME_LENGTH_AND_SCALEhCC73d?T|D"P-<O,SwDP*#
1C73d?hC* 1 1,T"P}fKPD,SwavT1dAGP8(D$HM!
};#}g,1C73d?D54hC1,"Rg{1dAGPD$H* 26,!};*
6,G4"P-<OD,Swa+1dAGS*"kVfJ#1C73d?D5hC* 1
1,}G49Z1dAGPD$H* 26 R!};* 6 DivBT;hCK"k)9t
T,qr"P-<OD,Sw;a+1dAGSw*_P"kVfJ#
CC_MSG_LEVELhCC73d?T8(,SwZU>D~P(fD{"DnMOXT#
9C1!5 3 1,N<{"M|_OXTD{"a(fAU>D~#
TBPm|,P'D5:
v 1 - zY
v 2 - wT
v 3 - N<
v 4 - /f
v 5 - ms
v 6 - B|
CC_NZ_LOG_LEVELhCC73d?T8(,SwZU>D~P(fD{"DnMOXT#
© Copyright IBM Corp. 2005, 2014 51
9C1!5 3 1,N<{"M|_OXTD{"a(fAU>D~#TBPm|,P'
D5:
v 1 - zY
v 2 - wT
v 3 - N<
v 4 - /f
v 5 - ms
v 6 - B|
C73d?k CC_MSG_LEVEL 73d?`,,+G|v0l Netezza Connector {"#
CC_TRUNCATE_STRING_WITH_NULLhCC73d?TXO|,V{. 0x00 DV{.}]#
1C73d?D5QhC,"Rdk}]|,UV{1,aT 0x00 XOdk}],"
*zd`V{.#K73d?JCZ Char"VarChar M LongVarChar InfoSphere
DataStage `MDVN#
CC_TRUNCATE_NSTRING_WITH_NULLhCC73d?TXO|,V{. 0x00 DV{.}]#
1C73d?D5QhC,"Rdk}]|,UV{1,aT 0x00 XOdk}],"
*zd`V{.#
CC_USE_EXTERNAL_SCHEMA_ON_MISMATCH1#=;%d1,hCC73d?T9Cb?#=,x;G9ChF#=#
C#=CZ#=-w#1C73d?D5QhC1,P*#V;d,"R;aSIf
>|DP*#
TMPDIRhCC73d?T8(?<,Tc Netezza Connector ZdP4(8(D\@Tk Linux
r UNIX Yw53OD Netezza xP(E#
Cd?98(yPYw53O Netezza U>D~D?<#
52 Netezza Performance Server ,S8O
=< A. z7(z&\!n
zITq!PX IBM z7D(z&\!n4,DE"#
IBM InfoSphere Information Server z7#iMC'gf";j+'V(z&\!n#
PX IBM z7D(z&\!n4,DE",kND;ZTBx7D IBM z7(z&
\!nE":http://www.ibm.com/able/product_accessibility/index.html#
ICJD5
IBM Knowledge Center a)KkTz7D_P(z&\!nDD5#IBM Knowledge
Center Ts`} Web /@wPIi4D XHTML 1.0 q=JVCD5#IZ IBM
Knowledge Center 9C XHTML,rKzIZ/@wPhCT>W!n#b9Jmz9
CA;JAwMd{(z<uCJD5#
9T PDF D~N=a)K IBM Knowledge Center ZDD5,xb) PDF D~";
_8j{D(z&\!n#
IBM M(z&\!n
kND IBM Human Ability and Accessibility Center,Tq!PX IBM T(z&\!
nDP5D|`E"#
© Copyright IBM Corp. 2005, 2014 53
54 Netezza Performance Server ,S8O
=< B. A.|nPo(
>D59CXbV{4(e|nPo(#
TBXbV{(eK|nPo(:
[ ] j6I!Td?#4T=(E(pDTd?GXhD#
... 8>zIT*0fDTd?8(`v5#
| 8>%bE"#zIT9CVt{s`rR`DTd?#z;\Z%v|nP
,19Cb=vTd?#
{ } 1h*;i%bTd?PD3;vTd?1,Tbi%bTd?xP(g#g
{Td?I!,G4T=(E ([ ]) +b)Td?(p#
":
v ;vTd?PDnsV{}G 256 v#
v T%}Er+}E(p_P6kUqDTd?5#
}g:
wsetsrc[-S server] [-l label] [-n name] source
source Td?G wsetsrc |nyhD(;Td?#x=(EDd{Td?mwb)T
d?I!#
wlsac [-l | -f format] [key... ] profile
ZK>}P,-l M -f q=Td?%bRI!#profile Td?GXhD#key Td?I
!#zZ key Td?sD!TE (...) m>IT8(`v|{F#
wrb -import {rule_pack | rule_set}...
ZK>}P,rule_pack M rule_set Td?%b,+GXk8(dP;vTd?#mb,
!TE (...) m>IT8(`vfr|rfr/#
© Copyright IBM Corp. 2005, 2014 55
56 Netezza Performance Server ,S8O
=< C. gNA.o(<
TBfrJCZKE"P9CDo(<:
v Ss=R"SO=BXPD76A!o(<#9CTB<(:
– >>--- {Emwo(<*<#
– ---> {Emwo(<ZB;PLx#
– >--- {Emwo(<SO;P#
– --->< {Emwo(<ax#
v XhnT>Z.=P(w76)O#
�� required_item ��
v I!nT>Zw76B=#
�� required_itemoptional_item
��
g{I!nT>Zw76O=,G4Cn;0lo(*XD4P,vCZIAT#
��optional_item
required_item ��
v g{ITS=nr|`nPxP!q,G4b)na91T>ZQ;P#
g{Xk!qdP;vn,G4Q;D3vnaT>Zw76O#
�� required_item required_choice1required_choice2
��
g{!q3vnGI!D,G4{vQ;aT>Zw76B=#
�� required_itemoptional_choice1optional_choice2
��
g{3vnG1!n,G4|aT>Zw76O=,d`!naT>Zw76B
=#
��default_choice
required_itemoptional_choice1optional_choice2
��
v ZwPO=5XAs`D}7mwIX4Dn#
© Copyright IBM Corp. 2005, 2014 57
�� required_item � repeatable_item ��
g{X4}7|,:E,G4XkT:E4VtX4n#
�� required_item �
,
repeatable_item ��
;ZQ;O=DX4}7mwITX4Q;PDn#
v P1,Xk+;E<pVI,N#o(,Nkwo(<V*T>,+G&+b),
NZ]Sw;Z<Dw76O4A!#
�� required_item fragment-name ��
Fragment-name:
required_itemoptional_item
v X|V0dnLu4(g{JC)Ts4T>#d44XkkT>Dj+;B#
v d?+?T>*!41eV8(}g,column-name)#m>C'a)D{Fr5#
v g{Z<PDwX|V0N}.d4T>NNjc{E,G4&AYT;vUq4
Vtb)X|VMN}#
v j+4<Py>,dkjc{E"(E"cuKc{Md{{E#
v E"Tx(ED}VN=T>,}g (1)#
58 Netezza Performance Server ,S8O
=< D. *5 IBM
zIT*5 IBM q!M''V"m~~q"z7E"M#fE"#2ITr IBM a
)Tz7MD5D4!#
BmPvKM''V"m~~q"`5T0z7Mbv=8E"DJ4#
m 14. IBM J4
J4 hvM;C
IBM Support Portal zIZTBX7!qPK$Dz7Mwb4(
F'VE":www.ibm.com/support/entry/portal/
S o f t w a r e / I n f o r m a t i o n _ M a n a g e m e n t /
InfoSphere_Information_Server
m~~q zIZ;ZTBX7Dbv=8>cOiRP
Xm~" I T M5qI/~qDE":
www.ibm.com/businesssolutions/
vT/~q (}Z;ZTBX7D“vT/~q”>cO4
(J',zIT\mzcT:X(<u'Vh
s"8r IBM Web >cME"D4S:
www.ibm.com/account/
`5kO$ zIZTBX7KbPX<u`5ML}~q
DE",b)~qG(*vK"+>M+2z
9q!",$ME/ IT <\xhFD:http://
www.ibm.com/training
IBM zm zIT(}TB>c*5 IBM zmTKbwV
bv=8:www.ibm.com/connect/ibm/us/en/
© Copyright IBM Corp. 2005, 2014 59
60 Netezza Performance Server ,S8O
=< E. CJz7D5
D5T`Vq=a):*z IBM Knowledge Center"I!D>X20DE"PD,T
0 PDF i.#zIT1SSz7M'zgfCJ*zr>X20Doz#
IBM Knowledge Center nJZiR InfoSphere Information Server DnBE"#IBM
Knowledge Center |,s`}z7gfDoz,T0W~PyPz7#iDj{D5#
zI(}Q20Dz7r_S Web /@wr* IBM Knowledge Center#
CJ IBM Knowledge Center
P`V==ICJ*zD5:
v %wM'zgfROGPDoz4S#
v 4 F1 |#(#,4 F1 |ar*hvKC'gf10OBDDwb#
":F1 |Z Web M'zP;pwC#
v Z Web /@wPdkX7,}g,1z4G<=Cz71#
dkTBX7TCJ InfoSphere Information Server D5DyPf>:
http://www.ibm.com/support/knowledgecenter/SSZJPZ/
g{z#{CJX(wb,kZ URL P9Cz7j6"D5e~{FMwb768
(f>E#}g,KwbD 11.3 f>D URL gBy>#(⇒ {E8>PLx):
http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/⇒com.ibm.swg.im.iis.common.doc/common/accessingiidoc.html
a>:
C*6PD9P;vrL URL:
http://ibm.biz/knowctr
*8(X(z73f"f>rwbDrL URL,kZrL URL Mz7j6.d9C
.E (#)#}g,yP InfoSphere Information Server D5DrL URL GTB URL:
http://ibm.biz/knowctr#SSZJPZ/
Kb,TOwbDrL URL(4(T"|LD URL)*TB URL(⇒ {E8>P
Lx):
http://ibm.biz/knowctr#SSZJPZ_11.3.0/com.ibm.swg.im.iis.common.doc/⇒common/accessingiidoc.html
|Doz4ST}C>X20DD5
IBM Knowledge Center |,D5DnBf>#+G,IT+D5D>Xf>w*E"
PD20,"+oz4SdC*8rKE"PD#g{zDs54a)TrXxDC
J,G4>XE"PDa\PC#
© Copyright IBM Corp. 2005, 2014 61
9CE"PD20|f=D208>E"4+d20=y!FczO#20"t/E
"PDs,ITZ~qcFczO9C iisAdmin |nT|Dz7 F1 Moz4Sy}
CDD5;C#(⇒ {E8>PLx):
WindowsIS_install_path\ASBServer\bin\iisAdmin.bat -set -key ⇒com.ibm.iis.infocenter.url -value http://<host>:<port>/help/topic/
AIX LinuxIS_install_path/ASBServer/bin/iisAdmin.sh -set -key ⇒com.ibm.iis.infocenter.url -value http://<host>:<port>/help/topic/
dP,<host> G20E"PDDFczD{F,<port> GE"PDDKZE#1!K
ZEG 8888#}g,Z9C1!KZD{* server1.example.com DFczO,URL
5+* http://server1.example.com:8888/help/topic/#
q! PDF M2=4D5v PDF D~i.IZ_q!,"ISTB'VD5CJ:https://www.ibm.com/support/
docview.wss?uid=swg27008803&wv=1#
v 2ITZ_):r(}z1XD IBM zm):2=4q=D IBM vfo#*Z_
):vfo,kCJ;Z http://www.ibm.com/e-business/linkweb/publications/servlet/
pbi.wss D IBM vfoPD#
62 Netezza Performance Server ,S8O
=< F. a)PXz7D5D4!
zITa)PX IBM D5DPozD4!#
zD4!+PzZ IBM a)_J?DE"#zIT9CTBN;=(4a)b{:
v *a)PXZ IBM Web >cOP\D IBM Knowledge Center PwbDb{,k
G<"(}%wCwbW?DmSb{4%4mSb{#TbV==a;Db{I
)+Zi4#
v *+PX IBM Knowledge Center PwbDb{"Mx IBM "9d{NNK<^(
i4Cb{,kG<"%w IBM Knowledge Center W?D4!4S#
v 9C www.ibm.com/software/awdtools/rcf/ ODZ_A_b{m4"Mb{#
v (}r [email protected] "MgSJ~4"Mb{#k|,z7D{F"z7
Df>E,T0JOD{FMiE(g{IC)#g{zTX(D>"mb{,k
"wZ]D;C(}g,jb"m`Er3k)#
© Copyright IBM Corp. 2005, 2014 63
64 Netezza Performance Server ,S8O
ywMLj
>E"G*Z@za)Dz7M~q`4D#IBM I\Td{oTa)>JO#+G,
I\h*z5PCoTDz7rz7f>D1>E\xPCJ#
yw
IBM I\Zd{zRrXx;a)>D5PV[Dz7"~qr&\XT#PXz10
yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L
rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V8
IBM D*6z(,NN,H&\Dz7"Lrr~q,<ITzf IBM z7"Lrr
~q#+G,@@Mi$NNG IBM z7"Lrr~q,rIC'TP:p#
IBM +>I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4ZhC
'9Cb)({DNNmI#zITCif==+mIi/Dy:
IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785 U.S.A.
PX+VZV{/ (DBCS) E"DmIi/,kkzyZzRrXxD IBM *6z(
?E*5,rCif==+i/Dy:
Intellectual Property Licensing
Legal and Intellectual Property Law
IBM Japan Ltd.
19-21, Nihonbashi-Hakozakicho, Chuo-ku
Tokyo 103-8510, Japan
>un;JC"zrNNbyDunk1X(I;;BDzRrXx:INTERNA-
TIONAL BUSINESS MACHINES CORPORATION“4V4”a)>vfo,;=PNN
V`D(^[Gw>D9G5,D)#$,|(+;^Z5,DPXGV("JzM
JCZ3VX(C>D#$#3)zRrXxZ3);WP;Jmb}w>r5,D
#$#rK>unI\;JCZz#
>E"PI\|,<u=f;;<7DX=r!"ms#K&DE"+(Z|D;b
)|D+`k>vfoDBf>P#IBM ITf1T>JOPhvDz7M/rLrxP
DxM/r|D,x;mP(*#
>E"PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN==
d1TG) Web >cD#$#G) Web >cPDJO;G IBM z7JOD;?V,
9CG) Web >cx4DgU+IzTPP##
IBM IT4|O*J1DNN==9CrV"zya)DNNE"x^kTzP#NN
pN#
© Copyright IBM Corp. 2005, 2014 65
>LrD;mI=g{*KbPXLrDE"To=gB?D:(i)JmZ@"4(
DLrMd{Lr(|(>Lr).dxPE";;,T0(ii)JmTQ-;;DE
"xP`%9C,kkBPX7*5:
IBM Corporation
J46A/G4
555 Bailey Avenue
San Jose, CA 95141-1003 U.S.A.
;*qXJ1Du~Mun,|(3)iNBD;(}?D6Q,<IqCb=fD
E"#
>JOPhvDmILr0dyPICDmIJOyI IBM @] IBM M'-i"IBM
zJm~mI-irNN,H-iPDuna)#
K&|,DNNT\}]<GZ\X73PbCD#rK,Zd{Yw73PqCD
}]I\aPwTD;,#P)b?I\GZ*"6D53OxPD,rK;#$k
;cIC53OxPDb?a{`,#Kb,P)b?G(}Fcx@FD#5Ja
{I\aPnl#>D5DC'&1i$dX(73DJC}]#
f0G IBM z7DE"ISb)z7D)&L"dvf5wrd{I+*qCDJO
Pq!#IBM ;PTb)z7xPbT,2^(7OdT\D+7T"f]TrNNd
{XZG IBM z7Dyw#PXG IBM z7T\DJb&1rb)z7D)&La
v#
yPXZ IBM 44=rrbrDyw<If1|DrUX,x;mP(*,|Gvv
m>K?jMb8xQ#
>E"vCZf.D?D#ZyhvDz7OP.0,K&DE"aP|D#
>E"|,ZU#5qYwP9CD}]M(fD>}#*K!I\j{X5wb)
>},>}PI\a|(vK"+>"7FMz7D{F#yPb){V<Gi9
D,tV5znP5J5qs59CD{VMX7kK`F,?tIO#
f(mI:
>E"|(4oTN=Dy>&CLr,b)y>5w;,Yw=(OD`L=(#
g{G*4UZ`4y>LrDYw=(OD&CLr`LSZ(API)xP&CLr
D*""9C"-zrV"*?D,zITNNN=Tb)y>LrxP4F"^D
"V",x^kr IBM 6Q#b)>}"4ZyPu~Bw+fbT#rK,IBM ;
\##r5>b)LrDI?T"I,$Tr&\#y>Lr<G“4V4”a)D,
;=PNNV`D#$#TZ9CKy>Lry}pDNNp5,IBM +;P#pN#
2b)y>LrD?]=4rdNN?VrNN\zz7,<Xk|(gBf(y
w:
©(s+>D{F)(j)#K?VzkGy] IBM +>Dy>Lr\zv4D#©
Copyright IBM Corp. (dkj]). All rights reserved.
g{z}Zi4>E"Dm=4,<,MJ+<}I\^(T>#
66 Netezza Performance Server ,S8O
~=_T"bBn
IBM m~z7(|,m~4~qbv=8(“m~z7”))I\a9C cookie rd{
<uU/z79CE",TozDFnUC'ei"(FknUC'D;%rCZd
{?D#Zm`ivB,m~z7;aU/vKIj6E" (PII)#RGD3)m~z7
ITozzU/vKIj6E" (PII)#g{Km~z79C cookie 4U/vKIj6
E" (PII),G4PXCz79C cookie DX(E"gByv#
y]?pDdC,Km~z7I9Ca0rVC cookie#g{4Pvz7ri~,G4
Cz7ri~;a9C cookie#
m 15. InfoSphere Information Server z7Mi~9C cookie
z7#i i~r&\?~
yCD cookie `M U/K}] }]C> {C cookie
NN(tZ
InfoSphere Informa-
tion Server 20)
InfoSphere Informa-
tion Server Web X
F(
v a0
v VC
C'{ v a0\m
v O$
^({C
NN(tZ
InfoSphere Informa-
tion Server 20)
InfoSphere Metadata
Asset Managerv a0
v VC
^vKIj6E"
(PII)v a0\m
v O$
v v?C'WCT
v %cG<dC
^({C
I n f o S p h e r e
DataStage
Big Data File WN v a0
v VC
v C'{
v }V){
v a0j6
v a0\m
v O$
v %cG<dC
^({C
I n f o S p h e r e
DataStage
XML WN a0 Z?j6 v a0\m
v O$
^({C
I n f o S p h e r e
DataStage
IBM InfoSphere
D a t a S t a g e a n d
QualityStage Opera-
tions Console
a0 ^vKIj6E"
(PII)v a0\m
v O$
^({C
InfoSphere Data
Click
InfoSphere Informa-
tion Server Web X
F(
v a0
v VC
C'{ v a0\m
v O$
^({C
InfoSphere Data
Quality Console
a0 ^vKIj6E"
(PII)v a0\m
v O$
v %cG<dC
^({C
I n f o S p h e r e
QualityStage Stan-
dardization Rules
Designer
InfoSphere Informa-
tion Server Web X
F(
v a0
v VC
C'{ v a0\m
v O$
^({C
InfoSphere Informa-
tion Governance
Catalog
v a0
v VC
v C'{
v Z?j6
v wD4,
v a0\m
v O$
v %cG<dC
^({C
ywMLj 67
m 15. InfoSphere Information Server z7Mi~9C cookie (x)
z7#i i~r&\?~
yCD cookie `M U/K}] }]C> {C cookie
InfoSphere Informa-
tion Analyzer
I n f o S p h e r e
D a t a S t a g e M
Q u a l i t y S t a g e
Designer M'zP
D Data Rules WN
a0 a0j6 a0\m ^({C
g{*Cm~z7?pDdCrza)Kw*M'(} cookie Md{<uU/nUC'
vKIj6E"D\&,z&CTPwsPXK`}]U/JCDNN(ID(Ib
{,|(Gqh*"vyw0wC,b#
PX+|( cookie ZZDwV<uCZb)C>D|`E",kND IBM D~=_T
(x7* http://www.ibm.com/privacy)M IBM DZ_~=yw(x7* http://
www.ibm.com/privacy/details)Pjb*“Cookies, Web Beacons and Other Technolo-
gies”D?VT0“IBM Software Products and Software-as-a-Service Privacy Statement”(x
7* http://www.ibm.com/software/info/product-privacy)#
Lj
IBM"IBM UjM ibm.com® G International Business Machines Corp Z+rm`>(
xrZ"aDLjr"aLj#d{z7M~q{FI\G IBM rd{+>DLj#
I B M LjD10PmITZ W e b Oq!,x7*:w w w . i b m . c o m / l e g a l /
copytrade.shtml#
BPwnGd{+>DLjr"aLj:
Adobe G Adobe Systems Incorporated Z@zM/rd{zRrXxD"aLj#
Intel M Itanium G Intel Corporation rdS+>Z@zMd{zRrXxDLjr"
aLj#
Linux G Linus Torvalds Z@zM/rd{zRrXxD"aLj#
Microsoft"Windows M Windows NT G Microsoft Corporation Z@zM/rd{zR
rXxDLj#
UNIX G The Open Group Z@zMd{zRrXxD"aLj#
Java MyPyZ Java DLjMUjG Oracle M/rdX*z9DLjr"aLj#
United States Postal Service 5PTBLj:CASS"CASS Certified"DPV"LACSLink"
ZIP"ZIP + 4"ZIP Code"Post Office"Postal Service"USPS T0 United States Postal
Service#IBM Corporation G United States Postal Service DG@< DPV M LACSLink
mI$VP_#
d{+>"z7r~q{FI\Gd{+>DLjr~qjG#
68 Netezza Performance Server ,S8O
w}
[A]20MdChs 10
[B]>XoT'V(NLS) 31
m 15, 22
;,}]bPDY1$wm (TWT) 16
[C]Yw53/=( 9
iRYw 43
z7(z&\!n
(z&\!n 53
z7D5
CJ 61
[D]r*|n 17, 23
(g{ 17, 24
(ew5 32
A 10
AYw 13
hCP(e 33, 38
8(}]Vx 35
AWN 9
A!=( 22
A!}] 21
A}]`M 25
[F](Iyw 65
CJ(
Netezza }]b 2
~qw 16, 23
[G]Ev 7
|BekYw
Y1$wm 42
|B/>}/|BekYw 13
XU|n 17, 23
[H]73d?
Neteeza Connector 51
[J]WNYw
hCP(e 33, 38
XOP{F 17
[K]M'zSZ 8
M''V
*5 59
[L],S 16, 23
P(e
hC (setting up) 33, 38
[M]\k 16, 23
|n
o( 55
|nPo(
<( 55
?j 14
[P]dC 35
G<Er 40
dC}]4 12
[R]U>D~ 14, 22
m~~q
*5 59
[S]>};%dP 17
Lj
Pm 65
hF1~q
ZhF1zI SQL od 43
ZhF1i$ SQL od 44
hC73d? 11
hCtT 13, 20, 21, 24
9CU>D~ 18
dv4S 21
}]
A! 33
}]b 16, 23
}]`M 26
<k}] 45
A!}] 45
4k}] 45
0k}] 45
DataStage 45
Netezza 45
}]4 16, 23
4( 1, 2
tT
(e 41
[T]XbV{
Z|nPo(P 55
[W]b?m 7
b?m$wwL 9
*}]bhC73d?
hC 3, 4
[X]Hvu~ 10, 12
4Yw 13
(etT 41
hCP(e 33, 38
8(}]Vx 41
4WN 9
4k=( 15
4k}] 13
4}]`M 26
!n 16, 23
© Copyright IBM Corp. 2005, 2014 69
[Y]i$(validation)
KP 46
}C4S 43
3d
}]`M 45
C' 16, 23
o(
|nP 55
4 22
*}]
<k 30
[Z]'V
M' 59
8( Netezza Enterprise WNDhv 20,
24
8( Netezza Enterprise WND4P==
20, 25
8( Netezza Enterprise WNDV{/3d
21, 25
0k=( 7, 9, 10, 14
V{`k 31
w5
`k"KP 46
CCC_NZ_LOG_LEVEL 73d? 51
Ddsenv E> 4
LLinux 1
NNetezza 10
Netezza j6
#fj6 31
(gj6 31
Netezza *}]
<k 30
Netezza connector
`k"KPw5 46
#fiR 35
AYw
(etT 34
A!}] 32
Netezza connector (x)
CJ 32
Ev 29
JOoO 47
dCX4P&m 39
dC*?j 38
dC*4 33
}]`M 44
!hiR
Yw 36
4k}] 37
QVx}] 35
Zw5P9C 29
Netezza Enterprise WN 7, 9, 10, 12, 13,
20, 21, 24
Netezza ODBC }/Lr
dC 1
Netezza Performance Server 7, 8, 9, 10,
13, 21, 25, 26
Netezza Performance Server 8000 7
Netezza Update WN 26
Netezza Upsert WN 26
nzload 7
nzload $wwL 10
OODBC }/Lr
dC 1, 2
TTMPDIR 73d? 51
TWT }]b 16
Uupsert Yw 13
WWeb >c
G IBM 57
Windows OD}]4
4( 2
Windows OD ODBC }/Lr
dC 2
70 Netezza Performance Server ,S8O
����
Printed in China
SC43-1052-00