Outputting wide file for exporting

[Johnson, Tracy]

The following QTP should work as long as you don't have an array in your Image database:

>SET PROCESS LIMIT x
>ACCESS myimagefile
>SUBFILE mysubfile KEEP PORTABLE INCLUDE myimagefile
>GO

This will get you two named files, the file with the data will end with the letter Q.

You can manually import it into Excel as a column delimited file.  You'll have to make sure the columns are correct when importing.

If you *DO* have an image array, then you have to name individual fields instead of just the myimagefile.

Make sure 'x' is as least as big as the number of records in your image data set file.

BT


Tracy Johnson
MSI Schaevitz Sensors 

> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Raymond Schneider
> Sent: Tuesday, April 06, 2004 12:20 PM
> To: Powerhouse Listserv
> Cc: Ray Schneider
> Subject: Outputting wide file for exporting
> 
> 
> Hello Listers,
> 
> We are going to shut down our HP 3000 next Friday,
> April 16. We have reduced the use of the 3000 to
> almost nothing so there isn't much left on it. I do
> need to pull data from a few of the databases/files
> that still have important data in them. Because the
> users want to import the files into EXCEL, I am
> exporting them into tilde-delimited files with the
> first record containing the field names. Most of the
> output files are narrower than the 254 record width
> limit of QUIZ, but there are a few that exceed this
> limit. How can I output a file that is wider than the
> limit? QUIZ or QTP would work...we are on 8.19
> 
> Thanks,
> 
> Raymond Schneider
> Hamilton County Mental Health
> Cincinnati, OH  USA
> 
> 
> =====
> Raymond B. Schneider		(513)621-3045
> Hamilton County Mental Health Board	(513)632-7159 fax
> 801-A W. 8th Street			H-P 3000  MPE/iX 5.0
> Cincinnati, OH  45203-1601		Powerhouse 7.09E
> rays@hamilton.mh.state.oh.us
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business $15K Web Design Giveaway 
> http://promotions.yahoo.com/design_giveaway/
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to 
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to 
> powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a 
> subscriber.
>