DSXchange

Thanks Kashyap,
Both of the commands worked like charm.Much appreciated

Hi , I have used sed command successfully in the Filter property of sequential file stage in the past to get sed -e '1d' -e '$d' --> all records without header and trailer sed '1!d' --> just the header record sed '$!d' --> just the trailer record But I want to get just the header and trailer using a...

Hi craig, Thanks much!!! this piece did the trick. Cmd3= " SELECT MAX(ZONE_AVG) FROM MDR.ZONE_CONTROL WHERE ZONE_ID =' " :p_ZONE_ID: " ' and ZONE_CD=' " :p_ZONE_CD: " ' ; " I should have been careful with double quotes , single quotes and the append operator colon : Reg...

Thank you both, I don't want to modify my sequncer.I want to do it in routine @ craig, Bascially, I am not trying to pass any parameter into the running job Cmd3="DELETE from MDR.ZONE_CONTROL where ZONE_AVG=(SELECT MAX(ZONE_AVG) FROM MDR.ZONE_CONTROL WHERE ZONE_ID =12 and ZONE_CD='NY') ; "...

Hi, This is my before job routine using which I am running one oracle sql command using sql plus ErrorCode = 0 ;* set this to non-zero to stop the stage/job *Below values are job parameters and passed to the routine through InputArg ORA_UID = Field(InputArg,';',1) ORA_PWD = Field(InputArg,';',2) ORA...

Hi , I am having a job sequence uservariableactivity--->execute command activity In the execute command acitvity, I am using a SQL statement to delete records from a table In command: echo "SET HEADING OFF;\n delete from CUST.CUST_BAL where seq_id ='#uservariableactivity.seq_id#';\n exit\n"...

Hi Gurus,

Any of you had a chance to look at my previous post?Please do reply.

Thanks,
Raja R P

Thanks Craig and Ray!!!! Conduct a test. Write your records to a flat file, note the time it takes. Remove all of the 'set null' handling, rerun. Did you confirm it actually did a BULK load? (DIRECT=TRUE) I did this.Not much difference between the two runs( In fact, the job with all setnull() was 3 ...

Thanks Craig and Sura, As Suggested I have added, Index mode= rebuild Add COMPUTE STATISTICS=True Add NOLOGGING =True But still, the job ran for 9.45 hrs(same job completed in 11 hrs without index option ) to load the same number of records. Actually, In The transformer in between the source and tar...

Hi, We have one parallel job which loads data into an oracle table from a dataset(as designed below) Dataset-->Transformer---->Oracle Enterprise Stage The transformer doesn't have any major transformations apart from doing setnull() for a few fields. This job took 11 hours to load 40 million records...

Hi, The below job FTPs a file from the mainframe system to the Unix server and outputs the contents to a Complex Flat file which can be read in next job. FTP enterprise stage --->Transfomer---->Complex flat file stage On execution, the job aborts with the below fatal error CFF_Stg1: Error occurred d...

Thanks Craig!!!! I was able to make it working by Trigger1: Trim(command_activity1.$CommandOutput ,@FM)> 1 Trigger2: Trim(command_activity1.$CommandOutput ,@FM)= 1 (or) Trigger1: convert(@FM,"", command_activity1.$CommandOutput)>1 Trigger2: convert(@FM,"", command_activity1.$Comm...

Hi, I have job sequence Based on the the output from the execute command activity(command_activity1), two different instances needs to be triggered. This is what i put in the command wc -l /filepath/file1.txt | awk '{ print $1 }' The execute command activity has two links(triggers).Both are conditio...

Thanks Ray and Andy,
It worked.I Used DecimalToString

Hi, In a parallel job, the target is a seq file with two columns(one char field and one decimal field(4,2)) If i do a 'view data' from the SF stage, I am able to see the data properly. Char_field|decimal_field a1234|4356.73 But If i try to open that from unix cat filename.txt Char_field|decimal_fiel...