DSXchange

How does it help to simply repeat your original post? i have also changed the ENV parameter DS_ENABLE_RESERVED_CHAR_CONVERT to true also.do i need to stop the DataStage after this parameter is set it true ? .anything else i need to do ? If you found that environment variable in the docs, then you sh...

You just need to add a Routine Activity stage before the End Loop, one that checks for your exit condition (time passed, for example) and branches out of the loop.

Can you post (or draw) an example where you have put the Execute Command stages 'in parallel'?

+1. A non-issue.

You need to telnet somewhere, did you do that or just type 'telnet'? So, telnet to the server in question and see what happens. Note that you may need to fully qualify the server name:

telnet xxxxxx

telnet xxxxxx.yyyyyy.com

So... the parameter name has $ or the parameter value does? Also, what exact 7.x version?

No-one is laughing, we all were a noob at some point.

Your second syntax is correct, as long as the field is defined as a string:


You can then use StringToDecimal (off the top of my head) to properly convert the datatype for downstream consumption.

I'm supposed to get an email when new versions for H-PUX come out, guess that ain't happening no more. I wonder how long 7.5.3 has been available?

Pass your changes thru all three transformers, clearly noting the inserts from the updates so you know where to send what at the end.

What have you tried?

Depending on exactly what you mean by 'run', you could put in a constraint upstream of the stages you want to 'shut off' that ensures no rows pass that point. The stages would still run but they would process zero records.

This is pretty normal stuff. Use one OCI stage, not two and set your Array Size to 1 and you should be fine as long as the link order is correct.

Welcome aboard! :D

Perhaps this post might help: http://www.dsxchange.com/viewtopic.php?t=116666

There are others out there for the searching, but this one was fairly recent.

gstungare wrote:See log file for Oracle specfic message.

Did you?

UDB? Sorry, can't help you there.