Mapping/substituting SQLBase functions to Oracle

General discussion forum about all databases other than SqlBase.
Krischu

Mapping/substituting SQLBase functions to Oracle

Post by Krischu » 05 Oct 2015, 10:05

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

--
Christoph

FRBhote
India
Posts: 2212
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Mapping/substituting SQLBase functions to Oracle

Post by FRBhote » 05 Oct 2015, 14:25

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests