DSXchange

Alessio, I believe DataStage 5.1 will allow you to do this as the ClickPack is now part of the base product. There is a routine that can be called as a Before/After subroutine to execute a Perl script. although we only supply a before/after routine you may be able to change it to cause perl to run i...

Hi all,

I would like to call a perl subroutine by DataStage.
Is it possible? How can I do it?

regards,

Alessio

This should apply to universe as well... DSDesigner - To add a variable parameter in the selection of Unidata records, pull up the Unidata stage and open the inputs, columns, selection tabs and under the hardcoded "SELECT [filename]WITH:" in the blank window, insert #Selection#. Then in the Edit, Jo...

Thank you so much for your help. What you described sounds like exactly what I want to do. I know how to create a batch to run the hard-coded version of a job, but Im a little fuzzy on how to get a sequential file to be read by the batch. Now that you have told me it can be done, I will dig a little...

Hi Jill. You will also want to take a look at the 5.1 version of DataStage, which, (once you get the job parameters functioning the way you want) allows you to run that same job, with different run time parms, multiple_times_concurrently. 4.0, with the job parms will solve your problem of maintainin...

Jill You need to use a parameter. For the account use a parameter called PROJECT. You need to put #PROJECT# in the field. The best way would be to run this from a batch job. I think the project is stored in @WHO. If you need more help than that let me know. Thanks Kim. -----Original Message----- Fro...

Hello All, Im running Datastage Version 4.0 on a Windows NT server. I have a very simple 3 stage job that I run 50 different versions of. The only thing that varies from each of these 50 jobs is the account name under the Details tab of the Universe stage and a hard-coded value for one field in the ...

There are a number of temp files that may be created by the server engine during job execution, one of them being capture files (i.e. capturexxxxx) which under normal circumstances should be automatically deleted at job completion. However, if the job aborts its possible that cleanup doesnt take pla...

Hi Nuno, I was running in the same problem some month ago but on rel. 4.0. If you sort the the record on the field that you are aggregating everythink will work fine. Best Rgds Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- Fr...

Tracing-Level=1 on the "Stage" tab of the Merge stage. -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: 28 November 2001 12:10 To: datastage-users@oliver.com Subject: RE: Abnormal termination of stage sorry, but where is that option? i havent find this option in help....

sorry, but where is that option? i havent find this option in help. thanks. NP > -----Original Message----- > From: Ricketts, James [mailto:JAMES.RICKETTS@POLK.CO.UK] > Sent: quarta-feira, 28 de Novembro de 2001 11:39 > To: datastage-users@oliver.com > Subject: RE: Abnormal termination of stage > > ...

Yes ... try setting stage-logging on and you should get a more helpful message listed (mine was something like join-columns-must-be-selected-in-output). -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: 28 November 2001 11:37 To: LIST-DataStage (E-mail) Subject: Abnorm...

Hi all, Im aggregating data, using the aggregator component, from a source table. But by any raison the job aborts with this warning: "Abnormal termination of stage DSagsms10q2v1..AGGREGATOR110 detected" Has anybody experienced this problem before and has a solution for it. Im using version 5.1. NP

Hi All, Can someone tell me about the UVTemp directory in the ServerEngine dorectory. I have a capture file there which has a size of 58GB!! I want to know whether the files in this directory can be deleted. The DS sever version is 4.2.1 running on Windows 2000. Thanks in advance. YN _______________...

Hi Carol, The best way to find out, is to schedule a job from Director that will run say everyday... then as the same user that scheduled the job, login to Unix and perform a cron -l ?? (I think, I need to lookup man cron). You should see how DataStage does it. Alteratively, you can use dsjob... but...