DSXchange

Remember that the uvodbc.config file might have copies in each project's directory as well as one in $DSHOME. If so, the one in the project's directory is the one that will be used, ignoring the one in $DSHOME.

Larry

Yes, I did Ray. It returns a character representation of the hex also, not an actual hex (binary) field. At least that's what it looks like to me.

Larry

I could be wrong, but both of these solutions seem to give only a character representation of the desired result, at least when written to a Sequential File stage. For example: oconv("9","MB") = "1001", not a true binary field, but rather an ASCII character field. (In h...

Everything look good in Amarillo, TX!!

I do occasionally get a "forum not found" message, but that seems to be happening on web sites all over, not just DSXchange and retrying almost always works.

Larry

We are about to embark on an upgrade to Version 7. Does anybody have any experiences that they would like to share with the rest of us?

I think any platform would be of interest, although we are on AIX 4.3.3, going to 5L, and at the same time moving from Oracle 8i to 9i.

Thanks in advance.

Larry

Thanks again Ray and Vincent. But:

Unfortunately, I still do not know what vaules are in context in these expressions, nor do I know what document to look in to tell me this.

Can anyone point me in the right direction?

Larry

Yes, but in a Nested Condition, what is "in context"? Obviously I can't refer to stage variables. And it doesn't seem like input columns (or output columns) would be available. That would seem to leave date and time, which is not a whole lot! What I am attempting to do is to take a differe...

The thing that causes me the most grief with DataStage is how hard it is to find detailed information about how something really works. Right now it is how to write an expression in a trigger of a Nested Condition stage of a job sequence. Where do I find this information? I have looked at help, the ...

What is Twister?

Larry

Why not use Truncate table instead of clear table? It's a lot faster!

Larry