DSXchange

you need to check the input tab properties of ftp stage where we mention the Remote Path, please verify it for access and if it is correctly defined.

in your OCI stage for date field(column) change SQL type to Timestamp and it will work

please can you go through Merge Stage Guide pdf, all your doubts will be clear.

An output from sort stage to transformer, where you can check for restriction.

i think that your input date value is not in proper format,
first you convert your input date value in internal format using ICONV and then use OCONV with below format in which oracle OCI accepts date value for date field

Oconv(@date ,"D D-M-Y[,A3,2]")

imagining a job simple job design like source--------->T1------------------------->HASH-FILE |-------T2-----------------> from source, data extracts to transformer T1 and writes to hash file, and also data moves from T1 to T2, transformer T2 also writes to same hash file with setting as mentioned by...

hello chulett please can you elaborate.

in constraint put "equal to" condition...........i mean
WHERE table_1.column_name = table_2.column_name...........taking database concept into consideration...........

hello please use the SDK routine provide NumericRound0(12.8765) --->gives 13 as output.

convert your "," with "."

oconv(@date,"D/MDY[2,2,4]") gives output as 06/12/2008

SQL> select add_months(sysdate,6) from dual;

ADD_MONTH
---------
06-DEC-08

oconv(iconv('06/06/2008',"D/E")+182,"D/DMY[2,2,4]") ---gives output -->05/12/2008

hi dodda can you please provide more details regarding delete and update action, query and parameters required, so that we will be able to analyze something.

hello friend below link is good example, it will help you

viewtopic.php?t=97681&highlight=vertical+pivot

please may i know the setting, so that i can use dsjob directly on command line without using ./dsjob.

thanks,
sachin

hello friends i am getting following, please help why dsjob: not found is the message

$ pwd
/dw/dsadm/Ascential/DataStage/DSEngine/bin
$ dsjob -lprojects
dsjob: not found
$