What's the maximum length for context variable value to be defined in Talend Open Studio?
I am facing below error with my running fine query, only difference I could see is I've parameterized it and passed values from context variable, not hardcoded in Talend job during deployment.
"Java Exception|tNetezzaInput_1|org.netezza.error.NzSQLException:The action you have attempted has caused the back end to close the connection."
Please advise if somebody has faced this error before and resolution about same.
@Bapps,context variables length is depending on the datatype what you specified.
please check the below links to knwo the datatypes maxium lengths.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema