DSXchange

I for one would be curious what "all the different solutions" are that you tried and also what you mean by "the job fails"... specifically what about it fails, what error messages are you seeing? If the issue is reading the file, it's too late to try to handle them in the job and...

Perhaps Ray is still giving away his BASIC routines to do date and time math, that would certainly make things easier. Otherwise I think you're going to need do some of your own. Something like: 1. IConv to convert the time to internal format 2. Subtract 18000 (5 hours in seconds) 3. Handle any 'und...

You were too quick. I removed my post when I noticed you said "in a User Variable stage" (which means a Sequence job) and I thought you were looking for a Parallel function. While I was removing it you replied.

No it does not and we're in the wrong forum to boot. Hang on a sec.

Yup, it would need to be decimal(8,5) to get the output you are looking for.

Worrying about how the DB2 Connector handles it isn't going to help, in my opinion, as they are completely different mechanisms and environments. You need a solution to the problem you are seeing with it at the OS level. Unfortunately, I'm not aware of any 'setting' that would allow your problematic...

You are facing the same issue in a Server job? Assuming your problem is with a parallel job, please start a new post and detail for us exactly what the issue is that you are having.

Rejected records? We don't need no stinking rejected records!

From a permissions standpoint when you say "when I execute" that's only a valid test if you are logged in as the same user that executes the job.

Okay... DSExecute with a shell type of SH is the same as ExecSH from Before/After or the Execute Command stage, so we're good there. To really nail down exactly what the issue is, any chance as a test you could have the password changed to something without special characters (temporarily) to confir...

Sorry, still just gathering information. So actually you are doing "db2 connect" from the command line using ExecSH, it would seem. And passing in the parameter as part of the command line, yes? I'm wondering if the parameter is defined as a string or an encrypted password and also wonderi...

So how exactly is your routine 'connecting to DB2'? Is your password coming in as a job parameter or are you 'hard coding' it as part of this routine?

So you want to capture the number of rows processed without any evil routines? Add an aggregator from the transformer, count the records and write that to your second target.

Spaces like that can lead to madness, yes.

Andy, the original issue remains unsolved unless Ray's SQL is an answer to handling folder names with spaces in them. Anyone care to confirm / deny?

Dave, just in case you hadn't noticed it - there is a Reply to topic link at the top and bottom of every page that let's you reply without quoting everything from the post you are replying to.

Thanks.

And you don't want the decimal point? Don't define it as decimal. Perhaps use an integer, that or convert it to a string before writing to the flat file.