Ask a Question related to Coldfusion Database Access, Design and Development.
-
acsdirect #1
SQL Bulk Loader
How do I trigger the ORACLE 10g Bulk Loader from within CF? I tried with the
following code but am told it is an invalid SQL statement.
thanks!
<cfquery name="qCatalogImport" datasource="ACS">
LOAD DATA
INFILE #DateFileName#
INTO TABLE PARTS_IMPORT
FIELDS TERMINATED BY '|'
(PART_NUM,LIST_PRICE,DESCRIPTION CHAR(750),DISCOUNT_CODE,Mfr_ID,ISREMAN)
</cfquery>
acsdirect Guest
-
Bulk eMailing
How could it be possible to automatically delete subscriber?s email address and its associated record from an Access database after two successive... -
send out bulk e-mails
I have a couple of databases. In both of these databases I have an e-mail field. I would like to send out an e-mail to every address in those... -
newbie: bulk mail with php
Hello All, I want to send email to a list of about a thousand people from a mysql database. Putting the mail() function in a loop takes forever.... -
bulk loading
Pete McCutchen wrote: I used to do it. Don't remember the brand of the loader, but it was the one with a light trap rather than felt lips... -
too many rows by bulk fetch
Hi guys, i have a problem, i want to fetch many rows per bulk fetch. so i took the manual from IBM and coded as it is described. But when... -
paross1 #2 Re: SQL Bulk Loader
Your statement isn't actually valid SQL, as it appears to be the control
parameter, of contents of a CONTROL file, that you would reference when
executing the SQL*Loader (sqlldr).
I've never tried this, but you might experiment with putting this into a
PL/SQL stored procedure using dynamic SQL (NDS).
From Oracle documentation:
<i>When you invoke SQL*Loader, you can specify certain parameters to establish
session characteristics. Parameters can be entered in any order, optionally
separated by commas. You specify values for parameters, or in some cases, you
can accept the default without entering a value.
For example:
SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat
USERID=scott/tiger, ERRORS=999, LOAD=2000, DISCARD=toss.dis,
DISCARDMAX=5
The command to invoke SQL*Loader is operating system-dependent. </i>
Phil
paross1 Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
