DSXchange

vskumar08

OP made multiple posts and issue was resolved in other one : http://dsxchange.com/viewtopic.php?p=236800&highlight=&sid=c7dbf1a7132fb219091645d8702258e8#236800 Resolution suggested : APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expec...

vskumar08

JoshGeorge wrote:APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected

Thanks, it is working perfectly fine.

vskumar08

nick.bond wrote:Out of curiosity what is the source you have with 600 columns?

Error: ##F TFDR 000043 13:36:21(001) <Oracle_Enterprise_3,0> Fatal Error: Virtual data set.; output of "Oracle_Enterprise_3": the record is too big to fit in a block; the length requested is: 134048.

any suggestion???

vskumar08

Is this the same question as the one in this post ? ... Yes, this is the same question Error: ##F TFDR 000043 13:36:21(001) <Oracle_Enterprise_3,0> Fatal Error: Virtual data set.; output of "Oracle_Enterprise_3": the record is too big to fit in a block; the length requested is: 134048. an...

vskumar08

The Oracle Enterprise stage does not use ODBC, so anything you found there is probably not relevant. It remains unclear whether the block size referred to here is something inside DataStage (such a ... whatever, I am new to DataStage...so it is very natural that I make some mistakes. the question i...

vskumar08

balajisr wrote:What is the length of the column defined in columns tab?

each column is around 255 in length. Does this information matters????

vskumar08

I am getting the error as FATAL ERROR: Virtual data Set;.....; the record is too big to fit in a block; the length requested is : 135012. when i am running the DataStage and trying to load data using Oracle enterprise.

Can anyone suggest me how to over come this

vskumar08

What precisely do you mean by external datasource in this context (for there's no such terminology in the product as far as I am aware), and where is this record size limit documented? I am using an Oracle Enterprise Stage to extract data from oracle 10g, but getting the error as FATAL ERROR: Virtu...

vskumar08

It depends on a number of factors. For example, if you are reading via ODBC then the limit is 400 columns by default, though this can be changed by specifying MAXFETCHCOLS in the uvodbc.config [/i ... okay, Can anyone tell me how to increase External datasource Record Size in DataStage which has a ...

vskumar08

ray.wurlod wrote:It depends on a number of factors. For example, if you are reading via ODBC then the limit is 400 columns by default, though this can be changed by specifying MAXFETCHCOLS in the uvodbc.config [/i ...

Thanks mate, it worked

vskumar08

Is there a limit on the number of columns that can be read by a DataStage. First, I used Oracle Stage to read a table with 600 columns but could not able to view data in that stage. I could able to view data of tables with 200 columns. Can anyone suggest me whether there are any settings to be made ...

vskumar08

If you are looking for a BASIC transformer routine you can look in the SDK folder via DataStage Manager. If you are looking for a parallel job transformer routine tutorial try my blog post [url=http: ... Thanks for your reply mate,. Yes, I am working with Parallel jobs and I want to write a sample ...

vskumar08

hai guys,
need help to write a sample routine, any doc.

I have gone through Basic Guide in the docs folder of DataStage but it doesn't have any topic on writing a sample routine. Please...., if anyone can help me.

Thanks

DSXchange

Search found 13 matches

the record is too big to fit in a block;

increasing External datasource Record Size in DataStage

column limit in DataStage

need help to write a sample routine, any doc.