DSXchange

The first thing that popped into my mind was to use a Document Database, maybe something like MongoDB. I have not used them myself yet but have read about them enough to think that's what they're designed for... just cram miscellaneous stuff in there.

Have you tried the Index() function in a Transformer stage?

"You guys talk funny! Say more words!" -Patrick Star

Never heard of it before. What does IBM Support tell you?

You could use a DataStage job with ODBC Connector stage to read the DBF file, assuming you setup the proper ODBC driver, and write to a CSV file. The only purpose a shell script could serve in this case would be to call the DataStage job.

Server jobs should compile successfully in any version.

Perhaps you have a local environmental problem with your setup. What error are you getting when compiling server jobs?

Is your project protected? That would prevent you from editing or compiling anything in that project.

Open Director and start a job monitor.

Congratulations on your retirement, Franklin. We'll miss your words of wisdom around here...

- Eric

If you're saying that you cannot, for some reason, split the existing design into two jobs (which seems like the most logical thing to do...), then I suppose you could change the Oracle Connector target table to a temporary work table that still gets truncated no matter what. Then you could perhaps ...

Perhaps it has to do with Information Server security and browser sessions. It should display OK if it is clicked and opened in an existing session but it should fail if a new browser session is started where you're not already authenticated, although it seems like it should at least give you a chan...

I would create a new project with a copy of all the old jobs and rename them all in the new project. Just leave the old project with old job names and job logs alone. Mark it as protected and change the project permissions if needed. Keep it around for reference.

I noticed a new IBM technote published recently. I don't have the link handy at the moment... Has anyone had a chance to test this to see how it affects job duration, CPU, and storage? Problem: Add support for dataset compression. Resolution: Add the environment variable APT_DS_COMPRESSION=1 to enab...

Even years ago I said this query syntax was the "least/worst-ever-documented, ever." The DStageWrapper and the DirectoryCommand tool options are discussed in these topics. http://www.dsxchange.com/viewtopic.php?t=157954 http://www.dsxchange.com/viewtopic.php?t=154942 If you have explored t...

I think you would be fine running a server based on the documented minimum system requirements, plus 4 GB additional RAM, and enough disk space to land all your data plus some extra free space. You could also check with your IBM sales rep, as they can put you in touch with the IBM group that does si...

Today DSXchange is quite responsive. I can't recall the last time it responded quickly upon clicking each link. Whatever you all did, please make a note of it and do it more often!! :D