csv_loader_invoke_job.sh Script
Use the csv_loader_invoke_job.sh script to create a report job that uses the loader program as the report script. This job imports data from a comma-separated value (CSV) file that contains the output from an IBM® InfoSphere® DataStage® and IBM InfoSphere QualityStage® job.
Purpose
The csv_loader_invoke_job.sh script imports data from a CSV formatted output file that is generated from IBM InfoSphere Information Server.
Syntax for the csv_loader_invoke_job.sh script
Arguments
Command arguments and their values have the following meanings:
- --username
- Indicates that you want to specify the name of the user for the
company.
This argument is required.
- user
- User name to log in to the company.
- --password
- Indicates that you must supply a password to log in to the company.
This argument is required.
- password
- Password to be used to log in to IBM Product Master.
- --company
- Indicates that you want to load data for a specific company.
- company
- The name of the company that the data is for.
- --jobtype
- Indicates the type of job you want to specify. Currently, the only value that is accepted is report, as the built-in mechanism to support the invocation of loader is using reports.
- report
- Creates a report job. This is the only valid value that must be
specified for the
-jobtypeargument. - --jobname
- Indicates that you want to specify the name of the job.
- jobname
- The name of the job.
- --propertyFilePath
- Indicates that you want to specify the path of the property file.
- file:///<absolute_property_file_system_path>
- The path of the property file.
- --dataFilePath
- Indicates that you want to specify the path of the data file.
- file:///<absolute_data_file_system_path>
- The path of the data file.
Example: Loading data from a CSV file
In this example, data is loaded for the abc_company company from a CSV file.
csv_loader_invoke_job.sh --username=user --password=password -–company=abc_company -–jobtype=report --jobname=jobname -–propertyFilePath=file:///<absolute_property_file_system_path> --dataFilePath=file:///<absolute_data_file_system_path>