Re: SQL integers and refflds in DDS

[Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>]

Simonse, Arco (CMK) wrote:
> Hello,
>
> I investigate to use SQL as DDL for a new small project in our company.
> At this moment we still use DDS as DDL, but we like to make the move to
> SQL for DDL. 
> But when it comes to the display files, I'm still dependent of DDS to
> define them. 
> And there is also the problem: When I use reffld's in my DSPF to the SQL
> defined files, I got stuck with integers. 

Why? It is perfectly possible to define decimal fields in SQL. Only drawback is 
you can't specify editing.

Joep Beckeringh



> We wanted to use them for file keyfields, but because they are saved as
> binary, I can't use them at the same time as reffld in DDS and as
> integer field in RPG. In RPG I use the EXTBININT keyword, but in DDS
> there's not such a keyword as far as I know. Are there solutions or
> workarounds for this problem? And anyway, is it a good idea to define
> the keyfields as integer keyfields? Or is it better to use the decimal
> type?
>
> Best regards,
> Arco Simonse
>
> DISCLAIMER:
> This message contains information that may be privileged or
> confidential and is the property of C.Meijer B.V. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy,disseminate, distribute, or use this message or any part thereof. If you
> receive this message in error, please notify the sender immediately and delete all copies of this message. 
>
> This footnote also confirms that this email message has been swept by the 
> presence of computer viruses