DSXchange

uses a hashing algorithm for distributing records in one or more groups on disk

arasan

If u want to remove blank spaces just u can use covert char function that can help u to remove blank spaces.just try this function

convert(char '000',' ' "inputcol")

In DS director u got a option called clean up resources click that u can able be kill the process of the specific job.i hope this will work.

Thanks & Regards
Arasan

Hi Please Refer to me What is the exact reference between Informatica&DataStage.

Hi,
How to Remove Duplicate records in Server Jobs .

seqfile>>>>>>>>>transformer>>>>>seqfile (source) (target) for example: step1: i have n number of records in source i want to split 999 records and send that to one file. step2: in the second file i want the end of record of first file +next 998 records in the second file.(now the second file should ...

my input is 1980/06/02 (sequential file)
output should be 1980-06-02 (sequential file)

i know that this could be done uning transformer can any body suggest me how it can be implemented using modify stage.

give the syntax for this if you know.

can any one explain me what is the difference between joiner and lookup
and when we can use lookup and when we can use joiner.

required syntax to covert string to integer using modifystage

how to add 2 input time columns

for example:

input A ----- 200408160545
YYMMDDHHSS (YEAR/MONTH/HOUR/SEC)
+
input B ------ 0030(HOUR/SS)

OUTPUT SHOULD BE IN THS FORMAT: 200408160615

Is it possibe the BASic DS routine code can be used in px