I would like to know how a new line character can be used within a dynamic sql. The main purpose is to format my query which is pretty huge so that when I re-direct it into a file the dynamic query doesnt get truncated.
Consider this SQL:
select 'select * from table.accounts where id=''Jack'' '
Thanks Jim. However, this dynamic sql is generated wit a simple bteq script i.e. a query generating a query. I used '0D0A'xc, but i guess that is the hexadecimal equivalent of EOF line character in DOS/Windows (\r\n). If my assumptions are right then I guess I should try the hexadecimal equivalent of '\n' which is EOF line character in UNIX. Any feedback guys?