DSXchange

Hello, I read the reply below which the code was provided to receive emails when a DataStage job should fail. I have 2 questions. Where is this coding typed? Would it be in the job design under the job properties tab? Also this information is very useful. What are some sources to obtain information ...

Hi David, There are few ways round this, 1. If the only source of data for your Database table is this job then you need only load the hash table once in a different job. The job below would then not need the Database part as the hash would be kept upto date by your job. 2. If the above seems a litt...

Were running UNiverse on NT as well as DataStage. I use the UniAdmin client often. I dont know it its supported by Ascential but perhaps we (the forum) can help. -----Original Message----- From: Pelletier, Christian [mailto:CPELLETIER@probusiness.com] Sent: Wednesday, June 19, 2002 7:12 PM To: datas...

Guys, Im trying to use the above variable to provide me with the means of counting the number of successful / unsuccessful writes on a link going to an OCI stage. The OCI is doing simple inserts into a table. The observation Ive made is that the variable is always showing one of the rows as being su...

Chris, you can use stage UV to read an Hash file. The Multi-row lookup property is available also for the UV stage!! Riccardo ----- Original Message ----- From: "Jack Luchjenbroers" To: Sent: Thursday, June 20, 2002 10:37 AM Subject: Re: extracting more than 1 matching record from a table > Chris, >...

Hello, I am desperately trying to convert a char(12) field containing a number and leading spaces (ie : "12345 ") to a char(12) field containing the same number but padded left with zeroes (ie : "000000012345"). I tried the FMT function, Str function and so on but certainly not in the right way or r...

Chris, They cant add it to the hash file stage, because the hash-file lookup constructs a single key and can only ever return one row. The fields that are marked as key are concateniated together seperated by a text marks (char 251 i believe) top become the actual key to find the record. Jack ----- ...

Oops! Didnt read your email closely enough. Yes, and while theyre adding it to the OCI stage, could they also add it to the hash file stage??? Quoting David Barham : > Thats right, Chris. Refer my original message. It is only available > for ODBC and UV stages. It became available at version 4. > > ...

Thats right, Chris. Refer my original message. It is only available for ODBC and UV stages. It became available at version 4. I have asked for it in the ORAOCI stage as we use this in preference to ODBC. There was a new major release of ORAOCI8 (version 3) at DataStage 4.2.1 but it was not in that. ...

This feature only seems to be available for the ODBC stage in DS 51. It simply doesnt appear as an option in other stage types (hash, OCI). Quoting Julie.Jarrett@ing.com.au: > > > Thanks, I used Davids suggestion and it works beautifully, I didnt > realise the feature existed, and have always just p...

Thanks, I used Davids suggestion and it works beautifully, I didnt realise the feature existed, and have always just programmed around the problem Julie David Barham on 20/06/2002 03:38:32 PM Please respond to datastage-users@oliver.com To: "datastage-users@oliver.com" cc: (bcc: Julie Jarrett/NSW/IN...

David Barham on 20/06/2002 03:38:32 PM Please respond to datastage-users@oliver.com To: "datastage-users@oliver.com" cc: (bcc: Julie Jarrett/NSW/ING-MM/AU) Subject: RE: extracting more than 1 matching record from a table If your lookup is using an ODBC stage or a UV stage, you can tell it to return ...

Try text ODBC driver. John Whyman, Resolution Team Engineer Ascential Software 50 Berry Street, North Sydney Australia NSW 2061 -----Original Message----- From: Julie.Jarrett@ing.com.au [mailto:Julie.Jarrett@ing.com.au] Sent: Thursday, 20 June 2002 3:31 PM To: datastage-users@oliver.com Subject: ext...

Both the ODBC stage and the UV stage have a check box on the Link Properties called "Refence link with multi row result set" which will perform exactly the task you describe. Consult the help topic "Defining Multirow Lookup for Reference Inputs". Julie.Jarrett@ing .com.au To: datastage-users@oliver....

If your lookup is using an ODBC stage or a UV stage, you can tell it to return multiple records. Each record will be processed in turn in conjunction with the same input record. If your input record resulted in 2 records being returned from the lookup, then 2 records would be output from the transfo...