RE: Field Type 'P' in a query

Was the file uploaded as a fixed length file?
What's the origin of the file?
Did you create a file when you uploaded it, or did the file (AS/400) already
exist?

John Brandt 
iStudio400.com 
(903) 523-0708 
Home of iS/ODBC - MSSQL access from iSeries and RPG. 




-----Original Message-----
From: Glenn Thompson [mailto:gthompson@xxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, October 28, 2004 2:24 PM
To: Midrange Systems Technical Discussion
Subject: Re: Field Type 'P' in a query


It was an ASCII file I uploaded to the 400.  Our OS version is V5R2.

I am not leaving out information on purpose.  It's that I'm extremely 
unfamiliar with the AS/400.

The source data is a string or CHAR.

Vernon Hamberg wrote:

> The terms "flat file" and "externally-defined" don't usually go 
> together in my mind, although they can. As Dan asked, what is the data 
> type of the source? Is it a single character field? What is the 
> formula you are using, if you are using a result field? If the source 
> is character and needs to be substrung and then converted to numeric, 
> this is hard in Query/400 but doable-you can use the MICROSECOND 
> function - can tell you more if you need this ugliness. You'd be 
> better off using an SQL query in a *QMQRY, using STRQMQRY with 
> OUTPUT(*OUTFILE). What release of the OS are you at?
>
> Vern


-- 
Glenn Thompson
Senior Analyst
American Trouser, Inc.
gthompson@xxxxxxxxxxxxxxxxxxxx


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/04