DSXchange

What the responders have alluded to, but not stated explicitly, is that a sequential cannot be read from and written to at the same time. This has nothing at all to do with DataStage but is an inherent limitation of the sequential file type on all operating systems. So the suggestions all try to wo...

Hi , I have a situation wherein I need to use the same Sequential file as the source , do some transformations and then load this data into the same sequential file which will have the updated data for the next run. Please help... :) Create 2 jobs ,in first job take one temporary file as target and...

ray.wurlod wrote:You're in a very bad situation, then. How would you do it with any other software? Seriously - all you can do is write to a temporary file then, once the job has completed, delete the source file a ...

I thought of this, but I was thinking if this is possible with DataStage...

Hi ,

I have a situation wherein I need to use the same Sequential file as the source , do some transformations and then load this data into the same sequential file which will have the updated data for the next run.

Please help...

So what changed in your environment? Did you chek to confirm and then concluded this is not a memory issue but something else? Also, the job has been performing fine earlier with similar amount of data. No change has been made to the environement... Could you please could you please explain what yo...

Segmentation fault can be because of many reasons like - running out of memory or there may be more than the program can handle ... For more refer THIS link. The data being transferred here into the Sequential file is hardly 33MB in size...I don't think that the job is getting aborted because of ru...

My job carries out a simple task of loading a sequential file from an ODBC Stage. It is getting aborted giving the error message as Contents of phantom output file => RT_SC256/OshExecuter.sh: line 20: 16908 Segmentation fault $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1 Para...

ray.wurlod wrote:

prajish_ap wrote:Can anyone please tell me what this trim function actually does?

Trim(oconv(date(), 'DMD[2,2]')," ","A")

Nothing at all in a parallel job. ...

The Developer has used the function in a User Variable Activity Stage in a Sequence Job

chulett wrote:Trims 'A' for all " " (spaces) from the string created by OConv. Test your derivation in the Manager with and without the Trim() to see. ...

I actually wanted to know as to what this OConv function does.. I should have been more specific with the question .. sorry about that..

Can anyone please tell me what this trim function actually does?

Trim(oconv(date(), 'DMD[2,2]')," ","A")

INSERT,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.TableA' with unique index 'XPKTableA_SEQ'.