DSXchange

People, Thanks for all you inputs, I am able to update the Audit table if job reads rows form the source table, but now i am facing another problem, if zero rows are processed the Audit table is not getting updated, I want to update the time of the job ran, even if zero rows are processed. how can i...

Williams, I would need to update the time when in the job ran in the Table B, when the job runs next time the time in the Table B is used while to select the Delta data from table A , that is why i need to put in the same job instead of sequencer as i need the DSJ.JOBSTARTTIMESTAMP. so please sugges...

People, Sorry for confusing you all people, My Job is like this OCI1(TableA) | | | \/ Transformer-----Link1---------->XML File | | Link2 | | \/ OCI2(Table B) Once the Data is dupmed into XML file from Table A, i need to Update or Insert a row in Table B which will have Job name and JobStartTimeStamp...

People,

Is there any way that i can tell the link to start processing rows afte the particular link got completed in a server job (not in the Sequnce job),

Please throw some suggestions,

Thanks
Chowdary

Ray,

I checked that one and there is no repetition path in the out put table definition, still i don't understand why it is throwing this error even though there is no repition in the the path

Do you think is there any reason for throwing this error........

Thanks

People, I am trying to read data from XML file and laod into a flat file, i am getting the following error Error: test_xml_1..XML_Input_8: No repetition element specified for link "DSLink4". Please make sure a column that contains the repetition path is set as key in the output link table ...

People, I need to read data from XML file and load into a Oracle DataBase, We are using DS 7.5, cna any one tell how i can do this, i tried using XMLINPUT---->Transformer------>OCIStage what are things i need to take care of when using XML Input Stage When i am compiling i am getting a error as Plug...

People, I need to update an existing row or insert a new row in a table after the job runs, i am tinking of writing a AFTER JOB ROUTINE, so Can i run a SQL Command in a Routine, I knwo we can run a Unix command using DSExecute('UNIX','Command','OUTPUT','ReturnCode'), is there any similar way to run ...

Nagesh First Sort the data on that particular column using sort stage and then in the transformer you can also use Transform function RowProcCompareWithPreviousValue to ignore duplicate values. The routine will check the supplied value with the previous value. If its same, then 1 is returned else 0 ...

Try to set the data type to VARCHAR and the width of the column to 4000. DS does not support CLOBS, so you'll have to fool the stage and see if it will bind using VARCHAR. If it does (I don't know your Oracle release or DS version) then you will be okay to pull upto 4000 chars from the column. Try ...

Hi, I have a table in the Oracle Database which as Three coloumns with metadata as DOCUMENT_ID NUMBER 14 PAGE_NUM NUMBER 14 CONTENTS LONG I want to dupe this data into a Sequnetial File, While i imported the Metadata through Manager and try to view the data in the Designer, it is not showing the dat...

Hi all, Thanks guys for all you inputs, I used the routine RowProcCompareWithPreviousValue on sorted data and it seems it is working fine, the users are validating the data. Hopefully it will work. Once Again thanks for all you suggestions. Thanks Chowdary Hi Chowdary, You can also use Transform fun...

Hi all, I am getting this error and i unable to figure it out whyi am getting this one, I checked all the metadata, there is notihng wrong in the metadata, I am reading from table and after doing aggreagation and pivoting i am looking upon hash file and writing into a Seq file that's all i am doing ...

Hi Thanks for the reply, I got it a part of it but i didn't understand the part which you are saying about the "Using the StageVariable ot remember the first line of each ColA element". Can you please explain more elabrate on this.... thank you very much first number your rows, then sort y...

Hi all, I have Seq file like this ColA ColB 123 ABC 234 CDE 123 CDE 456 HIJ While i am reading if ColA value has duplicates (in the example 123) then it has to read only one row in which the ColB='ABC', it should ignore the record where ColB='CDE' Please throw some suggestions how to solve this scen...