FW: SQL error

Problem solved.   An environment variable was not set.

Regards,

Sandy Sawmy
MCS Ltd

>  -----Original Message-----
> From: 	SAS Sandy Sawmy 
> Sent:	Friday, February 11, 2005 13:47
> To:	'[email protected]'
> Subject:	FW: SQL error
>
> Database: DB2 V8.1
>
> OS: RedHat Linux 8.0
>
> 4Js BDL version: 3.54.02.20
>
> Regards,
>
> Sandy Sawmy
> MCS Ltd
>
>  -----Original Message-----
> From: 	SAS Sandy Sawmy 
> Sent:	Friday, February 11, 2005 13:42
> To:	'[email protected]'
> Subject:	SQL error
>
> Hello anyone,
>
>
> During program execution the following SQL statement:
>  	SELECT accyer, accper, calsta INTO ls_tranyer, ls_tranper,
> ls_calsta
>             FROM sy_calendar
>             WHERE cpycod = pi_cpycod
>              AND modcod = pi_modcod
>              AND pi_trandat BETWEEN perstr AND perend
>
> causes a program crash with the error below:
> 	SQL driver fatal error in SqlHandle.c (line 33)
> 	Empty sql statement provided
>
>
>
> Regards,
>
> Sandy Sawmy
> MCS Ltd
>


====================================================
DISCLAIMER:
Confidential or privileged information may be contained in this message. If you are not the intended recipient of the message, please notify the sender immediately.

Opinions, conclusions and other information expressed in this message are those of the sender, else otherwise stated by the individual sender, to be those of MCS Ltd, to whom no liability shall be attached whatsoever.
*****************************************************