Line feed char in EBCDIC is X'15', but if the result will be useful if you insert
X'15' chars in your SELECT result will depend on the tool you use to further process
your SELECT results. How do you do this? If, for example, the result is written by
a C program, the resulting file has the line feed characters, and all could be well.
But if you process the SQL using SPUFI or DSNTEP2 or remote access tools
like DB visualizer, your output will be corrupted, at best. Don't know what happens
if you process the output using, say, REXX or ISPF services.
Kind regards
Bernd
Am 02.12.2012 10:39, schrieb E.C::
>
> Hi
>
> I am trying to write an SQL using PIPE symbol to prepare a Bind card
> and would like each option in the BIND command to appear in the ext line
>
> Eg: -
>
> Bind Plan(xxxx)
> Qualifier(xxx)
> Owner(xxx)
>
> and so on..
>
> How do i put in a line break or anything similar to that...
>
> I tried using X'0D' called carriage function but getting an output in
> the same line like
>
> Bind Plan(xxxx) Qualifier(xxx)
>
> Please advice
>
> Regards
>
> E.
>
>
> -----End Original Message-----
|