Mapping/substituting SQLBase functions to Oracle

[Krischu]

Is there a translation map that converts SQLBase (inline, as shown here ) Functions to Oracle functions?

--
Christoph

[FRBhote]

You have to do it in your sql.ini like:

[oragtwy]

substitute=SYSCOLUMNS,COL
substitute=PCTFREE 99,PCTFREE 10
substitute=NOT NULL WITH DEFAULT, DEFAULT 0 NOT NULL
substitute=DATETIME,DATE
substitute=TIMESTAMP,DATE
substitute=DATESTAMP,DATE
substitute=TBNAME,TNAME
substitute=@SUBSTRING,SUBSTR
substitute=X.ROWID,X.ROWID||X.ORA_ROWSCN
substitute=@UPPER,UPPER
substitute=@DECODE,DECODE
substitute=@VALUE,TO_NUMBER
substitute=@DATEVALUE,TO_DATE
substitute=@TRIM,TRIM
substitute=@ABS,ABS
substitute=@LOWER,LOWER
substitute=@ROUND,ROUND
substitute=@LENGTH,LENGTH
substitute=@CODE,ASCII
substitute=@CHOOSE,OCHOOSE
substitute=@STRING,TO_CHAR