DSXchange

Posted: **Tue Mar 30, 2010 4:48 am**

Hi,
i am taking this one as a source for my job i have mentioned recorddelimeter is whitespace and fild delimeter is end. just i am replacing where i have EXT_EMP with job parameter.This one working in 8x.but when i am doing this one in 7.5x its not working.if i calulate "EXT_EMP" of length it showing 10 but length is 9.Please help me...

Code: Select all

BEGIN HEADER
   CharacterSet "CP1252"
   ExportingTool "Ascential DataStage Export"
   ToolVersion "4"
   ServerName "system5"
   ToolInstanceID "SDS"
   MDISVersion "1.0"
   Date "2010-03-29"
   Time "11.25.35"
   ServerVersion "7.5x2"
END HEADER
BEGIN DSJOB
   Identifier "EXT_EMP"
   DateModified "2002-01-13"
   TimeModified "11.19.04"
   BEGIN DSRECORD

Thanks
ksr

Posted: **Tue Mar 30, 2010 6:53 am**

A little lost on exactly what it is you are doing... can you explain how it is you are finding / replacing / calculating the length of EXT_EMT, please? The more details the better.

Posted: **Thu Apr 01, 2010 5:17 am**

in seq file i am specifying recordedlimter as whitespace, final delimeter is end and under columns i am typing
FILED001,FIELD002
if we read that file we wil get like this
[code
FILED001 FILED002
BEGIN HEADER
CharacterSet "CP1252"
ExportingTool "Ascential DataStage Export"
ToolVersion "4"
ServerName "system5"
ToolInstanceID "SDS"
[/code]

I am wring derivation in transformer stage
if filed002="EXT_EMP" then "CST" else filed002(this derivation for field002)
.it eexcuting in version 8.but i want to do same one in 7.5x but its not working(not replacing in place of EXT_EMP)

Thanks
sr.....

Posted: **Thu Apr 01, 2010 5:58 am**

Not all lines will have 2 columns. You need to declare just one column per line, then parse the contents in your job.

DSXchange

Reading Dsx file Error

Reading Dsx file Error