DSXchange

Roy...Thanks for your reply. I got it done using xpath of XML stage.

I have a XML file like this... [code]<?xml version="1.0" encoding="UTF-8"?> <insertRow subName="XPUB_FinTrx" srcOwner="DEV1" srcName="FINANCIAL_TRANSACTION"> <col name="ID" isKey="1"> <bigint> <afterVal>1</afterVal> </bigint> </co...

Craig

what I meant from suppressing staus code is....If I execute the command
[b]dsjob -report Prokect_Name Job_Name XML[/b] from a shell script it gives me the job statistics and also gives me [b]Status code = 0[/b] as the last line. I don't want this status code.

Thanks

Thanks for the replies. I am using shell script and I am not running the command. I can't redirect my stdout to /dev/null as I need the output of the command. I need to execute the following command. dsjob -report DS_PROJECT DS_JOB XML If I redirect my stdout as following then everything will be ruo...

Hi

Can anyone tell me how can I suppress the return staus code value which we get after running the dsjob command ?

Thanks

Craig My job is designed the same way as you suggested. What's strange is that If I route the output to a file instead of stdout and then cat the file in shell script then the job works just fine. so I think it's not related to reading XML using Seq file. Kumar Thanks. I can do that but I have to br...

Craig I am familiar with the filter command option in sequential file. [b]dsjob -report srcdev src_common_curr_ext.abwBase1 XML[/b] is writing it in standard output. so it should work...If I execute a simple echo or cat command in filter command instead of dsjob it's working fine. only with dsjob co...

All I am trying to execute the following command in filter command of seq file stage. dsjob -report srcdev src_common_curr_ext.abwBase1 XML But I am getting the following error.. [quote] src_cog_test_filter_2..seq_TW1L0_curr_T.DSLink36: ds_seqopen() - Error in filter command "/opt/dsadm/Ascenti...

I believe that the sequential file stage accepts wild cards in file names.
we can mention like Directory/PCBR*

Regards

All the GUI Export window options should also have the command line options. Example exporting single Table Defenition from Command line is not available now.

Thanks

Can someone tell me what actually happens when we reset the DataStage job ? Does it only erase the check point information in seqence jobs or does it do anything more ? what happens when we do log reset ? I see a event type called DSJ.LOGRESET. Is there any similar command to run from command line ?...

Thanks for the replies

How can I enforce permissions on DataStage Category ?
I could not find a way to do this...Say I have a folder with reusable jobs and I don't want others to change those reuable jobs. How can I accomplish this ? Any hint is appreciated.

Thanks

Can you please tell me why do you want to reset the job as a first step ? what If I just run the lognewest command before and after running job and use that to get the latest logs ? As the reset operation may cause the checkpoints to loose track in case of restart... or is there any way we can just ...

Unconnected Lookup is a Tranform in Informatica. I would say it's similar to Routine in DataStage but not exactly the same! We can have that stage(unconnected lookup) in our mapping or job which will have input columns and output column. We can call this unconnected lookup N times from that job just...