DSXchange

Yes, with wrapper stage u can call unix script.

kumar_s wrote:Is it possible to build a Wrapper stage with set of unix commands?

Hello,

In my application i want to read the data from web pages .

Webpages inclue jpeg,text etc data but i need to extract only text data from the webpages so extracted data, i can pass through datastage.

could you people share your exeperience on this issue.

Thanks
HH

Hi Ultramundane, I setup the stage as follows : Input -> Properties -> Target ->Destination Program pathname/del.sh pathname retentionperiod here after pathname/del.sh ,pathname and retentionperiod are two arguments which i want to pass in shell script. Input -> Properties -> Target -> Target Method...

Hi, Tried to call unix script with external target stage however when i specify pathname to call unix script in destination programme i got warning like pathname/del.sh not execute and error like export failed. with pathname i have specified two arguments also can u please suggest on this issue ? Th...

Hi Ray, In job we dont want to use before-job subroutine or after-job subroutine,we need to make generic solution. so how can we achieve solution without any subroutines ? Then all you need is a before-job subroutine executing ExecSH with your script's path and command line arguments (all can be job...

I want to invoke shell script once

ray.wurlod wrote:You avoided the question. Do you want to invoke this shell script once, or once for every row processed in a job? The answer to your original question depends on your answer to this one.

Hi, I want to pass parameters like pathname and retention period, and if i enter retention period, so file which are older than retention period should be removed from particular path. My requirement is to enter dynamically pathname and retention period. Thanks & regards Hman Do you want to invo...

Hello friends,

Have created one shell script which has two parameters.
Have requirement to call this shell script using Wrapped stage.
please share your ideas to design this job,like what are stages required ? etc.

Thanks & Regards
Hman

Hello friends,

Have created one shell script which has two parameters.
Have requirement to call this shell script using buildop stage.
please share your ideas to design this job,like what are stages required ? etc.

Thanks & Regards
Hman

Hello friends,

in datastage px is there any function for rounding the value ? if not then what is basic methology to achive rounding in px ?

Thanks
Hiten

Thanks Arndw, your formula is good Hiten, PX has no built-in function to do this; you could either write your own in C++ or you would need to code it into the job. The following would work: Field('January,February,March,...",",",MonthNumber) MonthNumber is the extracted month from the...

Hello Friends, i want to convert date into string with format of <month name><dd><yyyy' but there is no function for convert Full month name from date value field ex. 11-12-2004 Then Output like December 11 2004. In Transformer stage i have used DateToString Function and used 'mmm' but it takes upto...

ArndW, I want to know particular function. as well as how do i write my own c++ code in PX. Thanks Hiten The CRC32 function does more than convert data into binary - it compresses it into 4 bytes regardless of string length. PX has a number of builtin conversions to and from binary as well. Are you ...

Hi ArndW, If my input column is null and i handle null with following condition then there is chance to drop records. if isnotnull(P_MKTPRC_BAM) and P_MKTPRC_BAM < 0 Then '-' Else '+' However if u will change the format of if condition into nested if then it will work fine. Ex. if isnotnull(P_MKTPRC...

Hello friends,

In Px, what is function for converting data into binary format ? like crc32 is useful in server job .

Thanks
HMan