DSXchange

If you are processing a list of job / stage / link names in a separate 'audit' job and calling this routine for every row, that would have been good information to know right off the bat. Would have saved a little drama. So... if it works when you test the routine from the Manager and it doesn't wor...

How can we 'shed any light'? You've given us no clue what field or fields make up your PK constraint in that table.

If your Array Size is greater than 1, try setting it down to 1 and let us know if the error persists.

Code tags would preserve spaces and formatting. Anything else gets you an aligned and trimmed display.

Yes. This is a known issue with the Execute Command stage in some versions. If you know you are doing everything right, and the parameters are being correctly translated in the log, but the actual command still doesn't work - you're bugged.

What datatype did you choose? What error did you get? You're going to have problems handling it but *may* be able to get it to work.

Only asked because in that situation I'm used to seeing the following message in the log:

Read caching disabled, file size exceeds cache size

Without any 'add_to_heap' messages. But if that can also occur, then that's good to know.

I was under the impression this warning would only occur when writing to a hashed file.

A fault type of 10 is apparently a "(SIGBUS) bus error". Not sure how much that helps, however...

Already suggested that.

You missed my point... and it's not impossible, but if you want to believe that, fine. Work on tuning the reference lookup query then, perhaps an index is in order to supprt the query? I don't believe you have any choice but to use ODBC for Informix, so do your best to make the reference lookup quer...

In the second case when you mean default value what would it be, 9999-99-99 or can we insert null vlaue ' ' ? It would have to be a valid date with special meaning to your application. For example, I've seen things like: 01-01-1900 12-31-9999 As magic min/max values used. You can't use something li...

Anyone seen this message? It's a new one on me and I can only find one (unresolved) occurance in the forums for it. Got these two messages before it: Abnormal termination of stage Jobname..transformer detected Jobname..transformer.link: Run stopped after 2707126 rows Names have been changed to prote...

Who cares?

Server question posted in the Server forum, so you got a Server answer.

Those are UNIX concepts, not applicable to Windows. And sorry but no, I've got no idea what the equivalent (if any) is for Windows.

You may, however, need an 'admin' to help you interpret the results.