Are Job parameter names case sensitive?
Posted: Tue Nov 20, 2018 1:51 am
Hello there,
Recently I recognized that a job parameter name, that I expect to be case sensitive, seems to work correctly when being used in a SQL database stage (in my case it is Oracle) in a SQL statement. It seem to be recognized at run time correctly even if being used in different upper/lower letters.
While the DataStage "view data" function does NOT recognize the parameter (which I believe is correct) and gives an error because it can't resolve the parameter - the job runs correctly when started.
Anyone come across this "feature" as well...?
Regards
Klaus
p.s.: We were using a parallel job, Datastage 9.5
Recently I recognized that a job parameter name, that I expect to be case sensitive, seems to work correctly when being used in a SQL database stage (in my case it is Oracle) in a SQL statement. It seem to be recognized at run time correctly even if being used in different upper/lower letters.
While the DataStage "view data" function does NOT recognize the parameter (which I believe is correct) and gives an error because it can't resolve the parameter - the job runs correctly when started.
Anyone come across this "feature" as well...?
Regards
Klaus
p.s.: We were using a parallel job, Datastage 9.5