DSXchange

Welcome aboard! STP stage and ODBC/OCI stage SP usage is meant to stream data either in or out of a database. If the SP "does something" like grant permissions or juggle data around, then you want to use a command line execution to invoke the SP. Since you're on Unix, the ODBC driver will establish ...

How could you distinguish 2005111 from 2005111? Is it 2005-01-11 or 2005-11-01?

Why not version builds at a project level? For every major build, start a new project. For minor patch migrations, just overlay.

There is no other place, unless you can buy a company that already owns a license. There are no developer licenses, student discounts, or trial copies, unless you participate in a sales call from IBM/Ascential and they think you're serious about buying. Then, maybe they'll give you a 30-day license.

It's unfortunate you're not a Premium member, because I posted a function yesterday that shows how to write a function that reads a text file into a COMMON array variable and use that as a function lookup. It is fast because the file is read into memory the first time the function is used, then for ...

The WHERE causes the database to discriminate or search for data, which may or may not use indexes or partition elimination to more readily find the result rows. The order by causes the entire query to completely execute and gather all result rows before sending anything to the requester, in this ca...

Are you using this in replace of a hashed file lookup? That is a bad idea. I thought you were just parsing a file one time as part of some job control or something. If your goal is to find a row in a text file as part of transformation logic in a job, put the text file into a hashed file and use the...

Welcome aboard. It's absolutely impossible to tell if your Oracle query is slow, the hashed file is improperly sized, or your transformation logic is slow. We also don't know how many rows of data you are processing. Breakup your job and write your Oracle results just to a text file with no transfor...

Running 2 jobs for each row in a spreadsheet will take a long time. If you could use job instances you can run many copies of your process at the same time. Or, figure out how to run for everything just once. I don't know why you have to run in a loop like you're doing. It's not very efficient, but ...

Are you sure you're at the right Service Pack and Windoze configuration?

The (-14) [Timed out while waiting for an event] issue is quite common and has been discussed for years here. It's something to be "managed", but not resolved, from what I have seen. Just yesterday Arnd talked about a custom patch written for his specific customer to extend the timeout value, but I'...

Are you Administrator or just a user? Have you restricted permissions on the project, or user groups in anyway?

Why do things so difficult? Just use DSExecute and use "cat /yourfile" as the command. The screen output variable (3rd argument) will return the entire contents in an array. To get the number of lines, just use cmd="cat /yourfile" CALL DSExecute("UNIX", cmd, ScreenOutput, Ret...

Get your Office install CD. Sorry.

Is this a new installation?