DSXchange

You can however, use the MATCHES statement to perform as a case statement. Glenn Herbert wrote: > No. The CASE statement cannot be used directly in a derivation field; > rather, it should be used within a custom transform. > > Derivations are limited to a single line expression, of which CASE > (and...

Hi For those of you that may not be aware, the Sydney Australia Ascential Users Group is meeting this afternoon at 4pm. Location: Level 6, 50 Berry St, North Sydney If you wish to come along and have not already indicated your intentions, please email joanne.douglas@ascentialsoftware.com and advise....

No. The CASE statement cannot be used directly in a derivation field; rather, it should be used within a custom transform. Derivations are limited to a single line expression, of which CASE (and others) is not. Use either the nested IF/THEN/ELSE/IF... or FIELD(xxx,INDEX(yy)) expressions. Glenn At 02...

"Easier" depends on your point of view and experience.... Someone with no clue how Integrity (uh... Quality Stage) works might take umbrage with this... Though, yes, I believe that overall, the Quality Stage would be more comprehensive as its rules are quite good for this purpose... At 03:00 PM 06/0...

A perfect use for Integrity.... It can be done in DataStage Basic, but would definitely be much easier and probably more comprehensive in Integrity. Lester Lester F. Callif | Manager | BearingPoint Consulting | Denver, Colorado Mobile 303.596.8422 | Fax 707.988.0160 -----Original Message----- From: ...

Does anyone know whether there are routines available for name parsing? For example, reading a name field until the first comma is found (last name), then checking for Roman numerals, followed by reading the next word until a space is found (first name), then reading the next until a space is found,...

How would you use the case statement in a derivative field ? the example that Tim J sent Begin Case Case In1.STATUS=A Ans = Active Case In1.STATUS=L Ans = LOA Case In1.STATUS=P Ans = Paid LOA End Case writes to a variable Ans rather than the derivative field. I was just curious if we could use the C...

The CASE statement does not work in the manner which you intend; the compiler requires BEGIN CASE, CASE xxx and END CASE statements to begin on a new line (whitespace not counted). Thus, you should use the If/Then/Else logic for the three way: VALUE = if In1.STATUS=A then Active else if In1.STATUS=L...

Try something like: Begin Case Case In1.STATUS=A Ans = Active Case In1.STATUS=L Ans = LOA Case In1.STATUS=P Ans = Paid LOA End Case -----Original Message----- From: Armstrong, Kathy [mailto:kmarmst@qwest.com] Sent: Monday, June 02, 2003 12:27 PM To: datastage-users@oliver.com Subject: Case Statement...

Hi All, I have been struggling to get the following 3-way translation to work as a derivation: Begin Case Case In1.STATUS=A Active Case In1.STATUS=L LOA Case In1.STATUS=P Paid LOA End Case Since the compilers explanation is "general syntax error", its a challenge to figure out what to change. Before...

Salem Georges, you have several functions: with DSGetNewestLogId(JobHandle,EventType) you get the newest logid then you take this number and go down with the numbers by using the function DSGetLogEntry(JobHandle, EventId) until you get the informations you want. So do we. Wolfgang > -----Original Me...

Hello guys Can we read all the Logs of a control job to see which job finish with warnings or Abort ,I succeed to read the latest ID and if I use the DSLogInfo ...or any other function I cant get into all the log ,I always get the latest one....if a job finish with warnings or abort in the middle of...

Hi Prasad, what do you mean by binary? Files without linefeed? We are processing binary files with DataStage since Version 3.6. Without any additional details from your side how your "binary files" look like I cannot help you. Wolfgang > -----Original Message----- > From: BKS_Prasad [mailto:BKS_Pras...

Another way to transpose is to use the standard transformer stage where you ensure that the input records are grouped (as a set). In each derivation you map the respective source record (each input record maps to a single output column - all others are set to empty) The output of the transformer goe...

Tunde, A lot of us who monitor this list make our living not just by developing ETL code, but also by consulting with companies to develop the standards, naming conventions, best practices, and migration tools necessary to bring an ETL project using DataStage to fruition. Since you are new to DataSt...