DSXchange

Somehow a NULL has gotten into a row youre writing to the UV table in a key column position. To avoid this, add a constraint expression on this link to prevent rows where IsNull(key_column) from being processed. Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 C...

The answer to your question is NO. However, you might like to follow the Transformer stage with an Aggregator stage, grouping on the common column and using Last as the aggregate function. Use @INROWNUM from the reference input link to determine into which column to addyour rate type. Accumulate the...

Hi, Running a job, which extracts data from DB2 table and loads into a HashFile. This job had been running few times without any warning message. But this job completed with the following warning message. DataStage Job 347 Phantom 579 Program "DSD.UVClose": Line 55, Attempted WRITE with NULL record ...

hi, Is it possible to have only one row leaving the transformer stage with multirow lookup. I have to do a rate lookup. There are 4 types of rates in the lookup. I wish the four amounts calculated as four colums of the output link. Regds, Vivek > -----Original Message----- > From: Raymond Wurlod [SM...

Hi, Having a job, which extracts data from DB2 table and loads data into various text files. Aggregator stage is used to eliminate the duplicates before that data is loaded into text files. There are two aggregator stages and different group by clause are used to aggregate data. When the job was run...

Yes, you get multiple rows leaving the Transformer stage. Columns from other input links are duplicated on these rows. Its like an UNNEST operator in UniVerse. Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic 3006 Tel: +61 3 9626 6624 Fa...

Very interesting. I found the topic in the 5.1 online help (its dsdesign.chm now, btw) but all it really says is that it can be done if you are using the UniVerse or the ODBC stage if you check off the multi row result set option. Is there any writeup available on how I would actually make use of th...

Hi Ed... I totally agree. The context of that statement is confusing. The specific nature of this sentence slipped thru the cracks, but the intent of this sentence was something we discussed at length for many months during the design of release 5.1... The Multiple Job Instance feature provides you ...

Reference lookups can return more than one row. Check out the topic "Defining Multirow Lookup for Reference Inputs" in dsdesign.hlp (Designer/Manager Help file). Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Department Level 22, 60 City Road, Southbank Vic 3006 Tel: +61 3 9626 6624 ...

Arent you going to have an issue with the all records in the hash file where part of your problem? Unless something has changed lately, reference lookups only return *one* row. -craig Peter Oates cc: 03/07/02 02:54 PM Subject: Lookup on hash file Please respond to datastage-users Is there a way to p...

In the section on "Multiple Job Instances" (page 3-16) the version 5.1 DataStage Directors Guide talks about properly designed and poorly designed jobs. It states "For example, a poorly designed job may have different instances running concurrently and writing to the same table." The Oracle Bulk Loa...

Check out the "Programming with DataStage BASIC" class. There are three ways to solve your If .. Else If .. Else If .. question. One is a Case construct. Begin Case Case condition1 statement(s) Case condtion2 statement(s) and so on End Case It is not necessary that any of the conditions in the Case ...

Is there a way to perform a lookup on a hash file that uses a range selection on two fields rather than the usual equals comparision on one. ie. I want to find all records in the hash file where date x in the primary input falls between date a and date b in the hash file. The only alternative I have...

Hi Regu, verify in the output tab of the hash file stage. The attribute "position" for the non-key filed in the output tab must not be 0 (zero). I hope this will help you Regard Riccardo ----- Original Message ----- From: To: Sent: Thursday, March 07, 2002 4:38 PM Subject: Hash File Stage nullifying...

In my job I am populating a hash file stage to perform a lookup in a subsequent transform. The hash file has two input columns one of which is the key. The output column is exactly the same and is pre-loaded to memory for a speedy lookup. However, when the job is run, for some reason the output from...