ADSM-L

Re: SQL Formatting on AIX scripts - SQLDISPLAYMODE

2001-12-03 11:44:03
Subject: Re: SQL Formatting on AIX scripts - SQLDISPLAYMODE
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Date: Mon, 3 Dec 2001 11:41:17 -0500
Todd, here's another way around the problem:

Add -commadelimited as a parm after -pa=.

That causes the output to come out in a wide string, with the fields
separated by commas, no wrapping.

Since you are doing this from AIX, it's very easy to handle that output in
the shell script.

You could, for example, pipe the dsmadmc command to a tr command that just
translates the commas back to blanks.