I just studied the breaking changes of 2.04:

<<
You must now use string expressions for column references in the SQL/PSM
cursor FETCH, INSERT, and UPDATE statements.
>>

Is it true that I have *not* to change normal sql-statements like:

sql.add('update mytable set myvalue = :FValue)?

Uli

Uli,

<< Is it true that I have *not* to change normal sql-statements like:

sql.add('update mytable set myvalue = :FValue)? >>

Correct, only SQL/PSM INSERT, UPDATE, and FETCH statements are affected, not
the normal DML INSERT and UPDATE statements.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Correct, only SQL/PSM INSERT, UPDATE, and FETCH statements are affected,
> not the normal DML INSERT and UPDATE statements.

Ok, thanks. And scripts have to be changed as well? So this:

Execute Immediate 'Insert INTO TempPrivatLeistungen
(LeistungenID,PatientenID,ScheineID,OrderID,BehandlerID,Datum,Uhrzeit,Ziffer,
ZifferIndex,Begruendung,Faktor,Preis,Summe,Hoechstwert,Anzahl,BesondereKosten,Abgerechnet,
HoechstwertPreis,Abzug)

has to be changed to

Execute Immediate 'Insert INTO TempPrivatLeistungen
(''LeistungenID'',''PatientenID'',''ScheineID'',etc.?

Many quotes.

Uli

Uli,

<< Ok, thanks. And scripts have to be changed as well? So this:

Execute Immediate 'Insert INTO TempPrivatLeistungen
(LeistungenID,PatientenID,ScheineID,OrderID,BehandlerID,Datum,Uhrzeit,Ziffer, ZifferIndex,Begruendung,Faktor,Preis,Summe,Hoechstwert,Anzahl,BesondereKosten,Abgerechnet, HoechstwertPreis,Abzug) has to be changed to Execute Immediate 'Insert INTO TempPrivatLeistungen (''LeistungenID'',''PatientenID'',''ScheineID'',etc.? >>No, only SQL/PSM INSERT, UPDATE, and FETCH statements that work againstSQL/PSM cursors need to be converted.   Anything that you execute in anEXECUTE IMMEDIATE statement or EXECUTE statement is a DML or DDL statement,and the changes don't apply to them.--Tim YoungElevate Softwarewww.elevatesoft.com

Tim

> No, only SQL/PSM
> INSERT, UPDATE, and FETCH statements that work againstSQL/PSM cursors
> need to be converted.   Anything that you execute in anEXECUTE IMMEDIATE
> statement or EXECUTE statement is a DML or DDL statement,and the changes
> don't apply to them.

But you write:

<<
Routines that are created with 2.04 or higher, and non-persistent
routines such as scripts, will require the new syntax.
>>

That's why I asked.

Uli

Tim ,

I think I understand now:

Exectue Immediate within a script *or* a procedure does not require the
new syntax, working with a cursor in both cases *does*, correct?

I hope, I won't mess that up.

Uli

Uli,

<< I think I understand now:

Exectue Immediate within a script *or* a procedure does not require the new
syntax, working with a cursor in both cases *does*, correct? >>

Yes.  The difference is: when I say "SQL/PSM", I mean these:

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=sql_psm_statements

when I say "DML", I mean these:

http://www.elevatesoft.com/manual?action=topics&id=edb2sql&section=dml_statements

The two different categories of statements aren't interchangeable, although
you can prepare/execute DML statements from the PREPARE/EXECUTE/OPEN and
EXECUTE IMMEDIATE SQL/PSM statements.

--
Tim Young
Elevate Software
www.elevatesoft.com