Hi, Anyone please let me know why we get this warning ? what is the default array size ? what is the maximum we can use? where do we change this from ?
Insert_TD,0: [IIS-CONN-TERA-005010] The estimated row length of 41 bytes multiplied by the array size of 2,000 is 82,000 which exceeds the maximum buffer size of 64,260
Seems to me, everything is in the error message you posted. Your array size needs to be no more than 1567 with that row length to ensure the buffer size is not exceeded.
-craig
"You can never have too many knives" -- Logan Nine Fingers
How can anyone answer that for you unless they are clairvoyent? You haven't given any details like database, stage, etc. We can guess Teradata, but that's about it.
-craig
"You can never have too many knives" -- Logan Nine Fingers