DSXchange

In other words, put the single quote inside the surrounding double-quoted strings. Or even simpler, stop concatenating the status as a separate piece as that just complicates your work for (apparently) no gain: SqlScript = "SET HEADING OFF\n" SqlScript = SqlScript:"Delete from ":...

ICE, you've never said what your lookup stage is. The Link Variable NOTFOUND works fine with a hashed file lookup, but I've found it... unreliable... with a database stage. Hence the advice to fall back on the Old School technique of checking the return value of one of your keys for null. However, e...

Scale? Same thing happens if you multiply by +1, yes?

So, no 'previous run' message when you reset the job after it aborted? That makes it a little... harder. Since sequential files don't generally blow jobs up like this, let's double-check your lookup. Is this generated or user SQL? Do you have four columns defined in the OCI stage with the first thre...

Only when the last sane person in this insane world is gone.

Is it that concatenation of a string with Null values will yield Null value in Datastage. In Oracle it is not so. It's not a 'DataStage thing' - that is the rule of null handling pretty much anywhere. You do anything - concatenation, math, anything - and introduce a null element into it and the end...

Any explanations from that? Err... no. Sequence jobs don't insert data into tables. We'd need to know a lot more about the nature of the Server job it runs that actually does the dirty work and a better explanation of your problem. So, job design? Target, source? What are your 'raw' values? In other...

In other words: NullToEmpty(A) : NullToEmpty(B) What do you want the result to be if both fields are null? In this case, you'd get an empty string rather than a null. You could wrap the entire expression in another that replaces any empty string result with whatever you feel is appro...

More house keeping.

Since that's the default padding character, I heartily agree. Now we just need a definitive answer on what the character really is.

The SAP 'issue' is the only reason I wanted to clarify things.

All IBM media comes out of Ireland now, it seems. Hence the suspicion that leprechauns may have been enslaved to keep up with demand.

And we all know that a "hex editor" can only display hex values.

As noted, if it is truly an ASCII hex 20 - that's a space. You've highlighted a decimal 20 in the list above, something else entirely. Which is it?

And where exactly do these characters show as '# # #'?

Yah, there yah go... just reformat your server. So, besides the fact that you are trying to install the Server software onto a platform that isn't supported, this XP box doesn't have an NTFS partition you could install on? If you don't what what NTFS means - stop. Seek professional help. Find someon...

As noted, it's the license that you are paying for, the disks come free.

Last time I received a care package from the leprechauns at IBM, it came with CDROMs for all flavors of UNIX - and Windows to boot. My license only allowed me to install the H-PUX version.