DSXchange

I would like to thank everybody for your suggestions. If there is a corruption in the project, i will not be able to open the project. In my case, i will be able to open the project and run the jobs. I checked in the administrator, the user-limit says 5 and cpu count says 8, but as you said if i exc...

The user limit says 5. I have been using this server for the past 2 months and only from the last 2 days i'm getting this error. Also the server has been shared by multiple projects and the other projects are not facing any 81002 error. Do you feel user limit is the issue??? Answering to ray's qn, t...

I have got the following message only after executing the query (forgot to mention that previously).

MESSAGE...Unable to set remote uid or gid.

If there are more than 5 developers trying to access the DS at the same time....i'm getting the error.

[quote="jzparad"]You also need to wrap the 080012 in quotes

i.e.

'080012'[/quote]

Thanks JZparad
I'm getting MESSAGE...Unable to set remote uid or gid.

What does the above indicates?

[quote="jzparad"]add a semi-colon to the query.[/quote]

I have added the semicolon. I'm getting datastage/sql: character and number types are incompatible in this operation

Help me

Thanks for the reply. How to check whether the dsrpc is running or not? ps -ef |grep dsrpc ---i'm getting root 2518 1 0 01:23:58 ? 0:00 /dstage/Ascential/DataStage/DSEngine/bin/dsrpcd dsadm 20948 20729 0 17:35:50 pts/1 0:00 grep dsrpc Also, SELECT * FROM SYS.MESSAGE WHERE @ID = 080012 - if i run the...

Thanks for all you reply. The real issue is, i have more than 100 columns and need to process around 10 million records and the problem here is i need to check nvl condition for all the columns. one more issue is except key columns i need to concatenate all the other columns into one single column a...

DS Gurus, I have an oracle source table id name1 name2 name3 name4....nameN code 100 sam rob dan NULL ven xyz 101 lob NULL jen lar del ABC I want the output in the Oracle target table to be id names code 100 sam,rob,dan,unknown,...,ven XYZ 101 lob,unknown,jen,lar,...,del ABC Basically, i need to che...

[quote="vmcburney"]I don't know about an Extended Edition of DataStage but the Enterprise Edition comes with parallel jobs and MetaStage.[/quote] I would like to really know the diff between extended and enterprise edition. If anyone provides some input on this, it will be really helpful. ...

Hi,
Thanks for the reply.

I have Datastage V7.5 Extended edition and not enterprise edition. What is the difference between these two?
We have a robust server and it will be extended when it's really required.

Thanks

Hi, I have the situation like this. I have one datastage server V7.5 EE already installed and running in sun solaris with oracle 10g as db. I have a oracle server grid with Terabytes of space and 28CPU's with both oracle server (datawarehouse) and DS Server installed. We have 4 new datamarts coming ...