DSXchange

Click on the column name to activate it, then right mouse click and choose the "edit row" option, that brings up the window where you can set the specific column attributes.

You have filled up your T30FILES descriptors with all of the hashed files you have opened. Look at your uvconfig file settings; you can increase the value to accomodate all these concurrently opened type 30 files, or you can make these files static and thus use other descriptors. The best solution i...

Now that the language or method is established, which part specifically are you having trouble with?

You need to make sure that each instance running in parallel gets a unique instance identifier

Joe - did you try the reset on the job?

RakshaPai - I am confused whether this error is when reading the sequential file or trying to write to it. If it is an output sequential file, can you right mouse click on the column in the stage and "edit row". I suppose the column is declared as nullable, which the sequential file doesn't like. Se...

balajisr, you are right. ARRGG!!! I missed that part of his description. The job, after saving changes, has a status of not compiled and therefore cannot run.

Is there additional information in the log file when you reset the job, i.e. and entry titled "from previous run..."?

The quote from the documentation recommends choosing a length greater than 4Kb.

Are you reading from or writing to the database?

Balajisr - good catch! I saw the problem as well, but got caught in a short meeting before being able to hit "post", and now I'm editing out my response since you did a better job in the meantime!

Ray - Naaaah, I'll let you wait. I'll just ignore any posts to that effect News78 - do you see that your "one line of data" can also be interpreted as "One file with rows of 5-byte fixed length data with no separator"? This is what bcarlson was driving at - you don't need to change your data around,...

What is your input stage passing xxx into the transform and is the nullability of xxx the same there? Also, I would recommend removing the parenthesis around the else clause of the derivation {but I don't think that is causing your problem}

that sounds like a bug. If you RESET the job from the director, does the dsjob -run still fail? Also, will it fail after a RESET if run from the director?

Are you reading from or writing to this stage? In your first post you stated "loading" but now I am not sure. It seems that the OCI stage has truncated the string, so the OCI stage definitions are relevant. In DataStage Server the length of a VarChar field does not actually limit the length of the s...

KKsr - that is a question whose answer is a very fundamental part of DS. It is a big topic, best read the Parallel Job Developer's Guide , page 43 onwards in the chapter on "The Configuration File". Any remaining questions can be asked here. In a couple of words - scratch is where temporary data goe...