DSXchange

Publish the designs on your intranet, using the documentation generator in version 7.5. Then anyone can look at the design there without needing to invoke the client tools.

I would guess, given the size of the VarChar column, that SQL Server or the ODBC driver has generated the informational message referred to, alerting you to the fact that you are using a large row size. The largest row size permitted by default in the ODBC stage is 8KB; you can increase this limit b...

molanust wrote:Hi Ray,

I am not a premium member, so I am not able to read your reaction.
This just to let you know that I therefore won;t be ableto react to your reply.

Cheers

Tako

For less than $1 per week you can be a premium member.

I perform each individual test in a separate stage variable, then assemble the entire error message in another stage variable that I can use as the output column derivation in the error-reporting link. I also use DataStage macros to get job identification information on to that link.

... and you will need to Trim() the trailing quote character from the result generated by the Field() function in this case.

I have a completely different buildop - can you tell me what's wrong with it? (The point here is it's pretty much impossible to help on this without knowing what the buildop does, whether it calls isUsable() or whether that call is made elsewhere) and the schema of the data being handled by the buil...

Consult the documentation for the DB2 Universal Database for
OS/390 server and correct the condition described by the DB2
reason code.

This is not a DataStage problem.

Nripendra Chand wrote:In previous runs the job was running fine.

What has changed?

"Nothing" is not the correct answer.

Seems that way!

That you didn't point it out initially is why, of course, we didn't answer it initially - we read the question and answered that. I agree with Craig that you will need a Routine so that you can take an iterative approach - an expression containing 50 FieldStore() functions would probably exceed the ...

Can you create a job that uses Sequential File stages for both source and target? If that works successfully then it is clear that DataStage is handling the characters, and that the problem must be somewhere in the ODBC connection. We await your response on that, rather than suggest strategies that ...

Kim's routines were - I believe - based on my originals to which he referred.

Hai ray, Sorry for disturb you again ray: 1)Seq.FileStage------>SortStage----->Hashed.FileStage 2)Seq.FileStage------>SortStage---->Seq.FileStage----->HashedStage. While using 2nd option the job works correctly.But using 1st option it throws an error as "input col. cannot promote to an output.Col" ...

Hi all, My question is just on the best practices for two consecutives transforms. Transforms are used to do look up. What is the best 1 or 2 ? 1. Put a Hash File or Sequential between the two Look up 2. Nothing between the transforms Thanks ! Nothing between the Transformer stages. If you have mul...

Not unless you describe the job design in fairly full detail.

Otherwise your question is of the class "my car doesn't work, a red light comes on - can you tell me how to fix it?".