Hi Brian,
Thank you for your reply. However, our need is to have the array in the SP so that we can filter/reduce the data come over onto CR.
I was thinking about sending the string with Dilimeter such as AAA,BBB,CCC but this is not a desirable approach because we want to validate the items in the string against a DB2 table before sending over to the SP. And you know CR is not doing that well.
By the way:
Another question: Instead of using SP, we plan to connect and do table joins all on CR. But from looking at the Show Query in CR, it does not show the WHERE clause used with Parameters. So the question is: Does CR bring ALL data over then filter then based on the inputs in the Parameters ? We dont want that. We want the data come in to CR as much as the inputs from the Parameters !!!!