DSXchange

Alok I'm wondering what your job looks like; you're talking about one or more tables where a particular field for all rows has to be 'Y' before you can continue. I assume that you get them all togther using a union statement, or like Ray suggested in your previous topic, a select distinct: select di...

JB, I think using Linkname.REJECTED will do exactly what you require. Beside the records that failed to fulfill the constraint on the output link to your table, it will, as Michael described, collect those records that were rejected by the DBMS itself. You would even be able to record the reason (er...

I noticed (but never tried) the output link variable REJECTED, which, unlike the others, is not preceded by a linkname. Using this as a constraint probably has a similar effect as checking the 'reject row' box, i.e. it will collect those records that were rejected by all other output links (but with...

Michael

I am not sure that the 'Reject row' box has to be checked to get the rejected records? I think it will be sufficient to have the constraint for Link2 set to Link1.REJECTED or Link1.REJECTEDCODE.

Stephan

Thank you, Raj, it looks better now, though I can hardly spot the blank between '!' and '2', not even when I tried with multiple spaces.

Stephan

There seems to be a display problem with a line of code in my last reply:

Looking correct when editing, the line:

count=$(dbaccess dbname ...

displays completely different after being saved. Any idea how to avoid that?

Alok, I will gladly try, though I'm not an Oracle expert, and I have some experience in scripting on UNIX, not NT. Let's assume we had an informix database, so we would use dbaccess (is this sqlplus for oracle?) as frontend. Within the shellscript, I would have a lines like this: * possibly some env...

One possibility: Write a shellscript that does the following query against your database: select count(*) from table where field='N'; Catch the result into a variable in your controlling job. If it's 0, kick off the load else don't (I must concede that this only works, if the value of the field in q...

Roy

I apologize, if the topic should be misplaced here [B)]. But thanks to all for the responses it provoked nonetheless [:)].

Stephan

I stumbled across the term 'staging area' a couple of times, and I have no faint idea what that is. Could somebody please explain what it means? Thanks in advance!

Stephan

Strange, we are on DS 5.2 and encountered frequent 'Abnormal Termination' aborts when aggregating data within uv-stages. We worked around it using aggregator stages!!!

Stephan

Ken and Raj kindly pointed me to the dsjob command line utility:
http://www.tools4datastage.com/forum/to ... C_ID=84826. Inside a job you can evoke it using ExecSH('UNIX', InputArg, Output).

Stephan

I was facing the same questions and found that DataStage doesn't have a datatype that contains both the date and time portion of a timestamp. They must be handled separately. The internal representation of a date is an integer as the number of days since '1967-12-31', while a time is the number of s...

Substracting two dates with a result>0 is the number of days passed since 1967-12-31. Formatting this a "D-M" will, I think, tell you the month in which that day lies. Applied to 2003-08-11 as end-date and 2002-08-10 as start-date, I wouldn't expect 13 (better: 12), but 1 (January 1969). S...

Kim when you state: "If you telnet into your server and at TCL type in HELP BASIC then you will see a lot of commands not very well documented. The goal of DataStage is not to expose you to all of the functionality of the underlying engine because it is going away" does this mean that the ...