Skip to Content
0
Former Member
Oct 22, 2014 at 03:32 PM

From Database Pass Issue

55 Views

Hey experts,

I've been posting on here a lot lately but I keep getting answers so I'm going to keep coming back! Anyway, I'm trying to do an evaluation of several values returned by a SQL query and I'm using a From Database pass to accomplish this. I have a table of users that I created that contains only the following fields:

MSKEYVALUE, FIRSTNAME, LASTNAME, MSKEY

The source of my From Database pass pulls in this entire table:

select * from UsersToBeEvaluated

In my destination, I'm writing to a table called EvaluatedUsers and it looks something like this:

Target Script Source

MSKEY MSKEY

MSKEYVALUE MSKEYVALUE

RESULT z_evaluate FIRSTNAME||LASTNAME||MSKEYVALUE

When I ran my job the first time and put a bunch of uWarning lines in the "z_evaluate" script to see what my variable values were, Par is being passed in empty. I'm passing in three values separated by the double pipe ("||") then splitting them inside the script. Why is Par empty? Will From Database only allow one value in each of the source entries? If so, how can I best accomplish what I want to do, that is evaluate these three variables and have the results come out in a temporary table? Thanks in advance for any assistance.