DSXchange

Is there an option in DataStage for when the DDL is created to create that in character instead of byte?

Ok. So there is not any way I can just simple tell DataStage to truncate the data in the column is it exceeds 255?

Is this an option in Oracle or DataStage itself?

Yes I am using the NLS map MS1252. I noticed the columns are defined as bytes also. Is there a way to define the columns as character instead?

Here is what I currently have in the transformer:

OutputSRLink.DESC_TEXT[1,255]

I also tried left(OutputSRLink.DESC_TEXT,255) and still get the error message.

We have recently changed our database to 10g and now I am getting an error message: extServiceRequest..Transformer_1: ORA-12899: value too large for column "SBLMART_DATA"."EXT_S_SRV_REQ"."DESC_TEXT" (actual: 302, maximum: 255) Is there a function to trucate this data to...

kduke wrote:I think you need to install the DataStage client not just copy dsjob.exe.

I have the client on my machine. I was just trying to use the command promp.

Dang, can't find anything other than posts mentioning the fact that you can do this if you put dsjob and 'associated libraries' on the other machine. Suggestion: copy dsjob.exe over to the other machine, execute it from a command prompt and see what it complains is missing. Hopefully it's as simple...

If they have the client software installed, or at least the minimum components needed for 'dsjob' then sure, they can. That minimum is documented somewhere, from what I recall. Could you elaborate alittle on where I could look please. I have just started using DataStage and do not really know alot ...

The job will always run on the server. You can initiate it from your desktop, however, using dsjob just like you would from the server command line. Or via the Director, of course. I am trying to allow someone to start a DS job remotely. I was just wondering if I could run the job through a command...

kduke wrote:You could remote execute dsjob.

Could you please explain how to run a job remotely? I am wanting to run this on my desktop vs. running this on the actual DS server. Is this possible?

IBM support is providing the documentation I need to move the xmeta node.

Thanks to all for your responses.

Ray - thanks. I was checking out the xmeta database (oracle rac cluster). I had to set it up for a single server of the three in the RAC and of course that's the only one they are having problems with. How can I change my setup to point to a different xmeta server (same database). Currenly points to...

I was using the account yesterday afternoon - no changes to passwords or accounts. When I tried to login today I got the error message: Failed to authenticate the current user against the selected Domain: Fail to get groups for user [parkeca]: Unable to begin a transaction: [Error opening repository...

Was this resolved - I am experiencing the same error message - no passwords were changed.