diarux - and make sure you're passing your context variables from the Parent to the child by checking the checkbox on the tRunJob component (transmit whole context). Other than that, should be "SELECT * FROM " + context.current_TABLE
Hello. Even if I use the following syntax, I still have an error : "SELECT * FROM " + context.current_TABLE I passed my context variable from the Parent to the child. Context variable "current_TABLE" is defined as follows : ((String)globalMap.get("row1.nom_table")) I don't understand why it doesn't work.
Hi diarux, Use the fallowing syntax for using context variables in sql. "SELECT * FROM \""+context.current_TABLE+"\"". Make sure that you have to enable transmit whole context check box in setting of tRunJob in parent job.
current_TABLE is defined in parent job as : (String)globalMap.get("my-Table.nom_table") num_utilisateur is defined in parent job as: Integer.parseInt(jobName.substring(1,2)) Error message when running child job : Exception in component tMSSqlInput_1 java.sql.SQLException: Syntaxe incorrecte vers 'FROM'