Re: SQL Newbie

[Ben Akiba <asfour00@xxxxxxxxx>]

Jose, your descriptions don't match. P 4  100 would be a packed number
in 7 bytes what translates to DEC(13, 0), etc.... Recalculate data
structure.

Vanja Jovic,

Canada

Jose Vega wrote:
> 
> Help!!
> 
> DS

>          P  4 100Ordnum
>          P 11 160Cusnum
>          P 47 552Taxamt
> 
> /EXEC SQL
> CREATE TABLE ARPC008
>    ORDNO DEC(7,0),
>    CUSNO DEC(6,0),
>    TAXTL DEC(9,2),
> /END-EXEC
> 
> 
> Confidentiality Notice:
> 
> The information contained and/or attached to this electronic mail is
> intended only for the person(s) or entity(ies) to which it is addressed and
> may contain confidential and/or legally privileged material.  Any use
> whatsoever of this information by persons other than the intended recipient
> is prohibited.  If you received this in error, please contact the sender
> and delete the material from your computer.
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---