Re: SQL Extraction

Matt Feeney asked...

>     Select * from crbm/dof_per where dp_pay_id = 16 (simple !)

>     Sequel/Excute view(smqrydfn/disp_dp) outfile(ftplib)

>     Number on the table:   276.12- Zoned 
>     Number on the Outfile: 0002761K

>     If I run an SQL query on the Outfile the data looks good. If I look at 
>     the data using DSPPFM, the data has characters showing for negatives.

>     Why is this happening ? How do I get around it ?  

Believe DSPPFM on dof_per or its based on physical will show the SELECTed 
field in question looks the same way. Switch to hex on the DSPPFM to see 
how the 400 stores a negative signed number:

FFFFFFFD <-- the 'D' here represents a negative number
00027162      if it were an 'F', the value would be positive

There are different ways around this, depending on the purpose of the 
outfile. If attempting to generate a file for a PC, one nice feature of 
SEQUEL's EXECUTE command is the (?) parm that allows specification of a 
PC filetype, use DIF, CSV, SYLK or whatever's supported and put the file 
out to a shared folder, then use CA on the PC to open (import) it.

HTH, 

--Jerome



/* -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- */
/* Jerome Hughes                        jromeh@aol.com                 */
/* InterPro Consulting Services         www.interproinc.com            */ 
/* Rosemont IL USA                      these are my own opinions only */
/* OMNI User Communications Director    www.omniuser.org               */
/* -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- -=- */
Spark's Law of Problem Solution: The chances of solving a problem decline
the closer you get to finding out who was the cause of the problem. 
-- Gerald Weinberg, The Secrets of Consulting

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---