Search found 9 matches

by Ragupathy
Wed Jun 16, 2010 11:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning 'Write failed for record id '
Replies: 5
Views: 4179

check the space

might be this problem
ray.wurlod wrote:Not sure what a "plz" is, so not sure whether "any one plz" can give you an answer.

While you're waiting for that, why not Search DSXchange? Curiousl ...
by Ragupathy
Wed Jun 16, 2010 1:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using XML Input Stage with External Source Stage
Replies: 7
Views: 8155

Hi after loading the table definations need to load the columns it will be tree like structure..... it is the error i think so.... this should be done in xml table data definations Thanks How did you generate the metadata / XPath Expressions you are using? From an xsd for your source file? Can you p...
by Ragupathy
Wed Jun 02, 2010 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using stored procedure in Datastage
Replies: 8
Views: 26384

Re: Using stored procedure in Datastage

SP stage can be used and to get count get rowcount using transformes
by Ragupathy
Wed Jun 02, 2010 5:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to schedule job or sequence in unix
Replies: 5
Views: 3319

Re: how to schedule job or sequence in unix

Hi

First write a syntax to run a job or sequence

and the schecdule using cron tab

Thanks
by Ragupathy
Wed Jun 02, 2010 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML OutPut stage
Replies: 2
Views: 2457

Re: XML OutPut stage

Hi

Check if it is installed correctly

Thanks
by Ragupathy
Tue May 18, 2010 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implementing If ElseIf End Function in DataStage
Replies: 5
Views: 16676

condition

chulett wrote:Pretty much just like that, without the assingments and the semi-colons. The TYPE field should be the target of the derivation and use something like this:

Code: Select all

IF B_DT >= PCKG_BEGIN_DT AND B_D ...[/quote]


we can give like this

  if 1=1 then 100 else  if 1=2 then  200  else 0
by Ragupathy
Tue May 18, 2010 5:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implementing If ElseIf End Function in DataStage
Replies: 5
Views: 16676

condition

chulett wrote:Pretty much just like that, without the assingments and the semi-colons. The TYPE field should be the target of the derivation and use something like this:

Code: Select all

IF B_DT >= PCKG_BEGIN_DT AND B_D ...[/quote]


we can give like this

  if 1=1 then 100 else  if 1=2 then  200  else 0
by Ragupathy
Thu Apr 29, 2010 3:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to achive this
Replies: 10
Views: 6641

Re: How to achive this

I have to build the job as per the below query. Can anyone tell me select a.act_id,a.create_DATE,a.Pay_TOTAL from payment_tab a where 1= (select count(distinct b.create_DATE) from payment_tab b where b.act_id=a.act_id and b.create_DATE>=a.create_DATE) Hi Use Hash file to remove duplicates and then ...
by Ragupathy
Fri Feb 12, 2010 12:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_ipcput() - row too big for inter stage rowbuffer
Replies: 8
Views: 7230

Reg Memory error

Hi, We are extracting data from a webservice URL as xml files. If we extract few rows it works successfully. If i extract a large volume of data i am getting the below error. ds_ipcput() - row too big for inter stage rowbuffer if i remove the memory buffer again it is coming due to increasing of dat...