DSXchange

First off, I (personally) would never code specific status codes into custom triggers like that, there's really no need. You're much better off using the defined triggers in this case - most cases, actually. Have one link that goes forward to the next step with a 'Ran OK' trigger. For your error pat...

Well, the 'overhead' of a simple constraint like that would be negligible, so if it is working for you I probably wouldn't worry about it. That being said... There are ways on UNIX where the last line can be stripped in the Filter box of the Sequential File stage, or via some kind of 'pre-processing...

On UNIX, grep for 'dsrpcd'. However, I'm a little confused. You said that jobs won't run but can be reset (something along those lines), which would imply that you can connect to the server in question. Then you say that 'dsadm' can't log in via any client tools to the server. The question about dsr...

Morney, that was mentioned earlier in the thread. However, the question posted was specifically how to do this in BASIC, hence this long and winding road...

A couple of points: There is a forum specific to RTI/SOA, so you'd be better off posting there. I don't have any direct experience with RTI, but from what I've seen simply having a hash file in a job wouldn't be a problem. Building one, using the traditional server/batch model, would however. That h...

So, Guy... does this mean your problem is solved well enough or are you still expecting something from this thread?

You know, I think you may be right. I was under the impression from when I did this kind of thing many moons ago that I had to use WeofSeq to avoid... unpleasant results.

Kind of boggles the mind, but Ray [gasp] might be wrong!

ray.wurlod wrote:You don't need WeofSeq at the end. CloseSeq will write an end of file mark if you have written to the file.

Well, ok then... nevermind. Pay no attention to the man behind the curtain.

This is an example of what Craig called "hard coding the second argument". For lack of a better term. Hopefully people understand any number of parameters can be passed by the transform to whatever is underneath without the user knowing it's going on - just had no idea what to call it at oh-dark-th...

You can't use the FTP stage with a zip file. You could unzip the file using the Filter command area and read in the results. Mostly. Sorta.

As Ken notes, if you just want to move it, use the 'normal' command line / scripted ftp command.

Curious if you've tried searching the forum for the keywords 'excel' and 'ODBC'? There are quite a number of posts on the subject, perhaps an answer to your question lies there somewhere.

Either that or explain in more detail the problem you are having.

That's true. Just start overwriting and then truncate the remainder of it at the end.

You can't 'insert' records into a sequential file. You'd have to write the header record out to a new file and then write the contents of the original file to it after that.

If you want to 'truncate' the sequential file before you start writing to it, use (from memory) WEOFSeq first.

Yet.