I have a sequential file as source it has one field as "Table_Name".My requirement is to extract the table name values from the Table_Name field and create a target file with name as that of "Table_Name".
Note: The sequential file will contain only one record.
For e.g:-
Case1:-
Source:-
Table_Name Col1 Col2
Emp Tom 23
I have to create target file with "Emp" as it's name.
Similarly for Case2:-
Source:-
Table_Name Col1 Col2
dept Finance 30
I have to create target file with "dept" as it's name.
Do i need to set the column value as parameter.
In transformer i tried using DSSetParam command to set as parameter but it didn't work..
Please help me out...
Setting column value as Parameter
Moderators: chulett, rschirm, roy
Re: Setting column value as Parameter
Hi,
You cannot change the value or assign the job parameter when the job is executing. That is why DSSetParam wont work in the transformer.
You have to fetch the value from the file and then pass it to the DS job as paramter.
You cannot change the value or assign the job parameter when the job is executing. That is why DSSetParam wont work in the transformer.
You have to fetch the value from the file and then pass it to the DS job as paramter.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: