DSXchange

i am passing the input values to DSjobReport as
1;c:\temp\;


but when i run it ...there is an error in the log sayin

(DoJobReport): Failed to open directory c:\temp\

what are the parameters for this function

i am passing the input values as
1;c:\temp\;
for the dsjobreport

but when i run it ...there is a error
(DoJobReport): Failed to open directory c:\temp\

how should i pass on the parameters ....i have datastage on a Windows system

but wher do you actually write the code so that i can execute this code in datastage so that it will write into my file

OpenSeq "c:\TEST\TEMP.TXT" To TestVar Then
WeofSeq TestVar ;
WriteSeq "test line -- writing a line into file" To TestVar;

well thanks for the replies .... i am reading the books but i am not even half way through ....

I need to write some predefined/static text and also some variables such as DSgetlinkinfo and someother parameter values into the File.

what are the functions to write into a sequential file. .... how can this be done

@INROWNUM or @OUTROWNUM was the one that worked for me

i get a CSV file i am reading it and inserting/updating a table based on conditions I need to get the values of how many rows are in the file: Is there any function that does this how can i know which row number from the file is being processed ...so that if that row fails i can insert into log file...

there is no number in line num field ...i need to generate a sequence which will increment by 1 each time i insert

i am trying to load a file into a table...whenever i load each row i need to increment the value of the line num field by 1 and insert it into the line number field of the table ...how do i do this.

also how can i set default values ....most of the fields in the tables should be set to default ....

i am trying to load a csv file into a table ... [DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field overflow. i am getting the following error .... the date field is in M/DD/YYYY FORMAT AND the date format for oracle database is DD-MON-YY ... im just starting my first task in datastage so any ...