DSXchange

I don't get the impression that the "2000 values" are the issue here but rather the source data they would be used to extract. And managing a view might be troublesome seeing as how the list of values is "varying in nature". I'm assuming there is a privacy issue here, PHI or PII ...

Have you not used job parameters yet? They are typically enclosed in hash / pound signs when referenced, so:

WHERE BA.col3 = SA.col3
AND MP.col2 LIKE '#SampleTable#'

Where "SampleTable" is the name of your parameter. That's the basics, let's start there and see if it helps.

It removes all numeric digits from the string and then compares the result to an empty string. If there is more than that left, it's not valid.

Redirection:

ls \&PH\& > YourFile

For the Administrator, search here for COMO ON (and OFF) and all will be revealed.

Still? After you did what?

See if this helps: viewtopic.php?t=140150

Make sure you are setting the Abort value in the reject link itself to abort after 1 row has gone down it, don't run the job with a warning limit of 1.

FYI - Some versions of grep have a 'count' option so there's no need for that pipe to "wc -l".

Then you are not at the command line, which means logged in at the O/S level. You are still trying to run this from TCL or the Administrator client. Don't.

Don't cat the file to grep, just grep it. And try putting single quotes around that you are grepping for.

That's true, you'd need to use the Java Pack for that. Could have sworn I've used a Google geocoding service in another life, though....

A) You need to run it from the command line, not TCL.
B) Do not include the "Creating file DeclDet1, executing command " verbiage, just the command itself.

Suggest you contact your official support provider for that one.

You should also look at your partitioning, 'Auto' is not your friend at times like this. Typically one would hash partition over the key(s) used in the target.

One of the "Web Services" stages - client or transformer. Detailed in the Web Services Pack Guide pdf.