DSXchange

Nice top of your head, Ray. I did manage to slap something together last night, taking a similar approach. Not quite the same level of error checking and messaging that you did, perhaps I'll 'borrow' some of that. FUNCTION IsCorrectDate(DateToCheck,Iteration,DayName) Ans = -99 lvFound = @FAL...

I've asked similar questions over in the new post that was just started in the Server forum. Hopefully, they will come back here and answer them for you.

They noted their solution, it was an issue with having multiple versions of the client loaded and not having set the environment up properly via the MCM before exeucting their script. Are you in the same boat? If not, have you verified that all your variables that make up the output pathname are bei...

Ok, now I'm confused. You've been working on this over in the TX forum and now you're suddenly over here. Which is it? Are you working with a Server job or a TX job? If Server, we can take it from here. For TX you need to get yourself back to the original thread and continue that conversation. I alm...

Yah, too simple.

Strange, because it must be removing them from a registry entry somewhere so you should be able to reverse the process and nip (or add) them from the other end as well. However...

ASsuming you are logged in as the 'administration' account - typically 'dsadm' - the command would be:


Or fully pathed as:

Use the -jobstatus option with 'dsjob'. It returns the internal return codes as the status of the job. You can then declare it a 'good return' if the status is a 1 or a 2: 'Finished Ok' or 'Finished (see log)'. Anthing else would be a 'bad return' in your script. You don't really need to add this ex...

My post is simple enough, just a mechanism to get the job status back directly in the return status without having to 'grep' or 'cut' anything out of the text that is returned as well.

I unmarked it.

As noted, your post is a mess such that we don't really know what to make of it. Suggest your edit it and make it more... understandable. I don't see any evidence of your trying to set the warnings limit to 10, each occurance says -warn 1 that I can see - abort after 1 warning. You may want to post ...

There really aren't 'many' ways. You could do either of your #1 or #2 import choices, neither one is 'better' than the other. And neither one is responsible for the errors you are/were seeing.

As noted, you really should have a chat with your DBA.

Thanks for all the 'nudges'.

Hopefully will get some time in the next couple of days to work on this little side project and see what comes of it all.

Thanks again!

Can't help you with that as I don't have access to DB2. However, have you tried just concatenating the date and time portions together appropriately to build a timestamp? Or if there is no time portion, concatenating a proper set of zeroes to the date...

Actually, I'll probably create something more generic so it can find the nth whatever of a month - first Saturday, second Tuesday, etc. However, I'm having a bit of a brain fart. I know we've got the TAG transforms to work with and can get the week number of the year for example. I can also rather e...