We are using stage SybaseIQ Load. We can set parameters like DBNAME, SERVER, etc. Job compiles without error but when we execute the job we get an error and by checking the log in director we can see that the variables have not been replaced by the value specified in the parameter file (We see that DBNAME is #DBNAME# while we would expect to be replaced by the real value).
Does anyone know how to solve the problems ? Can it be a "bug" in datastage ?
When you see #DBNAME# (or any value surrounded by "#") in your job log it suggests strongly that that job parameter was not set for this job run.
Could it be that your job uses environment variables, and the parameter reference should therefore have been #$DBNAME# ? Or is the parameter reference simply misspelled where it is used in the job design?
There are probably other things you could check, but it's not a bug in DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.