INMOD and OUTMOD

Teradata Studio

INMOD and OUTMOD

Hi,

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

Thanks in Advance,

Raja_VS

1 REPLY
Enthusiast

Re: INMOD and OUTMOD

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 concatinations...etc..you 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)

Regards,

Sri