DSXchange

> Hello, > > There is a field in a DB2 table that is defined as integer. The field > is currently storing a valid date. For example, 20010909. > > I am trying to use DataStage to convert this to a real date format. > How can it be done using the OS/390 DataStage component. > > My idea is to use subs...

This is almost impossible to answer without knowing fairly precisely what your jobs are trying to do. In general, something somewhere is waiting for a resource for more than 1800 seconds - this might be an FTP connection or something like that. While waiting, the job is not logging any events, so th...

Routines dont show up in Designer until (a) theyve been compiled successfully (b) Designer has re-read the repository Try re-opening the Designer -----Original Message----- From: Rui Miguel de Sousa Soares (Novabase - IGestao [mailto:rumsoares@bes.pt] Sent: Friday, 29 September 2000 03:05 To: Datast...

This is a topic for an orphaned message.

Note also that BASIC can open a directory as if it were a table (use OpenPath statement), then the filenames in that directory appear to be key values for that table. Your job control code might make use of this feature. This is one of many techniques taught on "Programming with DataStage BASIC".

I have a several batch processes that abort with this message, however, none of the jobs seem to be affected. Any ideas as to why the jobs would not start periodically? Batch::DailyRejectPercent.JobControl (fatal error from DSRunJob): Job control fatal error (-14) (DSRunJob) Job DailyRejectPercentNC...

Hi there Ive got a DataStage batch consisting of a number of jobs each with a number of stages of various forms (nothing particularly fancy and Ive simplifed the description slightly for ease of discussion). I really have 2 related questions: * How do I readily identify the rate-limiting job(s) ... ...

Ken, DSGetParamInfo is, imho, a cleaner approach, since its result can be tested to check whether the parameter name actually exists in the job (a subsequent "developer" may have unthinkingly removed it). You can also find out other information, such as parameter type, design time default value, run...

Dirk/Ray: If you are developing a batch job to control other jobs, the parameters are available as BASIC variables in the batch job. There is no need to do anything fancy, just reference the variable wherever necessary in the BASIC code that you need it. If you derive the variable in the BASIC logic...

I think what Dirk wants is to get the parameter from the current job and pass it to the controlled job. The function for reading a parameter value from a job is DSGetParamInfo(), and the job handle of the current job is DSJ.ME. From this (lets say the parameter name is Password): Pwd = DSGetParamInf...

If your database implements serial data types or sequences, you can use these to generate the next surrogate key value. Or you can use the @OUTROWNUM system variable and/or a stage variable, as alternate techniques to using the NextKey routine in the sdk. Be aware of the auditable columns (the ones ...

SCDs are straightforward in DataStage. I will forward a document on working with all SCDs to you directly. Look for a SCD container (similar to the document) coming soon.... -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: Thursday, September 27, 2001 11:17 AM To: dat...

Hello Is there anyone using DataStage to fill Teradata database please? I could use some references, so if you can provide them, please contact me (jakubh@urbanatech.com). Thanks a lot Jakub Holubec Technical Consultant Urbana technologies Belehradska 79/10 120 00 Prague 2 Czech Republic Tel.: +420-...

Ive chosen to do this in DataStage. I keep a copy of my dimension in a hash file so that the processing is done more quickly. I do a lookup into the hash file based on the natural key. Use a stage variable to check to see if there are any differences in the two records. This variable will be a flag ...

Hi everyone!

Anyone implements SCD type 2 in DataStage?
What are the approaches thay you use?

If we want to compare an entire record for track changes how do you do? Do you use DataStage or do you call a PL/SQL?

Any suggestions?

Thank you all in advance.

Regards,

Nuno Pimenta