DSXchange

Hi All,

Enabled previous options from job properties...

When iam running it is asking "invocation id"...

what is invocation id??what am i supposed to give?

How to generate wsdl for my job?

Thank you...

Hi All, I was developing a job that provides web service... like input to service is id and response is name of particular id... i was getting the following error while compiling.. "A job with WISD input or WISD output stage must have the "Allow Multiple Instance" and "Enabled fo...

Hi All, I was using web service transformation stage in my job.. row gen ->web services transformation stage -> seq file. i was getting the follwing error .... Web_Services_Transformer_3,0: Warning: wsdl_job.Web_Services_Transformer_3: ASCL-DSJNI-00001`:`TJStage::initialize: initializing Transformer...

Hi All, I was going through a job where the target was STP stage...The procedure statement is as follows.. BEGIN #$SPD_USERNAME#.P_SPD_DISASSEMBLY_TRT(:1,:2,:3,:4); END; the input to this stage have 4 columns.. My doubt is 1.Are the parameters :1,:2,:3,:4 corresponds to input columns.. 2.can we use ...

chulett wrote:You can run any valid script or UNIX command as long as it is in your PATH or properly pathed. Not sure what's up with your leading "dot", that's certainly not needed, though. ...

Thank you...

chulett wrote:You probably saw ExecSHSilent rather than 'Client' and that just suppresses log messages. ExecTCL let's you execute Universe / TCL queries, typically against the repository. ...

Thanks chullet..

Can i issue command like this

ExecSH . /path/mail.sh

to run script...

Hi All,

I was going through job properties and in before/after subroutine some options are..

ExecSh
ExecSHClient
ExecTCL

ExexSh is to execute shell commands..and coming to other two options can any one explain me when they are used...

Thank you

Hi All,

Is there any option like before/after sql( in oracle connector in 8.x)...in 7.x...

I want to execute 4 stored procedures with out loosing login session in oracle..

Thank you...

Hi ,

As per my knowledge the output of Aggregate stage will be double ...

As the PO is using max for date field , should we enable preseve type to true in aggr stage, so that the out put will be date data type...

.....

No, not the "whole operation", it just means that that object will always run regardless of the current checkpoint situation. ... Thanks got the use of it ..but i was seeing this option in some sequence job command activities checked and i cannot see this option at all for some command ac...

Hi All, I was trying to use Command activity in sequence job ... i came with option "Donot Check point run"... What i understood is if a sequence fails in middle the whole operation is going to revert back if this option is checked... Correct me if iam wrong??and post if there is more for ...

anbu wrote:Check if you find dsenv file in DSEngine directory

/bi/bustools/riws/iwd/751/Ascential/DataStage/DSEngine

got it thank you

Unless you define the variable DSHOME in your shell you will not get any value. dsenv file will have the variable DSHOME. Run the shell script dsenv and then try echo $DSHOME . /full_path/dsenv Hi anbu, In my linux server i was having path as /bi/bustools/riws/iwd/751/Ascential/DataStage so in whic...

kris007 wrote:The OP's post and example indicates that the output is required only one column and not multiple columns. So, anbu's solution will work.

Yes ...i over looked it...

arun_im4u wrote:-- Check if the DSHOME path is set in your .profile.

-- The comman is echo $DSHOME (You had mentioned $echo $DSHOME)

Yes $ means the shell...

actual command i was giving is echo $DSHOME...

thank you...