DSXchange

And if you ever get to meet Ray, you can admire (to misquote the Clash slightly) his sitar pick'n thumb.

Why not just 'format' it twice, inline the two calls? Seems like that would work...

Forgot to mention that 'FMT' will handle both of your examples: the zero padding and the 'descaling' of the decimal point.

You can use the FMT function, check your online help. Off the top of my head there may not be a formatting option for a leading minus sign. If not, simply check if your value is < 0 and concatenate it on the front of your output field if so.

The status is returned as 2 whether the job has more than the threshld number of warnings or not. If you look in Director the job logs a FATAL message 'issuing abort' after the number of warnings is exceeded but a few lines later is an INFO message stating the 'Parallel job reports successful compl...

Well... hopefully all your answers will help someone in the future. The original poster has moved over to the Server forum as they apparently posted here first by accident. Doh.

Answer my questions, please. Specifically, the two questions related to your definition of a 'month' and how you want to handle invalid day problems.

Perhaps you could start by explaining what this 'other tool' is that you are using to run jobs and how exactly it 'runs' a job. If you run the job from Director, do it run correctly or does it crap out with the same error messages? I'd also be curious how you have 'JRules' - a BRM solution from ILOG...

The Field function is your friend.

Search here or in your online help for examples.

Just curious because of your ^M comment. You probably aren't familiar with them as they come from a UNIX environment when a DOS file is sent in 'binary' format to UNIX. The terminators are not converted, so the 0A is seen as the terminator and thus the preceeding 0D (^M) is seen as data. Not somethi...

This isn't about determining which carriage return is the 'right one'. All that setting controls is whether 'terminators' inside the field are considered data or if the record ends at that point... and what it considers 'terminators' are based on what 'Line Termination' style you select in the stage...

The Sequential File stage has a column option for 'Contains Terminators', something you should check out.

Good luck with that delimiter.

atulghate wrote:The return code is always set to 2 by dsjob command even though the job is aborted (if it is dues to excceded limit of warnings).

No, it's not - not if you use the -jobstatus option with dsjob. It will be a 2 if the job finished with warnings and a 3 if the job aborted.

If the 'permissable limit' of warnings is only 10, then why are you allowing the job to generate 15? My assumption was you set your warning limit when running the job to 10, thus when it attempted to exceed that threshold the job would abort - not continue on. Then you can check the return status di...