DSXchange

I figured it was you guys, I didn't know you went the Windoze route. When you setup the DSN in the ODBC data sources tab on the Windoze server, you picked the ODBC driver for progress. A lot of the ODBC drivers have a bunch of timing values you can monkey with. Arnds suggestion to put a constraint o...

If your Progress server is hosting DataStage as well, you could be getting into some resource contention. If they're separate hosts, then you're getting into some communications jam/timeout between machines. When I've seen this problem before, the fix was in the ODBC connection manager and you have ...

Are you talking about runtime errors or compilation errors or designtime errors? Your question is too broad. Runtime errors are limited to either design errors (filename is wrong, file format is invalid, sql doesn't work, etc) or DS bugs. The list of design errors is nearly infinite. The list of com...

Search the forum for "DSExecute", you will find a lot of code samples. You can read about it in your DS BASIC manual.

Its main purpose is to clear out locks where the underlying process has died. Given the volume of posters looking for ways to release locks indicates the daemon is not too quick on the draw for finding these ophaned locks and releasing them. Since you can do it yourself much faster, why wait or use ...

The deadlock daemon is not needed. Back in the day tech support used to tell customers take it out of the services startup script because it would go bonkers and chew up a cpu. You can kill it the process, and remove it from the startup script.

eoyylo wrote:Is it possible to use a DataStage Routine in the "WHERE clause" of an ORAOCI8 Plug_in?

No. Either a job parameter or you need to put the value into a work table and join to it.

I'd be 99% sure quotes are being messed with by DS when it tries to execute the command. Put the entire command into a shell script and execute the shell script. Pass parameters like the credentials to the script and have the script manage executing sqlplus appropriately. I do this method and it alw...

You need to state your database. If you're using Oracle, then you don't even need to use DataStage. You need to learn sqlldr. It has every piece of functionality you have described, plus it uses native connectivity and has the highest performing loading rate for Oracle. You can use sqlldr to create ...

If you have the before and after in dsx files, it could be possible to go thru line by line and visually inspect them for differences. Otherwise, there is no mechanism to compare two jobs to each other for differences.

You can, should you is a judgement call. It's more complicated than simply using sqlplus wrapped in a shell script. You don't need the shell script as you can just use DSExecute and run sqlplus, but you get into the need to pass in a log of information on the command line. It's easiest to write a sh...

Try using this: *Loop through Source Parm Dir to pull the most recent file Call DSLogInfo("Setting up Dynamic Array Loop to pull the most recent file from Source file directory", "Job Control") * This is going to the mapped drive and sorting the zip files Call DSExecute&#...

Sure, just write a shell script and use the DSExecute API to run it. In the shell script, put the necessary steps to connect to the instance, execute the stored procedure, and then verify results.

Since executing a system command returns screen output into an array, to process the array in reverse order is simple. Just start at the end of the array and work backwards. Call DSExecute("NT", "dir /b /o /d \overthere\thesefiles", ScreenOutput, ExitCode) NumberOfLines=D...

There are only two ways to talk to any database: using native database connectivity or third party. ODBC is third part driver connectivity. All ETL tools have some mechanism to either use native connectivity supplied by the database manufacturer or support use of an ODBC driver. DataStage can use bo...