DSXchange

ray.wurlod wrote:Because it needs to determine/verify from this table how the partitioning of the table is organized (or, indeed, if there is any). ...

thank you Ray. Needed to confirm that same before I go to DBA.

Hi all,

Why does the user ID under which DataStage connects to Oracle require select permissions to sys.dba_extents?

Thanks.

Hi, I need to retrieve data from a column with LONG datatype. I tried the suggestions in the forum like used varbinary. But I get the following error main_program: Internal Error: (colDesc):orautils.C: 1714: getColDesc failed. Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are i...

Hi, We have a requirement of reading 30M rows from a flat file, looking up a table with again 30M rows and loading it to the target table. We intend to use datasets in parallel extender. Hopefully we can partition the process so as to improve performace. Could anyone comment on the size limitaions o...

Hi all, I have a queue that have 1900 messages in it. But when I try to READ more than 1000 messages at a time the job aborts with the following error messsages Reason code :2024 Any idea why? Note :There is a message limit of 2000 messages on the queue. But like I said there are only 1900 messagesi...

I don't know of a comprehensive, published, and supported list of all error codes possible. There's server side and GUI error codes, is there one in particular we can help decipher? The server side error codes. for Datastage server jobs eg 530 Login incorrect. 256 I think its for incorrect file for...

ml wrote:I think that this kind of codes are comming from your DB.

I do not think so. I do not use any DB. its flat file to flat file.

Hello,

Where can I get a consolidated list of error codes and description that Datastage generates?

eg. error code 256 for data mismatch

Thanks

ArndW wrote:Sonia,

There is a "multi-client manager" on the installation CD which does just that.

oops. I need to have the administrator rights to my pc, to do that. Right?

Hi, I have been working on DS 7 server installed on a Windows OS machine. I now have Parallel extender server of version 7.5 installed on a UNIX box. 1. I believe i need a DS client of 7.5 to access the parallel extender server. Am I right? 2. Is there any way of having both the verions of the clien...

Installed the patch. It works. :D

Thanks a million, all.

They mispoke - version doesn't matter. If you think you have the SP2 problem, get the patch, it will fix you right up. If that doesn't help, post back and we'll dig deeper. Sorry this may be a stupid question. :? But were you all referring to the OS on the server or the Client. If its the client ye...

vcannadevula wrote: If you are using the Windows SP2 with the DataStage 7.5 , it an known bug. You have to get a patch from Ascential.

I use DS 7.0.1!!

I did reinstall the client but no difference.

Titto wrote:Hi Arndw,

Tested the function and it is working fine now.
Now need some hlep how to pass values to Job Parameters.

1. get handle for job "DSAttachJob"
2. Set parameters for the job. One of the previous post talks about "DSSetParam".
3. Then "DSRunJob"

Hi all, I am having this strange problem, since a couple of minutes ago. I am unable to open the properties page of the job activity state. The page where the parameters are set, the triggers can be etc. :cry: Anybody has any suggestion to fix this problem other than to reinstall my datastage client...