DSXchange

In the columns grid in a hashed file stage, there is a column called Position. In a record in a hashed file, the key is position number 0, the first non-key column is position number 1, and so on. All key columns are at position 0, and some extra information not visible in the columns grid records t...

Thank you very much for your info. Changed the program according to your mail and It works fine. Regards Elavenil len.greenwood@ascentialsoftware.com wrote: The function DSGetLogSummary() returns a Dynamic Array, not a sequential file handle. You process these arrays with, for example, the Remove st...

hi, In the Before Tab (or After Tab) in the OCI Stage, use :- call procedure_name(param1,param2,...) regards, aedla. -----Original Message----- From: Stacy Scoggins [mailto:Stacy.Scoggins@kinkos.com] Sent: Saturday, August 31, 2002 1:15 AM To: datastage-users@oliver.com Subject: Call a Stored Proced...

We are using an OCI stage and trying to call a store procedure as a BEFORE command in the OCI (not a BEFORE JOB routine or a BEFORE STAGE routine). We have tried a number of iterations but cant get the syntax correct and the job continues to abort. The syntax we are using is: Begin ;;End; Anyone don...

Yes, it can be done using the Aggregator. In a transformer, either build a big string with the various values in a stage variable (more scalable solution) or assign each incoming row to the next variable var1, var2 (again using stage variables). Output all of these intermediate rows to an Aggregator...

For starters increase the buffer sizes used by DataStage. We have found that a buffer that is slightly less than either 32K or 64K gives great performance between our systems. (see your local LAN Admin and DBA to get optimal sizing and diagnostics of the network loading) Use the Monitor function in ...

This is what we have named an "Anti-Pivot". This is almost a "poor-mans XML reader." Can someone explain how this could be done with the XML reader stage? (nice dream...) We implement this using an input to a transform that has a look-up to a hash file and output to the same hash file. The hash file...

YN, It looks like the constraint "key field(s) has to be defined as the first column(s)" has been removed from 5.2. Which version do you use ? Thanks, Bibhu Rewards Data Team 503 220 3891 (PDX) YN cc: Subject: Hash File Keys 08/29/2002 01:45 PM Please respond to datastage-use rs Hi Folks, We have a ...

Hi Nicholas, I came across a flyer for Enterprise Data Forum and saw you were one of the speakers at this forum. Man, do I wish I could come to that one, but as you know, Ill probably somewhere else for training. So how is it going? Im still doing travelling. Good luck and have fun at the forum. Pav...

If Saravanans suggestions dont help, your problem may be network or hardware. An hour is waaaaay too long! It helps if you have a lot of memory on the datastage box (1GB minimum). If network isnt an issue, there is a good chance NT may be doing an excessive amount of swapping (i.e. thrashing). -----...

No. Pivot only works vertical to horizontal. You could write a BASIC routine to do the opposite. The routine could either write directly to a file or you can trick Unix or NT to create multiple records by returing a single string with record terminator characters (either CR or CR-LF) between each re...

It works. Thanks Rui. > -----Original Message----- > From: Rui Soares [mailto:rui.soares@novabase.pt] > Sent: sexta-feira, 30 de Agosto de 2002 16:08 > To: datastage-users@oliver.com > Subject: RE: Job Identifier > > > Hi Nuno, > > you can use the function DSGetjobinfo, Like this > > DSGetJobInfo( D...

What do you mean exactly by job_identifier?

Kasia

At 15:13 30/08/2002, you wrote:
>Hi all,
>
>There are any function for obtaining the job identifier?
>
>Thanks in advance.
>
>Nuno Pimenta

Hi Nuno, you can use the function DSGetjobinfo, Like this DSGetJobInfo( DSJ.ME, DSJ.Jobname) best regartds Rui Soares Rui Miguel Soares NOVABASE Mail : Rui.Soares@Novabase.PT Tel (NB) : 351 21 383 65 92 Tlm : 351 96 347 08 40 -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]...

Hi all,

There are any function for obtaining the job identifier?

Thanks in advance.

Nuno Pimenta