DSXchange

Hello, I tried some of the suggestions already available in this site, to no avail. Hope someone can help me. I'm trying to create a C++ routine for Datastage usage. Code: $ cat returnValue.c #include <iostream.h> int fnReturnValue() { //dscdscdscdsdc; //return 100; cout << "hello\n" ; ret...

Hello, I have a routine performing the following in Server. * Declare shared memory storage. Deffun SKGenerator(A) Calling "DSU.SKGenerator" Common /ARLookupW/ ARLU, ARFile EQUATE RoutineName TO 'ARLookupW' Open "AR_LU" TO ARFile Else Ans = -1 * Read the named record from the fil...

Thanks Ray.

I couldnt read a big part of your replies, which is due to my choice of membership I'll try and make do with what understanding i got.

Thanks again!

Ray and Kumar, thank you both so much for your views. If I get your inputs correctly, the best way would be for me to design the job in such a way that successful lookups (existing data) and rejects (new data, with new key values generated in Column X) are collected and re-written into the lookup fi...

Hello, I'm curious to know if this is possible. I have a parallel job which does lookup using a Lookup stage. This stage take data from a Lookup Fileset, which is populated in a prior job. I want to make a lookup, and move forward the following way: 1 - If matching key values are found, return value...

yeah, found out what that parameter meant after posting. thanks anyway.

Arnd, yes you are right. The mount points for /tmp and /tmp/dstemp are different: An excerpt of the df -k results: Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd3 2097152 985496 54% 8072 4% /tmp /dev/dslv01 10485760 10156492 4% 26 1% /tmp/dstemp And the uvconfig file values are in...

Craig and Arnd, thanks for your inputs. " then perhaps a permissions problem? " Well, the mount point is owned by another user id, but the access rights assigned are: drwxrwsr-x. Besides, I can see other temp files created by the user id we use to run ETL jobs. "A more generic search ...

Hello. I get the following error messages quite often in Production: DataStage Job 160 Phantom 16617 Unable to open "/tmp/dstemp/capture49282aa" file. Attempting to Cleanup after ABORT raised in stage ALS31VDDSAMM05..LOAD_RJCT_LOG.Read_Hashed DataStage Phantom Aborting with @ABORT.CODE = 3...

I got the same error message after physically deleting the hash file folder created by a job. To get the problem solved, I: 1 - logged into Administrator, and issued the statement "select * from VOC where NAME = 'xxxx'" 2 - Based on the result, I then issued the statement "delete from...

Thanks Ogmios. In fact, the ETL batch in our current environment is designed to complete this job before office hours start. We get hit with locking whenever: - The source files from the mainframe system coming into the warehouse gets delayed. - We go into a catchup mode, forcing the batch to be exe...

Hello, The production environment I'm supporting has this job that does certain things, and re-populates a table on a daily basis. Let's call this table Table_A. The job is designed to select and process records from a source table and write into Table_A. We have inserted an "ALTER TABLE" ...