DSXchange

Or you can pass Timestamp as part of File name ( FileName_#FILE_TIMESTAMP#.txt) dynamically from Sequencer job or Job Control job.

Or you can pass Timestamp as part of File name ( FileName_#FILE_TIMESTAMP#.txt) dynamically from Sequencer job or Job Control job.

2008-09-22 (YYYY-MM-DD) Create 3 stage variables svDATE -- svYYYY : '-' : svMMDD ( this will give you 2004-09-22) svYYYY -- 2008-09-22[1,4] - 4 = 2004 svMMDD -- 2008-09-22[6,5] = 09-22 In derivation convert svDATE from STING to DATE using this function StringToDate(%datestring%,["%yyyy-%mm-%dd&...

2008-09-22 (YYYY-MM-DD) Create 3 stage variables svDATE -- svYYYY : '-' : svMMDD ( this will give you 2004-09-22) svYYYY -- 2008-09-22[1,4] - 4 = 2004 svMMDD -- 2008-09-22[6,5] = 09-22 In derivation convert svDATE from STING to DATE using this function StringToDate(%datestring%,["%yyyy-%mm-%dd&...

mysqldsn] Driver=/d01/Ascential/DataStage/ branded_odbc/lib/branded_odbc/lib/ VMmysql23.so Description=MySQL ODBC 3.51 Driver DSN SERVER=65.91.255.2 Database=edw1kn PORT=3306 USER=guest Password=welcome1 OPTION=3 SOCKET= check the odbc drivers library path it seems you have entered twice It supposed...

Check VMmysql23.so odbc driver in
/d01/Ascential/DataStage/branded_odbc/lib/branded_odbc/lib

Did you create entry in uvodbc.config

<mysqldsn>
DBMSTYPE = ODBC

Oh Sorry , I didn't noticed this thread is of Server.

1). awk 'END{ print NR}' <filename>
Execute Command stage will return value 10 in char format.
2). Convert Exec Command stage return value to Integer using User Variable stage.

suppose to generate the one surrogate key for the combination of natural keys but for each duplicate it is creating the new key. Before generating Surrogate Keys remove duplicates on you NATURAL KEY COLUMNS using Remove Duplicates stage. Use same column or set of columns which you are using in KeyM...

You can identify what is new & what is changed using CDC stage (Change Data Capture)
For new record Insert Code = 1
For Updated record Edit Code = 3
These codes are built-in in the CDC stage.

Hi All,

I am getting below error message while importing job from from one evironment to another environment, any idea what does this means.

Error writing record Local.msh to file RT_SC137 - error number is 40019

I did search for this error in DSXchange, but didn't find any thread posted on this.

Help files in version 8.0.1 are messed-up, it's very hard to find help on functions, plug-ins, DS Macros, DS Function, DS Contatants.

DataStage integration with Websphere screwed-up all help files, they are no more user friendly the it was until 7.5.x.

Try below links, may be useful!.

http://staff.in2.hr/denis/oracle/nls_data.html

http://www.microsoft.com/globaldev/nlsweb/default.mspx

Actives stages , such as the Transformer and Aggregator, perform processing tasks, while passive stages , such as the Sequential File stage and Hashed File stage, are reading or writing data sources and provide services to the active stages. Above is extracted from DataStageServer Job Developer Gui...