We have Decision Stream 6.5 on a WIN NT server using SQL to download JDE Oneworld data from an As/400 into our Cognos datamart.
I don't know all that much about Decision Stream yet (training next week). So -- here's my question: How do I find WHERE a value for a variable being used in the SQL for one of my table(Customer) builds is stored.
I cna right-click on the Datastream forhte build and view the SQL code...it is a big long select followed by
".....WHERE {$CRIT}"
The logs from running this job show me that it translates to "...WHERE (ABAT1 = 'C ')"
We have a new customer type to add to this. I can't find the place where it says that $CRIT is equal to "(ABAT1 = 'C ')".
I can right-click on the JOB, go to Properties, go to Variables and see the variable named CRIT, but there is NO VALUE associated to it.
Where else can I look to find the "(ABAT1 = 'C ')" ??
Please help !
I don't know all that much about Decision Stream yet (training next week). So -- here's my question: How do I find WHERE a value for a variable being used in the SQL for one of my table(Customer) builds is stored.
I cna right-click on the Datastream forhte build and view the SQL code...it is a big long select followed by
".....WHERE {$CRIT}"
The logs from running this job show me that it translates to "...WHERE (ABAT1 = 'C ')"
We have a new customer type to add to this. I can't find the place where it says that $CRIT is equal to "(ABAT1 = 'C ')".
I can right-click on the JOB, go to Properties, go to Variables and see the variable named CRIT, but there is NO VALUE associated to it.
Where else can I look to find the "(ABAT1 = 'C ')" ??
Please help !