DSXchange

Hi .... We have a requirement to restrict the access to the folders in a single project for different users. Datastage server is in Windows 2003. Searched in the forum and got some informations like the folder level restriction is not possible. Is this correct? If this is correct is project level ac...

Using a joiner to match incoming and already exists in database based on one key column. But when we give partion as hash with key column as partition key.For some records it is not finding a match.If I remove partition it is working.. or if I give sequential in advanced joiner properties it is givi...

Is this lock is having any relation to the array size and tarnsaction size?

In our job we are using array size=50 and tarnsaction size=100.

Hi All.... I have one multi instance parallel job which uses DB2 UDB API stage to insert in to one table. This job is having a before sql to delete the records based on the where clause. This job is run with parameter values so that for one run it will delete a specified set of records and insert th...

From Group id we can identify.

Hi All We have a requirement to read messages from the message queue in jobs. Since our file is very larget the single file will be coming in multiple files. At a time we have to process messages corresponds to single messages. Is there a way to distinguish the messages from one group in message que...

Another issue we faced is if the job aborts once and if we try to run the sequencer again, the job is giving the erro unable to run the job error at job level.

If we compile the routine and then run , the job is running fine.

In both scenario the job is successfully finished and no warning related to Database.

We ran the same jobs in different environment. There the job got aborted .But we can see at backend the records are getting processed in the table(First records are getting deleted and then inserted)

Hi All, We are using basic transformer in our parallel job to call a server routine. Our job flow is like this Sequential file --->BasicTransformer----API db2 stage The sequential file is having one reject link. In Basic transformer the null check and special character check is done. The special cha...

Thanks for the reply...

In dev and stage we are using the q pasa. In Q pasa we are typing the message. In test if we do and enter for new line, the result file is having the "^M". But this is happening only in test

Hi... We have a requirement to read messages and process the file. The message we are reading is text file. Some times we are getting "^M" at the end of the line. We are using q pasa to put the message. In dev environment we were not facing this issue. But in test environment the "^M&...

Hi all,

If we use the same db2 sequencer to generate the primary key for the one table in multiple jobs which may run at the same time, will create any lock issue or duplicate number generation?

Thanks in Advance

Hi All...

From the previous posts what i understood is the MQ server and ds server should be on the same box for 7.x . Can somebody tell regarding the cluster queue and can we use this for the above purpose?

Thanks in advance

Thank you. It was problem with while loop in the perl script

is there any restriction in running the perl script which uses Net::SCP from data stage?