DSXchange

Yes, I see what you mean. Bit tricky that. Obtainable readily enough within the Datastage environment, but from outside... Just curious as to why you need to run the sql query from the Dos prompt. If you can describe why you need to do it that way, there may be another solution. Thanks for help KIM!...

Just curious as to why you need to run the sql query from the Dos prompt. If you can describe why you need to do it that way, there may be another solution. It is a little program written by me in VB. They may post source code for something like this in a members only area. If that would be somethin...

We have a routine that will update a DSX file automatically with stuff like the addition of a subroutine, but your idea of a 'wrapper job' to run jobs individually is a good one, Thanks, Hmmm... not only will you have to add that to every job, but there will be times when you'll want to run a job ma...

Thanks, the before job subroutine sounds like the solution, that way Production has full funtionality, but cannot run jobs we don't want them to run. cheers, Create a before-job subroutine that checks whether the job is being run under control. If it is not, set the error flag (ErrorCode argument) t...

Thanks guys, Yes, I was hoping for an easy solution, but it looks like I will have to do as suggested, build some kind of display process that will just display the log files. Thanks all, Cheers Yeah I also do not think that there is a way but if u want monitoring team to just see the log files you ...

We are putting in place an automated Job running system, and as such, we do not want to allow the production monitoring team to run a job on it's own by mistake. We do want them however to be able to monitor job logs so that they know if something is wrong, and can inform us. Perhaps there is a read...

For anyone interested in the actual syntax, here it is, as I entered it on my PC. It works just as well on the server at the office: CREATE TABLE SQLEMPS DATA C:/Ascential/TestStatic/SQLEMPS DICT C:/Ascential/TestStatic/D_SQLEMPS (TYPE 2, MODULO 1, SEPARATION 1, EMPNUM CHAR(10) NOT NULL PRIMARY KEY,...

Thanks Ray, Will investigate the CREATE TABLE option further, I didn't realise it actually created Hashed Files. The "DSU." prefix tells us that this routine (DSU.CreateHashFile) was created at your site; it is not one "out of the box" in DataStage. So if there's no source code, ...

We have some 3000 files to load, and would like to make sure that they load as fast as possible. We have done tests with the default Universe Dynamic files and they tend to slow down quite markedly if we are trying to load large quantities of data. Therefore we plan to create static hash files with ...

I have read the previous posts from 2005 on this and was wondering if the Datastage function DSU.CreateHashFile could accomplish this. I notice it is in DSU_BP.O , but of course there is no source code, so I have no idea what arguments it takes. Anybody have any idea where some documentation exists ...

This has now been resolved, (though not by me). Apparently production were using the wrong Project parameters, (I have no details of the parameters they were using, sadly). I will make a follow up posting when I find out exactly what happened. Meanwhile, thanks for everybodys comments, much apprecia...

We have upgraded Oracle to version 9 and Datastage from V6 to 7.5.2, and a job that used to work, now has the error: ds_ipcopen() - shared memory file /tmp/PRODACHD.AchMajErpExtrCommLig..RGL_1-RGL_2 is wrong size The jobs name is AchMajErpExtrCommLig, and RGL_1 - RGL_2 are transformers in the job. U...

We have upgraded Oracle to version 9 and Datastage from V6 to 7.5.2, and a job that used to work, now has the error: ds_ipcopen() - shared memory file /tmp/PRODACHD.AchMajErpExtrCommLig..RGL_1-RGL_2 is wrong size The jobs name is AchMajErpExtrCommLig, and RGL_1 - RGL_2 are transformers in the job. U...

Even though it's not related to this problem, DataStage BASIC dimensioned arrays do have an upper limit of 65535 elements. Someone might be searching for this one day. Dynamic arrays may have an arbitrary (and unlimited) number of elements, until you run out of memory. Thanks Ray, I didn't know tha...

Perhaps the array size referenced here is for your transfer buffer to/from the database. Yes, this looks like some sort of custom algorithm used to set the Array Size option in a database stage, specifically the DRS stage from the comments. Nothing to do with BASIC arrays but that passive stage opt...