Hello Alois,
indicator variables are not mandatory. The precompiler only prints out some warnings. 
You programs should also run without indicator variables. But, without indicators you 
cannot check for NULL-values etc. Please note that you should run the precompiler with 
the option -S oracle (cpc -S oracle
<program name>) if your application was written for oracle databases.
 
Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Alois Egger [mailto:[EMAIL PROTECTED]]
> Sent: Mittwoch, 20. November 2002 10:27
> To: '[EMAIL PROTECTED]'
> Subject: indicator variables
> 
> 
> Hi! 
> Is it possible to skip the indicator variables in embedded SQL ? 
> We are evaluating now, if we can replace the Oracle DBMS by 
> SAP DB. It seems that our application programs are the main 
> problem. They are fully written without indicator variables. 
> And the SAP DB precompiler manual says, indicator variables 
> are mandatory (which is for ANSI compliance).
> The oracle precompiler has an UNSAFE_NULL option. This allows 
> us to compile and run our earlier written programs without 
> indicator variables. There is no error generated, if a null 
> value is fetched into a host variable.
> Is there a possibility to run the programs without indicator 
> variables (in Oracle mode)? Re-programming and include 
> indicator variables would not be an option.
> Thanks, Alois. 
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to