DSXchange

Im not sure exactly what you are trying to do, but we have used the CHAR(010) function to insert new lines. Thanks! Mike -----Original Message----- From: Victoria.A.Oliver-Macklin@gsk.com [mailto:Victoria.A.Oliver-Macklin@gsk.com] Sent: Monday, October 28, 2002 9:11 AM To: datastage-users@oliver.com...

I have a field in a table which currenly has comma seperated values. The target table where this data is to be opied to needs to have each item on a new line. Is there a way to put Carriage return in using transform? Ie to get item1,item2 to look like item1 item2 WHat can I put in a convert function...

There are several possible causes of abnormal stage termination. It is usually a Transformer stage, but may be any active stage type. One of the more common causes is an attempt to process a string (via a GCI call such as $DS.UVPut) that is too large for the declared structure size. Usually, when an...

Need a little bit more information. Were you creating a hash file with this source data? Did this hash file exceed 2.2 gigabytes? You can check this out by going to the directory where you created the hash file (if you defaulted to the project go to the project directory) and look in the subdirector...

Hi ppl, I had job that actually returned an error, this job is running since a long time. The message that is not very clear - "Abnormal Stage Termination" The only different that we have is the number of row processed, now it process more than 2 Million records, the size of our input file it only h...

Download a version available for free for subscribing to DataStage Forum at www.tools4datastage.com (a site well worth knowing about). With CompileAll you can select which jobs to compile, and it reports the status of all jobs (compiled, not compiled, running). > ----- Original Message ----- > From:...

I think youve found a bug. I tend to use 72 rather than 80, and will now go back and check whether the symptom shows up at that setting (its not something Ive looked for in the past). You should report this to your vendor or to Ascential as something needing to be fixed. ----- Original Message -----...

There doesnt appear to be such a mechanism within the Red Brick stage itself. It just triggers rb_tmu (via a script/bat file) and ignores the result. What you could do is disable the automatic execution by the Red Brick stage (it still creates the files needed), then run rb_tmu as an after-stage or ...

Hi, I have used it and it works fine. Check out the site www.tools4datastage.com! ;o) Regards, Riccardo ----- Original Message ----- From: "Fan, Yuzhou" To: Sent: Friday, October 25, 2002 6:40 PM Subject: Compile All > I read some old posts. It looks like certain version has built in > routine can d...

I read some old posts. It looks like certain version has built in routine can do compile all the jobs under a project. Is anybody used it? We have version 4.1 on win2000. Thank you! Yuzhou Fan Information System Application Specilist II Data warehouse( IMS data->datastage ETL tool->oracle8i) yuzhou....

Hello, I have a problem with Reporting Assistant. When a propertie is longer than 80(predetermined) caracters in DSProperties appears: LINE NUMBER PROPVALUE 1 1 - 80 2 82 - End In version 5r2 a caracter(81) is losted. Itll must be (like in previous version): LINE NUMBER PROPVALUE 1 1 - 80 2 81 - End...

Denzil, I have written a routine that takes the Redbrick log after load time and puts its contents into the datastage log. This job will check the log contents for sign of failure and sets the log entry accordingly (in your case fatal). You could use this same approach basically open a sequential fi...

Guys I have a problem with the RedBrick bulk load facility. Job "One" loads with the bulk load facility, using the rb_tmu utility. Now, regardless of how that tmu (table management utility) exits - whether max rejections are reached, or if a segment was filled before completing the load, the datasta...

Fixed - Thanks -----Original Message----- From: ccezon@bancozaragozano.es [mailto:ccezon@bancozaragozano.es] Sent: 25 October 2002 09:48 To: datastage-users@oliver.com Subject: RE: RT_STATUS Record for wave 22 not found. Hello Regu, This error means that the entry of the log to write is not writed i...

Hello Regu, This error means that the entry of the log to write is not writed in RT_STATUSnnn of the job, This file is corrupted try to Clear status fiel from director. Regards, Cristina. > -----Mensaje original----- > De: Regu.Saliah@astrazeneca.com [SMTP:Regu.Saliah@astrazeneca.com] > Enviado el: ...