DSXchange

In the summary log of the sequence we are not able the get the status code. For example
status = 1 (Finished OK)
status = 3 (Aborted)
With version 7.1 we are getting. But version 7.5 we are not getting.

Hi

Currently we are upgrading 7.1 to 7.5 version. In version 7.5, in sequence we are not getting status code of the jobs involved. Could any body throgh some input to get status code of jobs in sequence.

thanks
Nivas

Multiload uses some work tables. When we run Multiload in parallel mode then each process will try to create a set of work tables with same names that leads to job abort.To fix this we have to run Mload only in sequential mode. Multiload is itself fast efficient loading process.It doesnot need addit...

run the multiload in sequential mode

Hi
The following way better. Apply Max after Nvl
SELECT 1 AS ID, MAX(NVL(COL1,0)) AS MAXNBR FROM TABLE1

Titto wrote:I got it correct, and working fine

I used following SQL

Code: Select all

SELECT 1 as ID,  nvl(MAX(COL1),0)  AS MAXNBR FROM TABLE1

If are they any other way please let me know!

Thanks,

Hi Eric My operating system is HPUNIX. So with Samples\TrxExternalFunctions\HPUX examples I was able to use Static Routine. When I try to compile job with Dynamic Routine I am getting the following error. So can you help me how to fix this. I followed the document help exactly. ThankYou Nivas *** In...

Please post the actual error(s) thrown by the compiler, let us contemplate whether or not it is helpful in diagnosing the problem. First I run the following command to create an object aCC -O +z -c Sri_Funcs.c -o Sri_Funcs.o Then I run the following to create a library aCC -b Sri_Funcs.o -o Sri_Fun...

Hi
Any body explain the steps behind creating a parallel routine with object type library.

thanks
Niavas

Hi

The answer simply is pass more records. Please post topic with more clarity.

thanks
Nivas

kwwilliams wrote:I want to do to increase the records for next run.
Is there any way to increase the load for next run

Hi Ultramundate

could you explan how did you use MultiLoad in parallel mode. In the node map constraint did you select one node only. Could you please explain how did you set the MultiLoad plug in properties.

thanks
Nivas

Hi I compiled the c file for example myfile.c as following to create myfile.o aCC -c +z myfile.c Then I am able to create and use parallel routine with object type object. Then I compiled as follows to create myfile.os aCC -o myfile.o +b myfile.os This myfile.os is in /apps/edw/dev/bin path Now I cr...

Hi

you can continue Basic routines in job sequence.
If you are going to call any routines in parallel jobs then only you need to convert them to Parallel routines.
I don't think server jobs simply go away in near future. IF data volue is not high server jobs are the right answer.

thanks
Nivas

Hi ArndW

Now I am very clear on the relationship between config file and processes.

thanks
Nivas

thanks
Nivas

Hi Our platform is HP-UX B.11.11 U 9000/800. I am changing the configuration file through Datastage manager. I am providing the configuration file name to the job through $APT_CONFIG_FILE. I am expecting the job should take the new configuration file in which there are 6 virtual nodes and should cre...