DSXchange

mab_arif16 wrote:A sequence needs to be fired every hour by cron tab

Every hour, or very hour by cron? Cron in and of itself is not sophisticated enough to handle that situation. You'll either need to handle it as Ray notes, or use an Enterprise scheduler (like Control-M) rather than cron if you have one.

ps. That's not a script.

opdas wrote:well I can create a file at the same path using touch command.

Code: Select all

touch output_2006-07-13_19:28:50.txt

Then to me it looks like it's coming down to an issue with the ancient version of DataStage you are running. Can you contact Ascential Support and verify?

We are using AIX 5.3 Looks to be specific to AIX. Can you check with your UNIX sysadmins and find out if the colon is not allowed in a pathname? Or at least what characters are not allowed? You might also try creating the file by hand at the command line, see if possibly it's an issue with your ver...

Because once this file is built. If it needs to be accessed again in some other job, the sequential file wont read it then due to that pesky space. Or it can, am i missing something here ??? Yes. The sequential stage can handle it just fine, it's the peoples that have the problem. Typically, you ju...

They work fine, you just need to know how to handle them.

Now if we do a hash and we dont find them in Target. Both these records go as Inserts Not necessarily. That's your choice based on the job design. If you need the first to go as an insert and the second as an update - update the hashed file! It other words, write any hashed 'misses' into the same l...

There is no problem with either spaces or colons in UNIX pathnames. And using the DSJobStartTimestamp macro in a sequential filename works fine as I just built a quick test job to verify that fact for myself. It will also 'open in the sequential file stage' (aka View Data) just fine as well with th...

It's been discussed before and still confuses folks, like Ken it seems.

The Enterprise Edition (EE) is Server and PX. The Extended Edition (or XE) is, as noted, Server and MetaStage bundled - and is far from a 'new' product.

Kim hosted it on his website for us. There is a post in the Site forum noting this, somewhere where it wouldn't immediately 'roll off'.

No clue... and you should ask over there if you want to pursue it.

Ray? And it was more of a 'Married with Children' reference rather than a Texian one.

Stage / Properties tab, Sort Specifications field.

:D This comes from 'back in the day' when I needed to do something very similar. Pre-DSXchange, so no insta-help... just did it the old fashioned way - checked the help and applied liberal amounts of grey matter. Oh, and it was uphill. Both ways. Barefoot. In the snow.

If you're trying to use the 'short name', the old 8.3 that hides under the long names that are allowed now - you need a number, more than likely a '1':