Help in bteq

Database

Help in bteq

How to delete based on values in datafile using bteq?
1 REPLY

Re: Help in bteq

you can use BTEQ Import.

example is given below.

.LOGON u4455/tljc20,tljc20
.IMPORT DATA FILE = data2_2a
.REPEAT *
USING in_customer_number (INTEGER)
DELETE
FROM AU.Customer
WHERE customer_number = :in_customer_number;
.QUIT

i hope this helps you.