DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 147 matches
Author Message
Resolved
 Topic: Get Header and Trailer record using a single sed command
RAJARP

Replies: 2
Views: 1920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 07, 2015 11:50 am   Subject: Get Header and Trailer record using a single sed command
Thanks Kashyap,
Both of the commands worked like charm.Much appreciated Smile
Resolved
 Topic: Get Header and Trailer record using a single sed command
RAJARP

Replies: 2
Views: 1920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 06, 2015 6:38 pm   Subject: Get Header and Trailer record using a single sed command
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: In Filter property of seq file stage
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 tr ...
Resolved
 Topic: Passing runtime values to an sql command in a routine
RAJARP

Replies: 5
Views: 2380

PostForum: General   Posted: Thu Nov 14, 2013 6:06 pm   Subject: Passing runtime values to an sql command in a routine
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 ...
Resolved
 Topic: Passing runtime values to an sql command in a routine
RAJARP

Replies: 5
Views: 2380

PostForum: General   Posted: Thu Nov 14, 2013 3:41 pm   Subject: Passing runtime values to an sql command in a routine
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 ...
Resolved
 Topic: Passing runtime values to an sql command in a routine
RAJARP

Replies: 5
Views: 2380

PostForum: General   Posted: Thu Nov 14, 2013 1:54 pm   Subject: Passing runtime values to an sql command in a routine
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 paramet ...
 Topic: Delete statement in execute command activity
RAJARP

Replies: 4
Views: 2095

PostForum: General   Posted: Thu Jul 11, 2013 9:53 am   Subject: Delete statement in execute command activity
DataStage® Release: 8x
Job Type: Server
OS: Unix
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 c ...
 Topic: Loading records takes long time:Oracle enterprise stage
RAJARP

Replies: 7
Views: 3207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 02, 2013 10:30 am   Subject: Loading records takes long time:Oracle enterprise stage
Hi Gurus,

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

Thanks,
Raja R P
 Topic: Loading records takes long time:Oracle enterprise stage
RAJARP

Replies: 7
Views: 3207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 01, 2013 9:35 pm   Subject: Loading records takes long time:Oracle enterprise stage
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? ...
 Topic: Loading records takes long time:Oracle enterprise stage
RAJARP

Replies: 7
Views: 3207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Jun 29, 2013 12:36 pm   Subject: Loading records takes long time:Oracle enterprise stage
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 complet ...
 Topic: Loading records takes long time:Oracle enterprise stage
RAJARP

Replies: 7
Views: 3207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 27, 2013 11:18 am   Subject: Loading records takes long time:Oracle enterprise stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 maj ...
 Topic: Issue with complex flat file stage
RAJARP

Replies: 2
Views: 1886

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 03, 2013 11:26 pm   Subject: Issue with complex flat file stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 --->Tran ...
Resolved
 Topic: Execute command not triggering the proper trigger
RAJARP

Replies: 2
Views: 2171

PostForum: General   Posted: Mon Dec 24, 2012 5:15 pm   Subject: Execute command not triggering the proper trigger
Thanks Craig!!!!

I was able to make it working by

Trigger1: Trim(command_activity1.$CommandOutput ,@FM)> 1
Trigger2: Trim(command_activity1.$CommandOutput ,@FM)= 1
...
Resolved
 Topic: Execute command not triggering the proper trigger
RAJARP

Replies: 2
Views: 2171

PostForum: General   Posted: Fri Dec 21, 2012 7:40 pm   Subject: Execute command not triggering the proper trigger
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 ...
Resolved
 Topic: Decimal getting stored as Junk value in Sequential file
RAJARP

Replies: 3
Views: 2608

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 21, 2012 3:28 pm   Subject: Decimal getting stored as Junk value in Sequential file
Thanks Ray and Andy,
It worked.I Used DecimalToString Smile
Resolved
 Topic: Decimal getting stored as Junk value in Sequential file
RAJARP

Replies: 3
Views: 2608

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 14, 2012 2:06 pm   Subject: Decimal getting stored as Junk value in Sequential file
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours