Hi ,
I have a job that retrieves a select statement (contains backslash) from a file and returns this value in a userstatus variable and passing this userstatus variable in next job as as user-defined SQL in netezza enterprize stage.
problem is userstatus not reading compleate select statement containing backslashes
example--
select * from emp where empno=\'xxx\'
Any ideas how to achieve this.
userstatus not reading string containing backslashes
Moderators: chulett, rschirm, roy
yes its userstatus issue ,it should look like select * from emp where empno=\'xxx\'
but ended up like select * from emp where empno=
i am using above sql(userstatus) as query(read methold-user defined sql ) for netezza enterprize stage.... is there any other escape char i can use insted of backslash (\) ???
but ended up like select * from emp where empno=
i am using above sql(userstatus) as query(read methold-user defined sql ) for netezza enterprize stage.... is there any other escape char i can use insted of backslash (\) ???
You shouldn't need to escape the quotes any more. Check this technote to see how to allow them to be retained.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers