Transact SQL
Juan Manuel Salazar Santaria asked whether Informix has Transact-SQL style functions like Sybase or MS SQL Server. Helmut Leininger asked what was meant and described BEGIN WORK/COMMIT WORK transactions. Hal Maner asked which functions, noting some have counterparts. Art S. Kagel explained Transact-SQL is Sybase's dialect, Informix is mostly standards compliant, and some functions may have equivalents. No specific mapping was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
This is a multi-part message in MIME format. ------=_NextPart_000_01A8_01BEE9B0.CAC55B00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello... I want to know if Informix has Transact SQL functions like Sybase or MS = SQL Server, i had been looking for it but i don't find nothing. Thank u ------=_NextPart_000_01A8_01BEE9B0.CAC55B00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>Hello...</DIV> <DIV> </DIV> <DIV>I want to know if Informix has Transact SQL functions like Sybase = or MS SQL=20 Server, i had been looking for it but i don't find nothing.</DIV> <DIV> </DIV> <DIV>Thank u</DIV></BODY></HTML> ------=_NextPart_000_01A8_01BEE9B0.CAC55B00--
Juan Manuel Salazar Santaria wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_01A8_01BEE9B0.CAC55B00 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hello... > > I want to know if Informix has Transact SQL functions like Sybase or MS = > SQL Server, i had been looking for it but i don't find nothing. > > Thank u > > ------=_NextPart_000_01A8_01BEE9B0.CAC55B00 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META content=3D"text/html; charset=3Diso-8859-1" = > http-equiv=3DContent-Type> > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV>Hello...</DIV> > <DIV> </DIV> > <DIV>I want to know if Informix has Transact SQL functions like Sybase = > or MS SQL=20 > Server, i had been looking for it but i don't find nothing.</DIV> > <DIV> </DIV> > <DIV>Thank u</DIV></BODY></HTML> > > ------=_NextPart_000_01A8_01BEE9B0.CAC55B00-- Hi, could you explain what you mean by "Transact SQL functions" ? You can define transactions in Informix by "BEGIN WORK" and "COMMIT WORK". In case of troubles (i.e. COMMIT WORK is not reached) everything will be rolled back to the status at the beginning of the transaction (BEGIN WORK). Regards -- Helmut Leininger Bull AG / Vienna Unix Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.
Which functions specifically are you looking for - some probably have counterparts, some do not...
Juan Manuel Salazar Santaria wrote: > > This is a multi-part message in MIME format. > > Hello... > > I want to know if Informix has Transact SQL functions like Sybase or MS > SQL Server, i had been looking for it but i don't find nothing. Transact-SQL is Sybase's SQL dialect/extensions, MS SQL Server only supports this dialect because SQL Server V1.0 WAS Sybase for Windows and as usual MS managed to wangle themselves a contract that allowed them to take over the source and create competing product. But that is an aside. Like Oracle, Sybase never had an easy development environment so they packed as many features into their SQL extensions as possible. Informix on the other hand has ALWAYS had ISQL, 4GL, and ESQL/C with which users could easily extend the features of the database in their applications. Consequently the SQL dialect in Informix is mostly standards compliant. Informix supports ANSI SQL and it's own extensions, mercifully few BTW. However, some of the Transact-SQL functions may have Informix equivalents. Art S. Kagel