DSXchange

Dear All, I need to calculate the difference between the current system date and the date passed as an input in months and days using PX job. I have a routine to do the same, but I can't use the same in PX jobs. Could anybody suggest the functions to be used for the same purpose which takes care of ...

Dear All, I have a parallel extender job which reads records from a sequential file. I am using upsert write method with 'Auto-generated update only' mode to update the record. There are 3 key fields defined in the actual oracle database table. Key1, Key2, Key3. My update is based on key1 only, so I...

Dear All, I would like to understand how the transaction handling of database tables of a job can be handled. For exapmple, I have a job with n number of oracle stages in it to which inserts/updates will happen. Can I set some interval to commit the data into database tables at the job level? Or is ...

Dear All, I have a parallel extender job which reads records from a sequential file. I am using upsert write method with 'Auto-generated update only' mode to update the record. There are 3 key fields defined in the actual oracle database table. Key1, Key2, Key3. My update is based on key1 and key2 o...

Hi, Is there any way to handle dynamic queries in a oracle stage? For example, I have a server job say Job1 whose source oracle stage has a query to fetch some number of records. Now, I will run a unix script to execute my jobs starting with Job1 and rest all jobs follow this. Now, is it possible to...

Hi All, I have encountered the following error in one of my datastage server jobs using one Link Collector which results in abort when processing considerable number of records(>100). The same is working fine when processed a few records. Warning: "testjob..testIPItems.LCinToSalesItems1: ds_ipc...

Hi All, I have a server job which uses link collector at the end to collect records from different inter process stages. When I have run the program for small number of records (say 50) the job has been finished with out any issues. Now, when I have increased the number of records to 500 and ran it,...

Hi All,

Is there any solid reason for the above problem? I am also facing the same problem.

Regards,
Srinivas.

Hi Michael,

I have checked for the processes using the commands you have given and there are some processes which are not closed properly. I had killed them explicitly and restarted. Now the problem is resolved.

Thanks a lot.

Regards,
Srinivas.

Hi, I am facing a problem while restarting the DS server. I have Stopped the server and started it back using the following commands. uv -admin -stop uv -admin -start The following error message is displayed. "The connection was refused or RPC daemon is not running." I have made sure that ...

Hi, Could anybody suggest me some solution for the following requirement? 1. How do I get the current system date in TimeStamp datatype using BASIC functions? 2. How can I perform a subtraction of n number of days from a date of TimeStamp datatype? The result should also be a TimeStamp. I have tried...

Thanks a lot Ray.

The code you have given has worked absolutely according to my requirement without a single change.[:)] You have really saved a lot of my time.

Regards,
Srinivas.

Hi, I have the following requirement which I would like to represent using a BASIC routine. A string contains data in name value pairs. The name is of type String and the value is of type numeric. Each name value pair is seperated by a blank. Now, I need to find the value stored for a given key(stri...

Dear All, Thanks for your valuable suggestions. I am revising my design based on your inputs. Also, I have some new queries. 1) I would like to know when the combination of Link Partitioner and Link collector are used. Can that be used for the scenario I have? 2) If I proceed with processing the row...

Hi, I would like to create a server job in DataStage 6.0 on SunSolaris which takes fields from a sequential file, process it using different flows and gets fields as output all belongs to a single record. Could anybody suggest how I will merge all these fields into a single sequential file. The comb...