DSXchange

Welcome.

An exact search here for USERSTATUS should turn up quite a number of conversations on how that can be accomplished. And you don't "change" it so much as override it at runtime by sending in a new value...

Sorry but all you've done is restate what was in your original post without adding any details to it. And the devil is in the details.

Please try to answer the questions Jerome posted and anything else you can think of that may prove helpful.

Killed how? Not cleanly as your hashed table is still "busy" and cannot be locked, something the error message clearly notes. Find and kill the remaining process(es) for that job.

Right, except they've said repeatedly that it fails attempting to process the last filename, not that it tries to do one too many. So when they have two names it fails on the second iteration of the loop.

I should have been more specific... seek elsewhere. That command only converts a file, it does not import anything. Use the documented command line import utilities such as dscmdimport.exe.

There's no reason for you to be executing that. It is called automatically when you import something in xml format.

Much of the time, that seems to be one of my duties.

Done.

Craig's not really sure what he's talking about, hence the plethora of question marks.

With no way to test anything, just trying to point the OP in a (possibly) helpful direction. Thanks for the clarification!

As noted, there is no "UNIX folder location" for objects like that.

Still think it is the Field Mark. What happens when you try using array notation $CommandOutput<1> rather than the Convert() function?

Correct - that's because you are still on a 7.x version, later versions support that TIMESTAMP data type more better.

Let's just start with this:

das_nirmalya wrote:There is no way in DS to store and import table definition for Sequential file.

Not true, of course you can. Wouldn't be much of an ETL tool if it couldn't do that. Unless you mean something other than the rather generic statement that it seems you are making?

There's no such animal. And while some parameter types are 'required' (like Date and Integer off the top of my head) others are optional and can be left empty. While you couldn't pop up any kind of dialogue box, you could have (for example) a custom routine that validates the parameters passed in an...

This should help.