DSXchange

Hi Ray , it worked. In my code iam searching for the "status=" in the log file, for each job the string appears 2 times. so my output for for name in `cat $LOG_DIR/logdetailsequencer |grep status=|awk '{print $2 $6}'`; do jobname=`echo $name|sed 's/status=/ /g'|awk '{print $1}'` jobstatus=...

Thanks for the quick response.

The error log is getting created in the file with size 0 and iam getting the error. all the parameters are passing corectly.

Thanks Ray

Hi, Iam executing the job from unix , dsjob -run ---- working fine Iam trying to get the log only for the failed jobs in the sequence , i have the following code for name in `cat $LOG_DIR/logdetailsequencer |grep status=|awk '{print $2 $6}'`; do jobname=`echo $name|sed 's/status=/ /g'|awk '{print $1...

Thanks for the quick responseRay,

If the data is 1/1/2006 then iam getting 01-01-2006 as output, when it is null then iam getting *******. I want to handle the null here


Thanks
Srividhya

Hi Iam converting a string to date . Input string is in 10/1/2007 format. So in the transformer I have five stage variables. 1.SDate = Left(DSLink2.Maturitydate,10) 2.ScrMonth =If Len (Field(DSLink2.Maturitydate,"/",1,1))=1 then "0":Field(DSLink2.Maturitydate,"/",1,1) e...

Thanks Ray,

Iam using Test -s , option -z is to check a string not a file. Am i doing correct .......

Thanks
Srividhya

Hai Ray,
I never abort my job, if any of my check failures iam inserting a row in the reject table with the reason for that rejection.
But I dont know how to do the check in this case

Thanks
Srividhya

Hai Iam using FTP stage to read the source file. I have to abort the job if the source file is empty. If the iam reading from the sequential file then i can use wc -file name then trigger my job. But using FTP plugin stage I have no clue how to handle this. I can do the rowcount after the job and ab...

Thanks ArndW

I didnt specify the metadata for the target files, now i specified no quotes in the metadata and it works

Thanks
Srividhya

Hi Ray, Iam running my jobs hrough dsjob, but i want to e-mail this CSV file, My second question is in csv file , all the field are having (quotes). but i need quotes only for the text field, for numerics and dates i dont want quotes. How to implement this in CSV file. MY CSV FILE "iu",&qu...

Thanks Ray

Hi logic
I already splitted the file into three files as header, details, trailers with a extra column rownum which has number of the header
I got stuck after that
can you please explain me

Thanks
Srividhya

Hi i want to convert the fixed width file into a CSV file. Input file many headers, details,trailers Source: FHDRhsyd8739diuh -- header 21 column iu7yew766jdhsyutwqhfhi --- detail has 32 column ys8yeh105hiopgsttqghfe --- trailer has 13 column FTLR2hd FHDRkhws7429fwyu kiutue738gywjsd743hsdt iuebjdr76...

Hai nhv, In the output properties check against metadata --- yes line termination --- [CR][LF] (DOS Style Termination) Fixed width column --- yes space between columns --- 0 All the other properties are to be default In the ouput column give the length of the row (fixed width) you can also check, if...

Thanks Roy, I understood the concept, i have the exception in stored procedure, but I dont know how to handle exception throw in stp stage.
Iam using stp as target so i dont have any output from stp stage.
Can you help me in handling the situation.

Thanks a lot
Srividhya