DSXchange

quote:Originally posted by vmcburney
[br]- Using sequential files for creating bulk load dat files and not the sequential file stage.


Can you clarify this point for me? I'm a bit confused...

-T.J.


* * *

... now if this can make breakfast, my life is complete.

quote: Originally posted by chulett [br]I'm not worried about the 'dsjob' part as I've been thru that before. What I'm wondering about is if there is any way to pass back 'custom' return codes to Control-M (or AppWorx) from a Sequence job? Well... this is not a direct answer to your question, as I h...

quote: Originally posted by Johnno [br]Has anyone worked in an environment where DataStage jobs are instigated via the AppWorx scheduling software? If so, could you please provide some information on how these two applications sit together and how error handling occurs? Or point me in the direction ...

Hello folks -- I would like to hear from any PX users out there concerning optimizing DataStage jobs for performance reasons. In our project, we are shifting over a half-billion rows back and forth from and to Oracle tables. If we were able to shift 100,000 rows per second, then I would not be here ...

quote: Originally posted by vmcburney [br]*** If this step fails with a login error or fails to find the database you will need to contact your network support for them to verify your network connectivity and your oracle configuration. These are issues outside of DataStage. Basically tell your DBA t...

Umm... call Metagenix technical support?

-T.J.

quote:Originally posted by dsproj2003
[br]Hi,

I have PX 6.0.

[discussion of requirements]


Hmm. Sounds like a Buildop stage to me.

As Ray said -- consultants love to do stuff like this. Too bad I'm not one... yet.

-T.J.


* * *

... now if this can make breakfast, my life is complete.

quote: Originally posted by kcbland [br]you will be faced with using MetaStage or the Reporting Assistant in order to do every day work such as: Hey Ken -- Just in case you are not aware, Reporting Assistant is a deprecated feature, and is supposingly removed by Twister's release. Ascential has been...

Hey folks --

If you're using DataStage on Tru64 Server, please give me a buzz. Thanks!

-T.J.


* * *

... now if this can make breakfast, my life is complete.

If anyone is interested, I will be attempting to install this in the upcoming weeks (maybe next week?), so I can identify any issues that I found during this process. Of course, I'm sure there'll be plenty of folks posting on here if the issues are serious enough. -T.J. * * * ... now if this can mak...

Well...

The Enterprise went back in time to 1986...

So it's possible!

But of course, you'll need a talking mouse to get THAT version to work.

-T.J.


* * *

... now if this can make breakfast, my life is complete.

The way I would do it (mind you, this is what I did for PX, not Server): Just have an input stream, and a lookup stage with reference to the Oracle table. If there is a match on the key field, output to the database stage with SQL specific for update. If there is no match, reject to the database sta...

quote: Originally posted by roy [br]the problem, as I mentioned, is that after 20, or so, good runs of the entire process from start to finish I get the hunged links with status starting and they simply stay like that indefinitly[:(] Sure sounds like the job just died or... 1. Are you auto-purging o...

quote:Originally posted by ekareem
[br]If you could zip and e-amil me any or all of the above that would be great.


Unfortunately, we would be violating our licencing policy if we were to do that. Sorry.

-T.J.


* * *

... now if this can make breakfast, my life is complete.

quote: Originally posted by roy [br]all I have is several select with ORA9i in paralel, which go to a transformer then seq files. As far as I know, the Startup status clock ticks while Oracle is trying to figure out how to handle the queries. Is your queries complex and pulls from tables with large ...