DSXchange

Hi Vincent & Arie, The database is in the same machine as the DS server. The lookup data for one source will not be changed during lookup process for that source. In the lookup table, SOURCE_ID is part of the key. During lookup, if we're going to use hash file, one hash file will be used for one...

Hi All, In one of our job, we need to detect the new rows that come and generate the surrogate key for those rows. The thing is that, the 'lookup' table are quite big, more than 1M rows. The data can come in multiple sources, and we have a field SOURCE_ID so that for each job that handle different s...

Hi Craig,
How to 'go in and edit' the DSSendMail routine?
I couldn't find any way of doing it.



Regards

ND

I revised, I just read the whole help, what you mean I need to create a link from /usr/lib to /usr/sbin
I've tried, but I don't have the permission to create the link [V]
I will ask the admin to do it.

Thanks


Regards

ND

Hi Luca,

Thanks for your respond, but can you be more specific? I've looked at the 'ln' help, but I still don't know what is the problem, and what kind of link that I need to create.
Can you be more detail please? My UNIX knowledge is almost non existence [^]

Thanks


Regards

ND

Hi all, I am trying to create a job with an After-Job Routine to Send Email for notification. I's using DStage 5.2 on Solaris. Everytime I run the job, it always fail. I tried to test the DSSendMail function by using DSSendMailTester Routine, the same error come: TEST #1 ******* Arg1 = EndyL@bot.or....

Hi there, You can use Folder stage to get all the filename from your directory, and stored in a hash file (Job A). And then, use another job (Job B) to read the content of the files and process it, use job parameters for all the filename variables. Then you need another job control (Job C) to do a l...

Thanks Ray & Craig...

I prefer to do it vertically, the Waterfall way [:D]

[:o)]

Regards

ND

Thanks Craig,
It works Fine now...




Regards

ND

Hi all, I've manage to solve the problem. I was using too many OCI stages, and the same database & table was reused in different Shared Containers. I changed the design of my job and container so all of them will only write to one OCI stage and read from one OCI stage, and it works fine and fast...

Craig, I agree with you. Previously I use so many OCI stages just to open different tables from one database. And I keep getting this 'Abnormal Termination' message. But after I redesign the whole job to minimise the number of OCI stages, it works fine and faster. I have to change my other jobs to m...

Dear all, What is the advantage/disadvantage of using just 1 OCI stage for input/output to/from one database? Let's say I'm only accessing one database in one job. But I have to read 4 tables and write to 2 tables in that 1 database. Will it be better if I only use 1 OCI stage with many links? Kindl...

Ray, I've set the 'Rows per transaction' to 1 in both stages. The same thing happen. ContB can update Control Table and Insert to Log Table, but ContC can only update Control Table but cannot Insert into Log Table. The same thing still happen when I change the Array Size to 1 or other numbers. The m...

Hi,

Just to revise my previous reply, We're using OCI8i version 4.0

And I just realised, the job can update the Control Table for both ContB and COntC, but the cannot insert a value to the Log Table for ContC. But the Value for TableB on ContB was inserted to the Log.

Kindly help


Regards

ND

Hi Ariear and Ray, On which stages do I have to make the array size to more than 100? I am using OCI 8 (I think), because we only used the one that come with the installation cd. Just to explain aout my job design, Table A is mapped to Table B and Table C. But everytime we finish inserting any value...