DSXchange

Thanks a lot ArndW, Its working for me.

Hi,

I need to have tab as a delimeter between two columns for the file I generate from datastage.

For ex: A<tab><tab>B<tab><tab>C

Is there any function like Space function in ds using which we can generate tab?

Thank you,
Svengiyil

Thanks a ton Ray and Priyadarshi....It worked.

Hi,

I need to remove the space which comes in between a column value.
For ex if the value is "abc def", I should populate this value as "abcdef".

How do I achieve this?

Thank you,
Svengiyil

I just got my solution from the reply given by Arndw in the below link http://www.dsxchange.com/viewtopic.php?t=103857&highlight=Job+stopped+-+before-job+routine+returned+error%3A+Error+1+returned+from+BEFORE+routine+DSU.ExecDOS, However i have a concern here, i finally specified H:\path1\Script...

Hi I have to place a file from target directory to source directory before the job run is complete, for which i'm using a DOS script and running it in the before job sub routine. while running the job , its throwing an error which says BeforeJob (ExecDOS): Error when executing command: H:\path1\Scri...

Thanks Sainath,

I used the row generator stage as input and it works fine now.

Hi, I need to compare two files and capture the change,I have two files file1 and file2 as input,passing it to sort stage srt1 and srt2 respectively. I'm passing the output of the sort stages to a change capture stage Cap_Um. Under the Options in the chage capture stage , I have chosen change_Mode=E...

Hi, I have a requirement to generate a fixed width file with just the header and trailer, i.e header will display current date and trailer would display "Record Count=0000000000". For this I tried to use a transformer with two output files one for the header and the other for the trailer, ...

Yeah.....the datatype in the target is also char..

Thanks,
Svengiyil

my target is sequential file itself , i tried changing the variable value $APT_STRING_PADCHAR to 0x20, even after this the resultant column contains null value (same as before).

Thanks,
Svengiyil

Hi,


I found the variable $APT_STRING_PADCHAR and changed the default value to 0x20...it still din't work for me.

Thanks,
Svengiyil

sorry..not director....will i find $APT_PADCHAR setting in the administrator?

Hi Craig,

The datatype is char, and could you please let me know where exactly will i find $APT_PADCHAR, is it in the director?


Thanks,
Svengiyil

Hi, I have a requirement in which one of the column abc of length 20 (nullable not a key column) has to be left aligned and space padding is to be done if the column value is less than 20 (i.e, if the length is 5 then, after first five char there should be a space of 15). Here i have used a stage va...