ROW Generator ==> PEEK.
The Row Generator has 3 columns Name, ID and CallDate.
Number of records is set to 1
Name is defined as Varchar(50) and extended properties link it to a job parameter
ID is defined as Integer and the value is via job parametr.
CallDate is Date
CallDate is Date type and is also loaded via job parameter which is of type Date.
In essence, I would like to use my own values for the 3 columns.
When i run this job, the Name and ID columns show correct values for the PEEK stage in the log. The CallDate however, shows 1965-07-01 in the output log. I have setup the extended properties for the CallDate column as
Generator
\Type=Cycle
\Initial Value=#CALL_DATE_P#
The initial values from the director log for the Row Generator settings shows as follows.
Code: Select all
main_program: Explanation:
Step has 2 operators.
???, invoked with args: -schema record ( UserName: string[max=100] {cycle={value="RG-Name-Test"}}; PID: int32 {cycle={init="23"}}; CallDate: date {cycle={init="2008-03-12"}}; ) -records 1
output port 0 bound to data entity "Row_Generator_1:DSLink2.v"
???, invoked with args: -nrecs 10 -name
input port 0 bound to data entity "Row_Generator_1:DSLink2.v"
Step has 1 data entity.
Data "Row_Generator_1:DSLink2.v"(an Orchestrate data set)
written by operator "Row_Generator_1"
read by operator "Peek_10"
The final outcome is logged as
Code: Select all
Peek_10,0: UserName:RG-Name-Test PID:23 CallDate:1965-07-01
Thanks in advance for your time