Hello All
I am trying to load a set of tables from one database to another (simple straight load) , However at this point I am using RCP and manually providing table names (as parameter value) for each of the tables being loaded (one at a time)
I wanted to see if there is a way to automate this process by reading the table names from a file (just curious)
I have no clue how to search this issue in this forum so didn t try too hard .
Any ideas would be highly appreciated .
Thank you all for reading
Parameter Provision to read values from file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
OK, show us what you've tried, describe why and how it is not performing as expected, and describe how you've gone about your troubleshooting. Armed with all that information, we may be able to assist.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Sure
I tried to search on key words/phase "parameter value reading from file"
"table names from file"
What I am not sure is does it need a job sequencer to perform this kind of activity to start with or is there a way to simply point the parameter to a file (I don t see this option in 8.5 parameter properties )
What I have tried - Since I do not have a direction to follow and possibely test something at this point - I haven't been able to try anything.
I can test something only if I know how to approach (with what stages) .
Hope this makes sense.
Thank you
I tried to search on key words/phase "parameter value reading from file"
"table names from file"
What I am not sure is does it need a job sequencer to perform this kind of activity to start with or is there a way to simply point the parameter to a file (I don t see this option in 8.5 parameter properties )
What I have tried - Since I do not have a direction to follow and possibely test something at this point - I haven't been able to try anything.
I can test something only if I know how to approach (with what stages) .
Hope this makes sense.
Thank you
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
all you need to do it put all the table names in a file delimited with some character say "|".
Run cat <filename> in the execute command activity and then use its output in a start loop activity (list loop with "|" as delimiter).
The counter variable holding one value at a time can be used as parameter in any downstream stage.
Run cat <filename> in the execute command activity and then use its output in a start loop activity (list loop with "|" as delimiter).
The counter variable holding one value at a time can be used as parameter in any downstream stage.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm