DSXchange

Sorry the "no sex please we are british" is a reference to an old and slightly corny film. If you can't have fun with test data then when can you have fun. http://www.imdb.com/title/tt0070450/ Thanks for the advice - this seems to work a treat - I still kind of think that it should work th...

Hello, I am trying to use RCP (Runtime Column Propagation) together with BuildOps. I am trying to write a buzzword lookup process that check a field for a particular word. I am outputing a flag with Y or N depending whether I see I buzzword or not. This works fine for my main input and output links....

Hello, Thanks for your replies/help. I looked in the log: $DSHOME/../PXEngine/java/JobMonApp.log ... ResponseParseHandler created. Fatal Parsing Error Occurred:The element type "responses" must be terminated by the matching end-tag "</responses>". Received malformed xml syntax......

Hello, I have a job that is hanging for around 40 minutes before crashing with the following message: main_program: SIGPIPE signal received in APT_JobmonFilter::writeMessage. Caused by closing of socket on port 13,400. Turning off job monitoring for the rest of the job. "If a process tries to w...

Hello,

Ah ha a solution. An occasion where the datastage documentation does not match the orchestrate documentation...

From Orchestrate 7.0 Operators Reference
Thanks for your suggestions.

Cheers,

Adrian

The problem is that you can't set field level attributes on a reject file. I was referring to doing this BEFORE the flat file output in a Transform Stage. This way, your records will NOT be rejected for that particular reason. -T.J. Ah ha I understand - sorry me being a bit slow. I can put a transf...

Teej wrote:
If it is a database field - Make it Varchar (or something equivalent to this).

If it is a flat file, use the function Space(19).

-T.J.

The problem is that you can't set field level attributes on a reject file.

bigpoppa wrote:Is this for a sequential file export?
-BP

Yes it is a sequential file export but it is a reject file...

Hello, I am seeing the following error messaged on rejects link : Insert_Rejects: When checking operator: When validating export schema: At field "DT_ADDED": "null_field" length (1) must match field's fixed width (19) I cannot see a direct way to change the null_field length for ...

ray.wurlod wrote:Would you believe "it's a feature, not a fault" ?!!

I'd agree with that :D - still it would be nice if the documentation told us about these features...

Hello, We have just migrated from v6 to v7 of Parallel Extender DataStage. Most of the jobs that we migrated have been working fine which is good. However I have noticed that the behaviour of Merge and Join appear to have changed in that it is no longer necessary to sort prior to the Merge or Join s...