DSXchange

What kind of 'numeric' value would you convert your sample timestamp to? 20100909220101? Something else?

By default, failed lookups do not return anything, unlike Server. You can, however, tell it to 'forward reject rows' or something similar via a property setting and it will include both on the output link. Then you check like you might have in Server, by seeing if the output is null or not null, wit...

The filter command allows a command to deliver data to the stage via "std out" which the stage then reads from "std in" essentially. A PDF converter would (hopefully) be able to deliver converted text in that same fashion. You would, of course, need to find and purchase said conv...

Check the Index() and Locate() functions, both can be used for this from what I recall. I would wrap the field to test in the same delimiters used in the list to avoid substring matches - false positives - as a general rule.

What database is this? Have you used this table before or is this your first attempt in a job? Are there other column names in it that are 40 characters long? Trying to determine if this is an "always" issue or something specific to this particular job.

Then, unless other suggestions come along, it seems to be time to involve your official support provider. Have them detail what exactly makes it (or any other close command) 'invalid' and then let us know what you find out!

Ummm... yah... infinite.

Asking more from the "space in the table name" side of things, in case that does end up mattering, seeing as how different ones handle that... [different ly].

Fair enough.

Being an Informatica Dude now as well, I went looking for how it would do something like this as I don't recall seeing any mention of PDF files as a valid source. All I could find (so far) was this: If you want direct access to the PDF file, you could create a simple plugin in C++ or Java to read da...

ps. Anbu said (and meant) before dsjob, as in a separate line:

set -vx
dsjob -run

This should enable verbose debugging information, from what I recall. But again, that could depend on your UNIX and shell, something you haven't passed along.

So... no information on the actual parameter values you are passing? Length, content, nothing?

And then all that code stuff that comes next.

Sounds right to me... if your "client" box is also the Server as well, try shutting down the latter before updating the former.

IBM. Internally. I would wager. There's been no effort made here to collect anything of the sort, any "special" ones outside the normal scope of things.