Hi,
Newbie Questions
I am reading sequential files using file pattern & trying to load temp tables for each changing time period(YYMM). I need to pass parameter to Oracle stage to create tables with changing YYMM?
Thanks in Advance.
SP.
Creating dynamic table.
Moderators: chulett, rschirm, roy
Re: Creating dynamic table.
Have a JOB parameter for the period and use it as part of the table name in the DATABASE stage.
something like
TEMPTABLE_#Param_Period#
Every time you run the job, you will create a new table. But you need to be mindful about the fact that when the period doesn't change, table need to be dropped or handled correctly.
something like
TEMPTABLE_#Param_Period#
Every time you run the job, you will create a new table. But you need to be mindful about the fact that when the period doesn't change, table need to be dropped or handled correctly.
~Kris
Re: Creating dynamic table.
The Parameter is a field in the sequential file. How do I pass it to the table name in the same job... If I say #DSLinkname.fieldname# in the table name, job parameter doesn't get resolved. I am using Oracle Enterprise stage with load option.kris wrote:Have a JOB parameter for the period and use it as part of the table name in the DATABASE stage.
something like
TEMPTABLE_#Param_Period#
Every time you run the job, you will create a new table. But you need to be mindful about the fact that when the period doesn't change, table need to be dropped or handled correctly.
Thanks
SP
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 42
- Joined: Tue Jan 24, 2006 9:11 am
Re: Creating dynamic table.
[quote="UPS"]
You can pass the seq file value in the DS routine. The routime will set the parameter using 'DSSetParam ' function and call a job 'DSRunJob'.
Thanks.
You can pass the seq file value in the DS routine. The routime will set the parameter using 'DSSetParam ' function and call a job 'DSRunJob'.
Thanks.
wed