DSXchange

'ren' is short for rename and is a perfectly valid DOS command, it's 'mv' that isn't. 'mv' is a UNIX command and will work for you only if you have something like the MKS Toolkit installed. The routine is not quite right, as I noted in my post. It needs to be tweaked to support the syntax as require...

That's just The Way It Works when using ENV variables like that. Job runs but you can't view data without putting a 'real' value in there.

Maybe we can say that as I do not have started the job yet, the values I get are those of the previous run ? Yes. And as an FYI, I've never bothered to check to that level. Simply checking the status of the DSSetParam function is sufficient: ErrCode = DSSetParam(JobId, ParamName, ParamVal) ...

I don't understand why one would "need" to do this. Any job that populates the hashed file will automatically create it if it doesn't exist. If the first usage of this hashed file is as a lookup, there is a simple way in the GUI to make sure it gets created if it doesn't already exist - feed it from...

Post your XPath expressions. Do you have any of them marked as a Key field? Also curious, did you create the XPath expressions by hand or did you import the metadata for them from an xsd and let the tool generate them for you?

I know the issue you've got with the macro, we've discussed it quite a bit in recent days so knew the dashes would be an issue. It's hard for me to know your silly mistake when I can't see your job. What you should be able to do to make it work is have a job parameter with the full path to the file ...

Ok... what mechanism are you using for getting the next value from the "table serial" and how is it being incremented? Any decent mechanism would support concurrency and it wouldn't be an issue for multiple processes to access it simultaneously without pulling the same key. For example, that's why t...

You can directly create the file with the date as long as you've got the information to use in the filename when the job starts. Or if one of the existing macros will work for you. Typically, this is passed in as a job parameter and used in the filename. The path I assume you are following, since yo...

Blank page? Worked fine for me...

That would be what is known as a Sequence job. It can be as simple as two stages: a Job Activity stage to run the job in question and a Notification Activity stage to send an email if all is ok.

When you say 'Table Def' do you mean the imported metadata or the actual table definition in the database? I've never dealt with anything like a 'Binary Timestamp' but I would think someone there that you work should be able to help you determine if you are getting valid values for any particular ro...

What exactly are you trying to do? The only place you can run an 'After Job Subroutine' is, oddly enough, after the job has completed. Are you trying to create a file with a date stamp in it? If so you would use your parameterized 'static' filename in the Sequential File stage and then also pass it...

What kind of 'documentation' are you looking for? The official link is here.

If you are looking for more than what's available there, you should probably post in the TX Forum as well.

There is a transform called CAPITALS which will do what you want.

Ok, another guess... perhaps your key choices are causing these 15 records to collapse down to one? Don't forget there are no such things as duplicates in a hashed file, it's destructive overwrite based on the keys defined - and last one in wins.