Dynamic Parameter

[reddy]

Hi Guys,

My requirement is like this:

We are using partitioned (year) and subpartitioned(month) oracle target table.we are going to refresh this table daily 4,5 times so as per requirement i have to truncate the subpartitioned (current month )and then load the data in that subpartition.

Here is my rough idea:

Job 1: i am going to get month from dual table and store into a seq file (D:\ASCENTIAL\DATASTAGE\PROJECTS\HR\MONTH.TXT)
CY2006_M02

Job 2:using custom sql TRUNCATE LABOR_TEST SUB_PARTITION(#JOBPARAMETER) AND THEN INSERT INTO TARGET TABLE.

Please light on me how to pass the value in the seqfile like CY2006_M02

into TRUNCATE STATEMENT..



Thanks in advance
reddy

[kwwilliams]

Create a routine that reads the file you created and then pass the return value to the job that you have the truncate.