DSXchange

thank you - I knew the problem was resource constraints, just didn't know why. So, is nproc a Unix setting or a DS setting?

It took forever to get them to let me run this <sigh>. Anyway, the jobs within the sequence that failed are some of the ones that read a dataset, and then write to 16 complex flat file stages. There are sorts on the links going into the CFFs. all jobs are running sequentially job that reads complex ...

Thanks, but the issue here is not speed (although that may become an issue later), but with not aborting due to Resource Constraints. The master sequence does call the sub-sequences sequentially, and each sub-sequence calls its five jobs sequentially as well. I will definitely ask about local vs. SA...

We have a master sequence that calls a number of sequences, all of which have five jobs. The first job creates a dataset, then the next four jobs read the dataset, and create 16 files (complex flat files) each. The last four jobs of each sub-sequence are identical, except that the constraints are ha...

What is the If statement that you used? Are you using one of the NullTo... functions?

Since the error message is pointing to the field that has the number of occurrences - do you think that it has more than 100 occurrences in this record of the data? Can you look at the data at its source?

Since it looks like you're using Transformation eXtender (not Datastage), you'll need to create a group in your output that corresponds to your group in your input. (the input group being within the record, your output group being a "virtual" group of records). Also - make sure that your i...

Thank you very much, Craig - I feel so much better - my eyesight may be bad, but I wasn't missing it! (only the reference to it ... )

-Susan

I've been searching and searching, and cannot find which manual has the command line documentation (dsjob, etc).

Can someone point me to the right one?

thanks!

I'm having the same problems. The RDBMS stage is rejecting my rows (and rightly so - there's a constraint error), but my reject link doesn't get anything.

Have you found a solution yet ?

I have searched here, and found 1 thread that talks about someone using a Schema File to define their output metadata, and it not working, and then in the very last message they posted "it's working now". <sigh> If anyone has experience using Schema Files with Column Import, I'd love to he...

The "Maximum Message Length" is a Queue setup parameter - perhaps that is set too small in your queue? ... Finally figured it out. I had to lie to DS and tell it that the file that I created in one job with CFF (with 127 fields, about 1/3 of them defined as COMP-3) was actually a Sequenti...

Yes, you will need to concatenate the fields to one; you can use a transform stage or a column export stage to effect this. ... Okay - I've concatenated a couple of different ways - and was able to send to the Queue. However, only 72 of the 775 bytes of the now one field was received (again, all 4 ...

Sorry, my mistake. Don't you just have one data output column called "Payload", which comprises all the column data, to which you write? The template for this is in Table Definitions -> Real Tim ... Well, unfortunately, I can't see your whole message. I'll make a guess - and look for the ...

ArndW wrote:Have you tried using the MQ Connector stage? We are using MQ from mainframe with very long and variable message sizes with no issues. ...

That's what we're using - CFF Stage to MQ Connector Stage. We are not receiving messages, we're sending.

Thanks.