DSXchange

Thanks a lot!!


Reg Minna

stringtotimestamp, what is a syntax?

Hi!
SELECT TO_CHAR
(EVENT_TIMESTAMP, 'YYYY-MM-DDHH24:MI:SS') from SOURCE
-> need to convert field for datetime -format, but HOW?

StringToDate or StringToTime? I

Reg Minna

Now It is okay! NLS_LANG="American_America.WE8ISO8859P1";export NLS_LANG LC_ALL="American_America.WE8ISO8859P1";export LC_ALL LC_CTYPE="American_America.WE8ISO8859P1";export LC_CTYPE LC_COLLATE="American_America.WE8ISO8859P1";export LC_COLLATE LC_MONETARY=&quo...

Hi!
I edited dsenv script. re-boot server and now tried to run job. Error message is now:

Oracle error: -12705
ORA-12705: Cannot access NLS data files or invalid environment specified



Minna

ray.wurlod wrote:That's because you did not set NLS_LANG in your changes. You set LANG, but not NLS_LANG.

<- Thanks Ray!

I modified dsenv script, as below: LANG="American_America.WEISO8859P1";export LANG LC_ALL="American_America.WEISO8859P1";export LC_ALL LC_CTYPE="American_America.WEISO8859P1";export LC_CTYPE LC_COLLATE="American_America.WEISO8859P1";export LC_COLLATE LC_MONETA...

I modified dsenv script, as below: LANG="American_America.WEISO8859P1";export LANG LC_ALL="American_America.WEISO8859P1";export LC_ALL LC_CTYPE="American_America.WEISO8859P1";export LC_CTYPE LC_COLLATE="American_America.WEISO8859P1";export LC_COLLATE LC_MONETA...

Thanks a lot!


Reg Minna :D

Hi Gurus! I got following warning: main_program: An NLS character map <ISO-8859-1> is specified, but NLS_LANG is not set; the NLS character map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG. <-Please explain me that what is a right place to set NLS_LAN...

SAP R/3 Pack has the following methods for ABAB extractor data transfer: RFC (remote function call), CPIC and FTP. According to IBM SAP R/3 Pack version 6.0.0 does not support RFC data transfer for non-Unicode SAP systems. Despite of that they provide RFC source files for both non-Unicode (ZDSRFC.TX...