DSXchange

... and that entirely separate DataStage manual is the Technical Bulletin I noted above.

If you have enough memory to load the hashed file into memory Then it will be shared. Not true, I'm afraid, if you simply mean the 'Preload file in memory' option in the stage. As I noted earlier, there are steps to leverage system caching that are noted in the Hash Stage Disk Caching technical bul...

Looks like you actually have to search for error loading "orchoracle" (including the quotes) to find what I assume is the post they are referring to. Make sure you put lstsaur as the Author to narrow things down, otherwise you'll be trawling through 50 matches.

ps. I moved this to the General forum as it really is a general topic and not specific to any of the job types.

Saying the "latest" file doesn't really narrow things down, I was asking how strict you need to be in ensuring you have just recieved the "right" file. Sure, one simple way to make detection easier is to move processed files to another area, an archive area for example, once your...

Upgrading what? All you've shown us so far is an Oracle error and the first thing you should do is take that to your DBA, see what suggestions they have.

In other words, only you rsunny can determine if you'll be fine processing this particular "dat" file with the sequential file stage. You know what it looks like, how the fields are defined - we don't. If you're not positive you know exactly how each field is defined, get back together wit...

The job is in "aborted/restartable" status and we do not need to reset it to run again the next time when it is supposed to run. But in my case , the job is in "aborted/restartable" status and when it runs the next day as per the schedule, it does not run and gives the message a...

FYI, split this off from an old discussion of the 8.5 Beta in the General forum and moved it here.

Adding checkpoints gives the Sequence the ability to be restartable, but whether you can or not depends on the Status it ends up in after a failure. It must be in an "Aborted, Restartable" status otherwise you'll manually need to Reset it before you can run it again. Assuming here we're ta...

What is your target, another string or a date field? Assuming date from what you posted but you haven't explicitly said. And is your source a string still or did you set it back to a date?

It would probably help if you posted some actual samples of the values you are seeing in the file.

Welcome aboard.

Can you be more specific about what "Unable to View Data" means? What exactly are you trying to do and what error or behaviour are you seeing?

Define for us in words what "the right file" means here... what are your rules to validate the "rightness" of it?

Neither of which will work with a single digit month or day. As requested, let us know your what your target is - another string or is it a Date? Answer will change for the latter.

What makes you feel you need a date column or anything unique? If those two key columns identify what record(s) need to be updated per operation, you're fine.