DSXchange

Thanks for the prompt reply. Sure I also though abt the same idea..but I was wondering whether there could be any other way of doing this? Is there a specific way by which we can identify a sequence job, I mean not by the name but any particular code or something by which DS internally differentiate...

Hi, How can we get the detailed log for the failed job(s) in a sequence. Thru Unix Script: Currently we get the detailed log for Seq job by getting all the logs between the first & last event id using the logdetail command (prior to run we get eventid+1 and the last event after the run). For the...

Thanks for the prompt responses..it worked.

Hi, OCI --> TRN --> OCI I have a design where I read from an Oracle table (Stg) and load in the another Oracle table with a Transformer in between. The only thing this job does is to load the tgt Oracle table with a Surrogate key from an Oracle sequence. I am using the SeqName.NextVal as part of the...

ArndW wrote:rename a file or a column? I can't think of another way to do this - but perhaps someone else might add an officially supported method to this thread. ...

My mistake. it is renaming a column name in the file set.

Lol - tickets where what we called problems in the support group; it is better to just call them "problems" here. I don't know of a method to just change the DDL of a fileset containing data. You co ... I was able to rename a file by simply editing the fileset (fs file). However, i am not...

I have a file set where I want to change the column name of a field without disturbing the data. Is there a simple way where I can manipulate on file set.

In other words, can i rename a fieldname in the fileset?

thanks in advance for looking into the ticket.

Yes. It resembles like that only. But I am unable to open in internet explorer. Please find the structure below. <?xml version="1.0" encoding="UTF-8"?> <!-- - Generated by Ascential Software Corporation, DataStage - XMLOutput stage - - Wed Oct 24 05:16:22 2007 --> <Performance> <...

Hi All, I need help on this. I have a XML file as target. The file is created. it is opened by editplus.But i need to open this in internet explorer. But it is not opening. It is giving error like The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error ...

well the query is all right..No New line issues and we are not using the Before/After tabs..
What else could go wrong

Hi, I keep getting this message and the job Aborts DataStage Job 118 Phantom 29459 Program "*DataStage*DSR_LOADSTRING": Line 147, Read operation failure. Program "*DataStage*DSR_LOADSTRING": Line 151, Read operation failure. Program "JOB.1488270624.DT.1447836505.TRANS2"...

What is the diference dsjob -logsum & dsjob -logdetail?

We r uisng dsjob -logsum when we want to get the logs for all jobs in a Sequence..I noticed it does give the first line in the log for each eventid but doesn't give the full multi line message..which is Imp when the job fails..

Strangely I ran the same MI job again and it did not throw any Unix error..

It seems it is having problems getting the start and end evenit for the job, that is when it throws the error..

We get all this info & r writing this to a log file ..all via shell script

I renamed the job to reduce length to 18 chars..I also checked the values for Parameters being passed in Director log..it looks ok Is it bcoz of a Multiinstance job as I have never got such a warning for a standard job... The director log starts from eventid - 306 where as the Unix error shows upto ...

Ray, The value being passed is a table name as Instance id..also all other parameter values being passed are fine too(via a param script file, runs well for other jobs) Is there a Max length for the job name (I think 50) including the Instance Id? Current job name length is 24 chars and the max leng...