DSXchange

Meaning what... that you actually have no problem now?

Silly question but we need to get this out of the way - is there an index over the 'key' column(s) in your update/close links? And having to commit each transaction individually is a performance killer. We may have to look at a flat file approach, something like you posted if you can't get an accept...

Again, please do not hijack other people's posts - start your own.

devanars - please start your own post.

I'm curious what kind of processing you'd like do with an 'Integration Exchange Format' file? Do you mean the ability to read the T and C metadata records and build the target table automatically and then load the data from the D records through some kind of custom stage? Or perhaps just get to the ...

So do I take it that, when you write out sequential file records with those routines, they give you DOS delimiters even on a UNIX system unless you 'convert' them with the syntax you posted?

Keep in mind they are processed top to bottom, which is key here, so make sure the one you use to store the 'previous' value is last in the order listed.

OK, very common requirement. Stage variables in a Transformer will let you do that easily. Ever used them before?

You don't, really. Stage variables can store values from a 'previous' record, however. What are you trying to do?

More details, please. Do you always want just the first 10 no matter how many come or do you always need to process all columns?

Then it sounds like you'll need to involve your official support provider, see what they can do to sync things back up.

Looks like you and "mona lisa" need to talk.

alkanti wrote:Hi, How to prevent writing sequential file,if no records are coming to the input link?

Short answer - you can't. Period. As noted, however, you can deal with (delete) any empty files after job if needed.

Okay... who in the heck is supplying you data in a file that "could be in any format each time"? Sheesh. Now we need a RTM stage.

Can you expalin what "any format" actually means? What might change from file to file?

RTM = Read Their Mind

Have you closed and restarted the Director client and you still see this?