DSXchange

Hi

How about trying distributed hash file using data segmentation? I hope this will be another work around.

Cheers
Pramod

Hi, I am trying to understand how to select optimum values in uvconfig file so that different projects with different architecture can co-exist in the same server. Overview: One of project extensively uses multiple instance jobs while the other projects process huge volume of data (approx. 20 millio...

Hi

I have the following requirement

Input Data:

a|1
a|2
b|2
b|3

Output Data
a|1,2
b|2,3

Hi Please give me a sample output of the merge file. I am not sure whether u want the merged file to look as: $ cat merge 0,data0 0,data0 0,data0 1,data1 1,data1 2,data2 $ cat file1 0,data0 1,data1 2,data2 $ cat file2 0,data0 1,data1 $ cat file3 0,data0 $ paste file1 file2 file3 > merge thanks Pramod

Hi

jobpid= DSGetJobInfo (DSJ.ME, DSJ.JOBPID) return me "0" always.. I am not sure whether this is PID right
Can i use this jobpid to kill a job from unix ?

Thanks

Please check which user id is used to edit these jobs..

Thanks
Pramod

Assume I have main sequence which consist of sub sequence 1 ,2,3. Each sub sequence has 5 different jobs that runs. Each jobs are stored in different categorty. I would like to know how will i get information of the summary of sequence which job under which subsequence got aborted. Is there any DS c...

Hi

We can also write a shell script which invokes this DS job.Schedule the script on hourly basis in CRONTAB.


Thanks
Pramod

I am wanting ao add leading zero's to a numeric field if it is not 10 characters long. I know the FMT Function is used for string fields but what can I use for a numeric field ? Alternate Way: If LEN(NUMERIC_FIELD) < 10 then oconv(NUMERIC_FIELD,"MR%10") else NUMERIC_FIELD Hope this helps....

Hi

Please Check your user id and password for DB.

If ur using ODBC stage to connect to DB, click Get SQL Info after providing the DSN, user id and password (in parameter form).
Please Check whether the parameter has been typed correctly in the stage?
#DSN#
#USERID#
#password#

Hi Try this out Sequential File ---> Transformer1 ---------------> Aggregator ----------------> Transformer2(count >1) --- > seq with Duplicate records Transformer1 ========= Define a column called count assign value 1 to all the rows that u read from the sequential file. In the aggregrator group by...

Yes u can append a lookup file. 1. Create Hash file which reads from the input sequential file. This hash file is used as a reference. 2. Create a new job which checks for the new records against the above hash file. If the record is new, then it is inserted into the Hash file. While designing the a...

Hi Where do u get this error? Please elucidate. Thanks Pramod Hi everyone, can you help me for this bad error? main_program: Accept timed out retries = 56 Accept timed out retries = 55 Accept timed out retries = 54 Accept timed out retries = 53 Accept timed out retries = 52 Accept timed out retries ...

Ray, 1. A client was connected to DS server, when it was brought down. 2. After sometime the DS server was started. When client was trying to connect to the server it gave RPC daemon failed. 3. We killed a dsrpc process (fin_wait_2) thread 4. after which we tried to connect to the DS, it gave the er...

Hi
One good practice in DS Server job design is to sort the data and perform all the aggregation operations in ODBC Stage itself.

Thanks
Pramod