DSXchange

Right, pretty much always build something of that nature in. Not for the daily stop and take a breather but for an emergency stop so it can be as graceful as possible.

You can't and trust me you don't want one. Make sure the job stops on some kind of a regular basis, even if it's only for a minute or two so files can flush and logs can purge, etc etc. My last one like that ran 24x7 but it ran 23:55 minutes a day, shutting down at that time and then scheduled to st...

Go ahead and simply add it.

I understood what you are looking for, I do believe, at least in the original post. I was responding to your specific statement that you are "not knowing how to get first day of last month". You were already getting the "last month" according to what you posted so was just trying...

What you posted doesn't answer the question. I don't know DB2 syntax but Oracle supports both byte and character 'semantics' so saying VARCHAR(25) isn't the whole story. It can mean either 25 characters or 25 bytes depending on the semantics setting. Perhaps something similar is happening in DB2. I'...

Are you certain your target field is 4 characters? I'll wager it's actually 4 bytes.

Getting the last day of a month is the tricky part, getting the first day should be simple since it is always '1' so hard-code it in your transformation much like you are already doing.

No problem. So, you have a working solution?

Just like any parameter you set it at run time, for a 'top level' job either via the Run dialog or from your command line execution. And you pass it downwards by doing literally that - defining the parameter in all the jobs that need it and passing it from the Sequence to each called job in the Job ...

Start by specifying which Sequence job compilations you have enabled. Also your previous attempt at redirection was incorrect as it redirected everything to /dev/null... try just redirecting stderr:

In our layout we are having some columns as comp-3 decimal and some are character.At mainframe end they are FTP using ascii mode.So we are some how unable to see the data in the mainframe. As James noted, if your file is being ftp'd to you using ASCII mode the packed fields are destroyed in the tra...

skp wrote:I am not able to view complete post. Any premium member please post the complete answer.

Do so and it will be removed.

You can find out what that return code means here.

As to your second question, you'd need to either query DS_JOBS directly (which is a whole 'nuther kettle of fish) or via the API you'd need to check all and then do a post filter. Both would be by CATEGORY.

You'll still need a job of some kind (server, sequence) to run the routine but there's nothing stopping it from reading a list of job names and looping though it to get the information you want. You could also do this from the command line, btw.

Nothing stupid about missing this at all, it can be confusing when you have mixtures of quotes and commas.