Command Line Parameters

DataPipe Search and Replace: Online Help Command Line Parameters	Submit feedback on this topic
Home Menus: File Edit Options (Logging, Restart & Commit) Tools Help Tabs: Query Sample data Transforms Preview changes Go

DataPipe can be run from a DOS shell or from a shortcut with parameters to make it run automatically. This is very useful for automation and scheduling (by making the short cut an entry in the Start Up folder), and for running DataPipe from a batch file for different databases and tables. Here is a complete example:

"C:\Program files\DataPipe\datapipe.exe" "/datasource=Provider=MSDASQL.1;Persist Security Info=False;Data Source=Northwind" "/query=select * from customers" "/column:customerid=C:\Program files\DataPipe\Filters\lower case.fll"

You can also use the following form:

Run DataPipe as follows:
"C:\Program files\DataPipe\datapipe.exe" "/z=c:\commands.txt" /Q

Save these details to c:\commands.txt (for each table to be changed)
/DATASOURCE=Provider=MSDASQL.1;Persist Security Info=False;Data Source=Northwind
/QUERY=select * from customers
/COLUMN:CustomerID=C:\BP\DATAPIPE\INSTALL\LOWER CASE.FLL

/G
(repeat this structure for every database and/or table)

Usage:

datapipe.exe [options] [/G [/Q]]

Where [options] is zero or more of:

/COLUMN:<column name>=<TextPipe Pro filter name>	Specifies which TextPipe filter should be applied to which column e.g. /DATASOURCE=... /QUERY= or /TABLE= /COLUMN:col1=filter1 /COLUMN:col2=filter2 ... The TextPipe filter name is allowed to be blank - this clears a column with an existing value.
/DATASOURCE=<data source string>	The data source connection string of the database to connect to e.g. /DATASOURCE=... /QUERY= or /TABLE= /COLUMN:col1=filter1 /COLUMN:col2=filter2 ...
/F=<.dpp filename>	Open DataPipe settings file. This can be used to set parameters that can't be set via the command line, such as restart options and cursor options.
/G	Go. Begin processing. Processing of the command line does not continue until the processing job is complete.
/LOG=filename	Enables logging to the specified file. To disable logging, set the filename to blank.
/Q	Quit DataPipe at the end of processing.
/QUERY=<query string>	The database query string to get records from e.g. /DATASOURCE=... /QUERY=query /COLUMN:col1=filter1 /COLUMN:col2=filter2 ...
/TABLE=<table>	The database table to get records from e.g. /DATASOURCE=... /TABLE=tablename /COLUMN:col1=filter1 /COLUMN:col2=filter2 ...
/Z=<filename>	Read command line parameters from the specified file. Very useful for performing large amounts of changes to many tables, or for working around the Windows limitation of approx 260 characters on the command line. For example, if you had the long command line start /w datapipe.exe "/f=my special filter.fll" /g "/f=my special filter2.fll" /g "/f=my special filter3.fll" /g "/f=my special filter4.fll" /g /q This would change to something like start /w datapipe.exe /z=commands.txt and the file commands.txt would contain /f=my special filter.fll /g /f=my special filter2.fll /g /f=my special filter3.fll /g /f=my special filter4.fll /g /q