On Sun, 12 Sep 2004 15:39:12 -0400
Stefan <[log in to unmask]>
wrote:

> I need to create flat files using Quiz/Qtp to extract data from an
> Image database that will be imported into another system. Character
> fields are not a problem but with numeric and date fields I have to
> covert them into strings in the following way:
>
> DEFINE CHAR-BDATE CHAR*8 = ASCII( BIRTH-DATE , 8 )
>
> Is there a way to skip this step and get Powerhouse to create the flat
> file with numerics and dates stored as strings?
>
> Thanks,
> Stefan

How is BIRTH-DATE defined?  If it is not an UNSIGNED ZONED DECIMAL
then some form of conversion is required and no, POWERHOUSE does not
auto-magically guess (and neither does SUPERTOOL) when the user wants
their data converted to ASCII and when they do not.  The user has to
tell it on a case by case basis.  If the original data is already
UNSIGNED ZONED DECIMAL then it is already an ASCII string as well and
no conversion is necessary.

Regards,
Jim

--

***     e-mail is NOT a secure channel     ***
James B. Byrne                mailto:ByrneJB.<token>@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3CE               delivery <token> = hal

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *