DSXchange

From a co-worker? Anyone there you could tap for help? They wouldn't need to know anything about DataStage to be able to help convert a script to a batch file.

Not a job for the Merge stage, all you need is 'normal' lookup logic to determine inserts versus updates.

42 Key columns? Yeesh.

baglasumit21 wrote:Will it be more efficient to use a join in the sourch query itself?

I would think so. Why not give it a try and let us know?

Designer Guide pdf, chapter 5.

Ugh. Sounds like either a job for Vincent's Blogs (since he's probably written something on the subject) or contact IBM. I'm sure their sales people would be more than happy to provide that kind of documentation, especially if the goal is to sell your company the Enterprise Edition.

Help us help you. Is this your first time trying to access Oracle from a job? If not, is there anything different about this one from others that work?

Would need a wee bit more information to be able to help. First off, I don't see how changing your DataStage server's IP address would affect your ability to connect to Oracle instances on other servers. Those on the same server could be if your tnsname uses IP addresses. So... all jobs that access ...

That doesn't make any sense. You can't have a fixed-width file with no record delimiters and then say some records vary in length.

Unless there is a leading field in each record denoting that particular record's length?

You select it as field in your source or lookup SQL.

Welcome! :D

If you search the forums for your error text - "Unable to allocate Type 30 descriptor, table is full" - you'll find this has been asked and answered quite a number of times. Short answer, one of your configuration parameters is too low.

IConv to internal format, then OConv back, both with the proper mask:

Don't need to be converted at all, they will compare fine (dashes and all) as long as month and day are always two digits.

You really should be pointing to a instance of the table itself, not any exported DDL. Can you not create it somewhere you have access to, at least temporarily?

Agreed. It makes zero sense to try and recreate all that restart logic in a shell script when all you need to do is create a Sequence job that will handle all that automatically and then run the Sequence job via the script.

I posted how to disable it earlier in this thread.