DSXchange

Gmail runs on SSL and STARTTLS is a sendmail command to initiate a secure connection and that's exactly what the error message is pointing you to. How about you try emailing to an address within your office network? Try emailing to your workplace email address.

If the reference returns more than one row, does it operate like a join, or does it ignore the duplicates? Doug If you select the option "multiple rows returned from link" it will work like a join stage. If you did not select that option the lookup stage will drop duplicate records based ...

In version 7.x, we can demote warning messages to Informational messages. Not sure if there is an option in version 8.x to add rules to the message handler in the director to promote the warning messages as a Fatal error message.

I had trouble reading the data with datatype set to Time and format set to %hh:%nn as well. However, when I changed the data to 23:00:00 I was able to read the record successfully. As Ray pointed out, could be a bug.

Yes it will. As long as you echo only the COUNT at the end of the script. All other informational messages should be written to the log file. Something along these lines: connection=`db2 connect to Database user user using password` if [[ $? -ne 0 ]]; then echo "\n Error Connecting to the Datab...

kpsita wrote:Thanks for your reply. But can I use lookup if the reference table is in millions. Is there any other options other than lookup.
Thanks

Depends on how big your table is, how many columns you are bringing in, how large the memory is, and how fast your reference table is growing in terms of records.

Does this encourage garbage collection? I am not sure I follow you. Output link for the lookup stage is a required link. And since the OP is interested only in the data from the reject link, its a good option to write the data from the output link into /dev/null or a copy stage without an output li...

And feed the output link of the LookUp Stage to a Copy Stage or Sequential file stage with path /dev/null

Hello Kris But just 1 question when we execute the shell script from the Execute command stage we will get the connection information also in the command output how to remove that please...I want only count in the output command. There is no shell script involved. You just have to use the command w...

RStone wrote:Hi,
Is a transformer stage the only stage that has stage variables?

That is correct.

Yes. But what if your input date is 20080229. What should be your output? 20070229 (which is invalid) or 20080228.

You can do something like That should work. The only challenge for you is to put in some additional logic when the Date you have is a leap Year and it is Feb 29. Then the last year date would be Feb28 of that year.

Hope that helps.

Where is the indicator being created. Is it created in a job and written to a file? You will have to design your job/Job Sequence such a way that when the indicator is "Y" it sends a signal to the Terminator Activity stage which will then abort your subordinate Job Sequence and the Master ...

PhilHibbs wrote: Stage Variable as =MinutesFromTime(svTime)+HoursFromTime(svTime)*60

That sounds easy enough to me..Isn't it

arunkumarmm wrote: Why do you think it will not accept NULL. Seq file will accept NULL.

Unless you specify a default for NullFieldValues within the Sequential file stage properties you will have trouble reading NULL's.