DSXchange

I solved the problem: Stop All DS services Changed uvconfig in such a way # NLSDEFDIRMAP - Name of the map to be associated # with type 1 and 19 files that do not specify a map # in their directory (that is, were created on a # non-NLS system and have not had a SET.FILE.MAP # done on them). NLSDEFDI...

I tried to put the file .uvnlsmap to the target folder for OPENPATH statement. Nothing happened. Then I tried to use FolderStage to read file names in directory (putting .uvnlsmap right near the folder) The same result - ?????? characters still present in a target -- .uvnlsmap file -- MS1252-CS 3509...

by ArndW I have made it in such a way *********************** StartLoop: READNEXT vFileName ELSE GOTO EndLoop Call DSLogInfo('File found: ':vFileName,'Debug') Call DSLogInfo( SEQ(vFileName[LEN(vFileName)-4,1]),'Debug by ArndW ') *********************** And got results CJMasterScoring..JobControl (De...

Sorry - with MS 1251 it is still the same xls2stScoring..XLS_DATAFILE: CONNECTIONSTRING='Provider=Microsoft.Jet.OLEDB.4.0;Excel 8.0;Database=D:....\A001200601263453123_??????.xls'. Interesting behavior of DataStage: Ctrl+C file name (in Win) and paste to Job Parameters page Ctl+V PRM_XLS_DB = A00120...

Previous try - all was UTF-8 Tried to change Project Defaul map name to MS1251 Control Job NLS - MS1251 (Basic code above) Running job (where OLEDB works ) - MS1251 OLEDB stage log: xls2stScoring..XLS_DATAFILE: CONNECTIONSTRING='Provider=Microsoft.Jet.OLEDB.4.0;Excel 8.0;Database=D:\...\A00120060126...

Hi all. The problem is with the representation of file names after the next code Cyrillic data in this files are transfered correctly through jobs - the problem only with file names... ***************************************** OPENPATH prmPath TO vFileVar THEN SELECT vFileVar END ELSE Call DSLogInfo...

I need to pass each Input row [input_col1,input_col2...input_colN] as a parameter! No one knows the value of Input column at design-time! Only at run - time values vill be passed... pay attention to the Output link: call proc1(input_col2,...input_colN,...input_col1) How to refer from Output tab to t...

Hi all! I have a small problem can anybody help me? Env: DataStage ver 7.5 , MS SQL Server On a DB server there is a stored procedure proc1(arg1, arg2) - returns ResultSet [col1,col2...colN] Job contains a stage (ODBC or Stored procedure) with: Input link [input_col1,input_col2...input_colN] How to ...