Guys, Has anyone experimented using Job parameters as input parameters to a shell script that is called using the EXECUTE COMMAND in a job sequencer? If i put hard coded values in the parameters box, the shell script is executed fine. But when i use job parameters (defined in the sequencer as well),...
Hi, I guess this is pretty long piece of derivation, but it gets the job done.. Oconv(Iconv(field(<linkname.columnname>, " ", 1, 1), "D-YMD[4,2,2]"), "D/DMY[2,2,4]"):" ":field(<linkname.columnname>, " ", 2, 3) if you need to get it written into oracl...
Guys, I have a situation where i am using an Oracle Enterprise stage with a user defined SELECT query which will read selected input values and pass them on to a transformer stage. In this SELECT query, i have a subquery which will return a standard value for each job run, and since i have combined ...