DSXchange

When I tried increasing it - it errored out saying : Sequential_File_486,0: Fatal Error: Virtual data set.; output of "Sequential_File_486": the record is too big to fit in a block; the length requested is: 350000005, the max block length is: 131072. And this maximum block length is less t...

If i try these numbers i am getting different error message as : $APT_DEFAULT_TRANSPORT_BLOCK_SIZE = 268435456 $APT_MAX_DELIMITED_READ_SIZE = 1345550119 $APT_MAX_TRANSPORT_BLOCK_SIZE = 1048576 Sequential_File_486,0: Fatal Error: Virtual data set.; output of "Sequential_File_486": the recor...

Sorry yeah , this is what I am getting .


Sequential_File_486,0: Consumed more than 1345550119 bytes looking for record delimiter; aborting

Hi we are getting data from CLOB column from db2 in flat files with a column of length 2 GB . we were trying to read this data into datastage . we were able to read column with a length of 200 MB successfully,but after that we were receiving failure.In the data , for that column - we defined it as L...

I am sorry , just now learning the parallel routine and worked for a simple one .May be some silly questions , but want to take the expertise. can i invoke multiple parallel routines in a single transformer ?cause for some reason only one routine is working for me in that case .Did i miss anything ?...

Thank you so much.I have changed it and it is working now . I am processing 80 records in the lookup table . I have never used a array before and thought this way would be better .

Not sure if I can ask , but Do you have any sample program which loops through an array.

Thanks again.

Hi we want to do some patteren matching with a look up file(with 800 rows) and reject the data which does not match the criteria . It will not be a straight match up and so I have created a parallel routine .So basically I am taking the input and comparing the values against a look up file .But this...

Hi As part of our project , One of the sources for us is on Lotus Domino database . So other than the web services method , want to check if it is possible to connect to Lotus domino database using datastage 8.5 from unix box . When I googled , they are saying the odbc drivers to connect to Domino d...

Hi We want to perform some global replace in the jobs for one of a string .Currently we are on 8.5 version . We want to use the command line option to export the jobs and do a global replace in the dsx file .But as in 8.5 , it creates isx file when we export from command line , seems like it is not ...

Hi All

We have some jobs defined with some message handlers to handle the warnings at the job level. Is there any way to scan through the jobs and figure out if they have message handler defined for them? Is that possible ?

I would really appreciate all your time and inputs regarding.

Thanks a lot .Using the Bulk load Option , I am able to resolve the issue.

I have found out that in our environment the buffer size is :1,000,000 bytes and I am exceeding this limit as per the calculation.

I am performing a insert into a Teradata table .

How should I Overcome this and deal with these type of wider rows ?

Thanks for all your inputs.

Hi All

Thanks a lot for all your response.I have used Datastagemetadata import
for importing the metadata.But not sure , how to find out the limit on the Buffer size. Is there any way I can find out that limit ?


Thanks for all your time .

Hi Recently we have migrated to Datastage 8.5 and also to Teradata .I am using the Teradata connector stage and want to load the data into table . This table has 118 columns and it is failing : Copy_3_of_Teradata_Connector_85,0: RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum. As ...

Hi Ray

The hash file got created using a server job .

I have deleted the hash file completely on the server and ran the server job .After that I have created VOC entry : using the ED VOC command and then tried to create the index , which is failing .