Multirow inserts

[Former Member]

Sybase has the ability to make an insertion multi rows? If yes, what version is available? If not, has plans to develop?

[VolkerBarth]

Such a pity that "open database documentation" like this page doesn't list the great features of SQL Anywhere... sometimes the "invisible database" is way too invisible to get its deserved audience:(

[Former Member]

For older versions without the repeating values enhancement or where you might be doing a translation substitution, the following works..

  create table #E (idSituationCUR unsigned integer, txMessage char(150), idSeqRead integer default 0);  
-- using openxml to simplify the load and set a default value should the Join with 
  -- CodelistTranslation fail to find a corresponding entry
  insert into #E (idSituationCUR, txMessage)
  select LOAD.idSituationCUR, isnull(CLT.txOther,LOAD.txOther)
  from OPENXML( string ('',
      '',
      '',
      '',
      ''),
    'a/b' )
  with ( idKey integer '@c1', txOther text '@c2', idSituationCUR unsigned integer '@c3') AS LOAD
  left outer join BOS.CodelistLanguage CLT on CLT.idCodelist = 238 and CLT.idLanguage = @idLanguage and CLT.idKey = LOAD.idKey;