Re: SQL Function

[Mark Walter <MWalter@xxxxxxxxxxxxxxx>]

DGETPRGDATE       PR            10i 0 
DdaysToKeep                     10i 0 const 

Mark Walter
Paragon Consulting Services, Inc.
IBM Certified System i Specialist
717-764-7909 Ext. 26
mwalter@xxxxxxxxxxxxxxx
www.paragon-csi.com



"Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/15/2008 02:40 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: SQL Function






Hi Mark,

Your CREATE FUNCTION statement doesn't specify the parameter style.  The 
default is SQL.  What does the RPGLE prototype for your function look 
like?

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

Mark Walter wrote:
> I changed to BIGINT, and still nothing. Any suggestions what I should be 

> using? 
>
> Mark Walter
> Paragon Consulting Services, Inc.
> IBM Certified System i Specialist
> 717-764-7909 Ext. 26
> mwalter@xxxxxxxxxxxxxxx
> www.paragon-csi.com
>
>
>
> rob@xxxxxxxxx 
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 02/15/2008 11:39 AM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Subject
> Re: SQL Function
>
>
>
>
>
>
> Please explain to me how you got a numeric yyyymmdd to fit into an 
> integer?
>   RETURNS INTEGER 
>
> Rob Berendt