All Forums Teradata Studio
rvvs999 3 posts Joined 11/13
15 Jan 2014

Can anybody explain what xactly the pupose/use of INMOD and OUTMOD operators in Teradata.
Thanks in Advance,

sgarlapa 88 posts Joined 03/13
15 Jan 2014

Hi Raja,
Inmod , outmode routines are object codes (executables ) of any third party language programs such as c, c++, cobal which would be used as pre or post processing correspondingly.
For example while you are loading the data from a file and in the file you have 100 columns and you want to load only few columns with some can write a program in c, c++ languge implementing this functionality compile it and invoke the object code through fast load utility.  This inmode will pre porcess the data and gives the output which in turn used by fast load to load into your target.
similar with outmode as a combination of fast export (after exporting data if any optation or validation you want to on output file)

You must sign in to leave a comment.