Placing a WHERE clause in Teradata OLE DB MultiLoad

[stephanie2e]

I am frequently moving large amounts of data and have found that using Teradata OLE DB Access Module 2.2.1, MultiLoad is very helpful. However, I have yet to find someone who can tell me how to modify the sql to include a WHERE clause.

How would I place: WHERE ICA_ID = 101
in the following example

/* Launch the MultiLoad utility with the -c <character_set_name>
option set to ASCII. (i.e. "mload -c ASCII") */
.LOGTABLE database."samplefile.txt_Log" ;
.LOGON DEV/USER,pswd ;
DATABASE database ;
CREATE TABLE "samplefile.txt" ( ICA_ID INTEGER,
ADDR1 VARCHAR(50) CHARACTER SET LATIN,
MONTHY_FEE FLOAT ) ;
.BEGIN IMPORT MLOAD TABLES "samplefile.txt" ;
.LAYOUT Layout1 INDICATORS ;
.FIELD ICA_ID * INTEGER ;
.FIELD ADDR1 * VARCHAR(50) ;
.FIELD MONTHY_FEE * FLOAT ;
.DML LABEL LabelA ;
INSERT INTO "samplefile.txt" ( ICA_ID, ADDR1, MONTHY_FEE )
VALUES ( :ICA_ID, :ADDR1, :MONTHY_FEE ) ;
.IMPORT INFILE Untitled
AXSMOD Oledb_Axsmod 'noprompt'
LAYOUT Layout1
APPLY LabelA ;
.END MLOAD ;
.LOGOFF ;

 

[dnoeth]

Hi Stephanie,

.IMPORT INFILE Untitled
AXSMOD Oledb_Axsmod 'noprompt'
LAYOUT Layout1
APPLY LabelA WHERE ICA_ID = 101;

Btw, there's a forum for Teradata at Tek-Tips

http://www.tek-tips.com/threadminder.cfm?pid=328

and there's *the* best source of information concerning Teradata:

http://www.teradataforum.com

Dieter

 

[stephanie2e]

Dieter,

Thank you very much!

Stephanie