DSXchange

I need to transfer every day near 200 tables from SQL SERVER to ORACLE incrementally. For make the process automatically I need to create buffer table by parameter of table name with incremental data from SQL SERVER on ORACLE and then make DELETE-INSERT to the main table. There is no problem execute...

You can do it in before sql section this way:
Declare
Begin
SQL statement;
SQL statement;
SQL statement;
...
End;

And what about elementary logic?
Oracle, for example, can't convert this string to date by to_date function and sends it to exceptions. That is a right action because "0?002" or "00222" are junk but never valid date

So as your mind strings "00222" and "0?002" are a valid dates?
No comments...

Your explanation didn't explain how "00222" converted to date "09 Aug 2000"

But how DS convert "00222" to date "09 Aug 2000"?
And how DS interprets "?" in the string "0?002"?

Here is a part of IsValid function which checking if a date is valid: Date: * Date in current locale format or in ISO 8601 format (YYYY-MM-DD) Test1 = Iconv(argTestValue, "D") ; * current locale Status1 = Status() Test2 = Iconv(argTestValue, "DYMD") Status2 = Status() Ans = (Stat...

U r wellcome

In UNIX you need only LF - char(10).

Hi, use the char() function which generates an ASCII character from its numeric code value. Then numeric value of LF is 10 and CR is 13.
So concatenate: "your text" : char(13) : char(10) : <input field>.