Thanks Kashyap,
Both of the commands worked like charm.Much appreciated
Search found 145 matches
- Fri Aug 07, 2015 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get Header and Trailer record using a single sed command
- Replies: 2
- Views: 3204
- Thu Aug 06, 2015 6:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get Header and Trailer record using a single sed command
- Replies: 2
- Views: 3204
Get Header and Trailer record using a single sed command
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...
- Thu Nov 14, 2013 6:06 pm
- Forum: General
- Topic: Passing runtime values to an sql command in a routine
- Replies: 5
- Views: 4146
- Thu Nov 14, 2013 3:41 pm
- Forum: General
- Topic: Passing runtime values to an sql command in a routine
- Replies: 5
- Views: 4146
- Thu Nov 14, 2013 1:54 pm
- Forum: General
- Topic: Passing runtime values to an sql command in a routine
- Replies: 5
- Views: 4146
Passing runtime values to an sql command in a routine
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...
- Thu Jul 11, 2013 9:53 am
- Forum: General
- Topic: Delete statement in execute command activity
- Replies: 4
- Views: 3849
Delete statement in execute command activity
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"...
- Tue Jul 02, 2013 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading records takes long time:Oracle enterprise stage
- Replies: 7
- Views: 5389
- Mon Jul 01, 2013 9:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading records takes long time:Oracle enterprise stage
- Replies: 7
- Views: 5389
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 ...
- Sat Jun 29, 2013 12:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading records takes long time:Oracle enterprise stage
- Replies: 7
- Views: 5389
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...
- Thu Jun 27, 2013 11:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading records takes long time:Oracle enterprise stage
- Replies: 7
- Views: 5389
Loading records takes long time:Oracle enterprise stage
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...
- Wed Apr 03, 2013 11:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with complex flat file stage
- Replies: 2
- Views: 3116
Issue with complex flat file stage
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...
- Mon Dec 24, 2012 5:15 pm
- Forum: General
- Topic: Execute command not triggering the proper trigger
- Replies: 2
- Views: 3645
- Fri Dec 21, 2012 7:40 pm
- Forum: General
- Topic: Execute command not triggering the proper trigger
- Replies: 2
- Views: 3645
Execute command not triggering the proper trigger
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...
- Fri Dec 21, 2012 3:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal getting stored as Junk value in Sequential file
- Replies: 3
- Views: 4079
- Fri Dec 14, 2012 2:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal getting stored as Junk value in Sequential file
- Replies: 3
- Views: 4079
Decimal getting stored as Junk value in Sequential file
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...