DSXchange

Set up a system DSN using odbcad32.exe (the ODBC Administrator, also accessible through Control Panel).

Two Promote Subrecord stages, then.

That was already considered but there is a concern about the size of the detail file so the OP was looking into... alternatives, techniques that don't require duplicating the data, even temporarily. Look carefully at my redirection. The detail_file is also the target file. Only the header and trail...

HI Ray... Curious, as I've never seen this error.......did it matter what bridge you were trying to use? Ernie I don't believe so - I tried three. But this was a brand new installation of Windows Server 2003 with NOTHING else - no Office, no nothing. Downloading MSXML Parser 4.0 solved the problem,...

marionpt wrote:In our version (8.0.1) there is no Soundex, we only have Reverse Soundex (RVSNDX) and NYSIIS.

You DO have Soundex - it's just that the rule set you're using does not use it to generate any matching field. You could create a custom rule set that does use it, if that's what you want.

Yes, you can use a server job with a Folder stage.

You may be able to do something with XML, but that will require a bit more thought.

Can you change the job design entirely? Process all records, but write three files (the header, the details and the trailer). The header and trailer could well be in /tmp. In an after-job subroutine assemble the three into one file and delete the temporary files. cat header_file detail_file trailer_...

New? With 425 posts? The structure of the Repository is undocumented and unsupported with complete metadata - this was a deliberate design decision of the vendor. There is no consistent way to find table definition information in the DS_JOBOBJECTS table - as I noted, the record structure varies acco...

Some telnet clients do not allow passwords to be redirected. Check whether this is the case for your telnet client. Does your script include a "here script" for the telnet session?

Danke.

I discovered that, but wonder why IBM does not ship it with IIS.

There's a check box in the exporter that allows the DTD to be included in the file.

What's in the History section of Version.xml for Information Server? In particular are all installations "Success" or are some "Partial Success"?

satyanarayana wrote:convert into julian date and minus number of days you want and reconvert into date format.

How do you handle the time component in this "solution"?

Yes, I am totally sure. I know more about UniVerse than about DataStage (and that's a lot). I was answering Craig's question - it had nothing whatsoever to do with parallel jobs or the workings of the parallel execution engine, the answer for which had already been given.

Well I still don't know whether it's supposed to have been installed with Information Server, but MSXML 4.0 sp2 is still downloadable from Microsoft. So I did that, and Import/Export Manager seems to be doing its thing now.