DSXchange

We generally use Oracle sequences. One approach is simply to have a lookup which does something like: select my_sequence.nextval from dual as a user defined query. However, depending on the speed of the connection to the database, this may slow you down if you have a very high number of rows to proc...

Hi all,
I need some help in generating a surrogate key.
Using Oracle 9i Warehouse Builder it is easy to do that but with Datastage I have no idea yet. Any help will appreciated,

Robert Dragoi

Im testing a program in the NT version of Datastage, version 5.1. The program has an FTP stage putting data into a Sequential stage. The data on the mainframe that is being transferred is a fixed length file with fixed length fields. In other words, no delimiters. The sequential file is defined has ...

Just printed it out and will look at it later tonight. I believe that what you want to do can be done using Stage variables. One Stage variable containing the last Customer #/Name, a Stage variable contaniing the last date, and another Stage variable containing a count. Hmmmm, the only problem I can...

HI Guys, I need a routine to pickup the max. value of a key field in a table, before I insert new records. I would like to run this routine once as a pre-job. Any help would be highly appreciated. Thanks Karthik -----Original Message----- From: lester.callif@ascentialsoftware.com [mailto:lester.call...

Hi Rahcel.... I would use Stage Variables within the transformer as such Var Derivation KeyChg if CustomerKey = LastCust then 1 else 0 LapseFl if KeyChg then 0 else if (LastDate - Oconv(EventDate,"D/MDY[2,2,2]") ) >= 6 then 1 else 0 LastCust CustomerKey LastDate Oconv(EventDate,"D/MDY[2,2,2]") That ...

Hello, I need some help writing a routine. I am trying to calculate "visits". A visit is defined if there is a lapse of 6 days between transactions. The input looks like this: CustomerKey, EventDate 123, 5/12/02 123, 5/13/02 123, 5/14/02 123, 5/22/02 123, 5/23/02 999, 5/12/02 999, 5/13/02 999, 5/22/...

Thanks for your answers Ken and Himanshu.

Scott

Celeste, if you are using the "native" or ObjectCall connection (The red UDT stage in DataStage Designer) to access UniData and not ODBC you would not have to modify anything on the UniData database. If I understand your question correctly you have a field on the UniData database that contains a dat...

To All, the attached is a simple program i wrote a few yrs back to help track jobs that are running, and how long they run/ran. It references the start time, run status etc for any job in a predefinied job list. this job list is dynamically built and a list is saved. -----Original Message----- From:...

you can run a universe program that will do the following: ------------------------------------------------- stmt = "select voc like rt_log..." execute stmt,select>svlist,out>out.msg loop readnext filename from svlist else done = 1 until done do stmt2 = clear.file : filename execute stmt2,select>svl...

Hi, Does anyone know if Datastage has some fast routines or methods for ASCII character translations from various international formats to another ASCII character set (in our case PC100-ISOLATINE1)? At the moment we are using some C code to translate the various datasources we have however we are lo...

Hello Massimiliano, You must set default rule for each of the existing job using Director Auto-Purge. Cristina. > -----Mensaje original----- > De: m_musumeci@inwind.it [SMTP:m_musumeci@inwind.it] > Enviado el: lunes 8 de julio de 2002 09:00 > Para: datastage-users@oliver.com > Asunto: Jobs Log File ...

In Administrator I can set the default purging job rule,
but these settings are applied to NEWLY created jobs only,
NOT existing ones.

How can I set default rule for all the existing job ?

Thank You

Massimiliano

Hello Massimiliano, You can purge log entries using DataStage Administrator or Director but you can do it using a Batch. The log of a job is in a file called RT_LOGnnn (where nnn is the internal number of the job in universe), you can delete this file or you can delete only same entries. ===========...