DSXchange

Or actually supply a NULL value - "" is an empty string, not a NULL.

That's not a file format, and I don't see any commas - you must mean double quotes, yes? Use the Field command: Field(YourColumn,'"',2) This declares your string to be 'double quote delimited' and fetches the second field. Which in this case would be just "John Holdings". Without the co...

Need more information - what do your XPath expressions that you are using look like? Are they hand-crafted or did you import the metadata from your XML (or an xsd) so that DataStage built them for you? What does your target table look like, meaning what does the flattened output need to look like? A...

Specifically, search for "Timed out while waiting for an event". You'll find it's not all that strange and actually quite popular.

Well, that would require actually reading the thread. The OP doesn't believe there is a way to handle both deletes and inserts in a single job in a consistent fashion, so two jobs were crafted: a delete job that called an insert job 'after job'. The original question was how to abort from the after ...

:D Don't get me wrong, the answer to your original question *is* 'yes'. I was mostly just wondering if you really needed to do all that. The issue is that, with a UNIX based product like this, what's included with the tool out of the box are routines to unpack fields, not pack them. And yes, there a...

Usually best to tell us what are you trying to accomplish, rather than a specific question with no context. So, what are you up to?

My experience in this arena is more years older than I care to admit and predates my DataStage career, but mirrors what Roy posted. MF systems always seemed to have specific utilities that they used to transfer files to and from the 'Big Iron'. They handled the ASCII - EBCDIC (and vice versa) conver...

It's hard to help you remotely like this when you have so little experience with the tool and (apparently) XML as well. Is there anyone else there you can have look at what you are doing? Another set of eyeballs there would be very helpful. However, let's see... how many records does the monitor sho...

Posting this I noticed that you also said 'and get output values' as well. That you will not be able to do. I believe that if your sproc does this, you will not be able to leverage it as a target, but then as I said I don't use stored procedures in my ETL. If that's the case, you will then need to r...

Couldn't recall which 'S' it supported... Sybase. You'll need to use the ODBC stage: 1. Import the metadata from your SP in the Manager. 2. Set the Update Action in the ODBC stage to 'Call stored procedure'. 3. Set the 'Stored procedure name' by pointing to the imported metadata. I personally don't ...

Version 7.5.x includes a Stored Procedure stage, have you tried that? Or ODBC? More details, please.

Define 'dynamically'... based on what? What stage are you using? Have you tried using Job Parameters?

If you'd rather not have the joy of working this out for yourself, there is some code posted here you might find useful.

Oh, and welcome! :D

It's alot more complicated than that. Split the timestamp and convert all four pieces. Then (Days * 24 * 60 * 60) + net time difference.