oconv(data(), "DW") = 4 .. reads as Thursday?!

PaulS · Post by **PaulS** » Thu Apr 26, 2012 2:10 pm

Hi,

We've got a new install of ds 8.5 - in a trigger I have the above code so some jobs run on a Thursday. However they ran last night,.. Wednesday.

I though Monday was day one? So day four should be Thursday.

Running "date" on the unix box with the installion shows the correct day. Scheduling jobs to run on Thursday (with is today, day of posting),.. works.

I can do a quick fix by changing 4 to 5, but I don't understand it! Can anyone help please?

Thanks
Paul

qt_ky · Post by **qt_ky** » Thu Apr 26, 2012 5:35 pm

You have a typo in your subject; it should be date().

Date conversion codes are documented in the DataStage BASIC Reference Guide and other places as well.

The "DW" conversion code description is "Requests only the day number within the week (1 through 7, where Sunday is 7). If NLS locales are enabled, uses the DAYS field in the NLS.LC.TIME file, where Sunday is 1."

It sounds like you fall into the latter part of the description.

You could switch to checking with "DWB" which is "Requests only the abbreviated day name. If NLS locales are enabled, uses the ABDAYS field in the NLS.LC.TIME file." Then you're dealing with day abbreviations rather than numbers.

chulett · Post by **chulett** » Thu Apr 26, 2012 6:03 pm

I was going to suggest switching to "DWA" and then checking for "THURSDAY" but basically the same suggestion, that way there's no confusion over what day of the week you are looking for.

I also seem to recall there may be a setting in the dsenv file that controls what day of the week is considered day 1?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 26, 2012 7:33 pm

There is a couple of settings. You can also configure that the range of numbers is 0..6.

chulett · Post by **chulett** » Thu Apr 26, 2012 7:49 pm

I was wondering about that... I thought they ran 0 thru 6 rather than 1 thru 7. Would be interesting if the default changed somewhere in the 8.x release pipeline.

PaulS · Post by **PaulS** » Fri Apr 27, 2012 5:06 am

qt_ky wrote:The "DW" conversion code description is "Requests only the day number within the week (1 through 7, where Sunday is 7). If NLS locales are enabled, uses the DAYS field in the NLS.LC.TIME file, where Sunday is 1."

It sounds like you fall into the latter part of the description.

Thanks for that - the new install does indeed have NLSlocales enabled, previous install didn't.

qt_ky · Post by **qt_ky** » Fri Apr 27, 2012 8:04 am

You're welcome. Ah, our good friend NLS strikes once again...