DSXchange

Thats ArndW, yet again at his humor. The first time was when I read his reply to one of the posts that had 10 or more interview questions. That was one hilarious post, I couldnt stop laughing for several minutes together

Is it possible that you are getting data that is larger than what you have defined?

With stage variables. Search this forum for more details on how to compare present row with previous using stage variables.

Hit start on your desktop, go to programs, go to Ascential DataStage ---> online manuals, click on "DataStage documentation". You will find the guide there.

Not that I know off. One of the primary reason being that C is widely used and has been around for many years and hence a lot of reference material can be found online.

Parameterize it. Run this job via a sequence job so that you can pass

to get the list and pass it to the parameter.

Well, its kind of hard to teach you a new language just through description. You have to go through language syntax, create your first program "Hello World", go through some functions etc etc etc. Ill give you a piece of code, you can go through it, google up the functions, see what they do. //heade...

Well DataStage is not just an "L" tool its and "ETL" tool. Fastload wont be able to do a percent of things DataStage does.
Lets hope IBM gives you a patch for it or an acceptable workaround.

Go through the Ascential DataStage Installation and Configuration Guide for Supplemental Stages. It will tell you what you need to know. Briefly, you need to set the following environment variables.

DB2DIR
DB2INSTANCE
INSTHOME
LD_LIBRARY_PATH1
THREADS_FLAG

If IBM is not able to find a solution then you can load your records to a flat file and generate a sql script. Invoke the teradata utility and execute the sql scripts.

Is this the first time you are trying to connect to DB2? Are all the environment variables set properly in the dsenv file? Can you connect with your current username and password from command line?

Are you throwing interview questions at us ???

I knew what you meant, was just fascinated by the term "farm" in that context

Black Hole , technically, is an astronomical term. Figuratively, its used to refer to glitches in the system. You should not worry about black holes in DataStage per se. As per your project, you need to make sure that all ends are tied, tightly. You did your error handling , restartability and all ...

My dad used to warn me about this. He used to warn me about how youth can push a person to extremes and how a person pays for it once the age wagon starts going down hill. Moderation is the key. Anything a person does, extremes are never to be crossed. As Kim put it, let someone else be superman.