Oppolzer - Informatik / Blog


Blog-Hauptseite      Neuester Artikel      Älterer Artikel      Neuerer Artikel      Älterer gleiche Kategorie      Neuerer gleiche Kategorie

DB2-L - Zeilentrenner (X'15') in SQL-Ergebnissen

Subject:

Line Break in SQL

From:

Bernd Oppolzer <bernd.oppolzer@T-ONLINE.DE>

Reply-To:

DB2 List <db2-l@lists.idug.org>

Date:

2012.12.02 11:39:00


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-----

Blog-Hauptseite      Neuester Artikel      Älterer Artikel      Neuerer Artikel      Älterer gleiche Kategorie      Neuerer gleiche Kategorie