DSXchange

With this many tables, you are going to definitely need, as Ray notes, some type of intermediate scratch queue, or place you can go to if the whole thing falls over. We have a certain degree of UOW capability within DS Server (one transaction across multipe tables -- a special feature that uses &qu...

Long story short we have to move data between two transactional database Source - UDB Target - Sybase Work unit to be extracted going to come from MQ series in XML format which will be used as input parameter to extract 50 tables. once the whole sequence of job is completed. I have to create a xml w...

chulett wrote:You are calling this where?

Functions of that nature are meant to be used 'after job' or in a separate step in a following job or Sequence activity. Are you doing this inside the running job?

I am doing this inside the running job

I have server job which extracts rows from Sybase and load to Sequential file. and it also creates a job report in sequential format. Job design looks like this Source --> Transform1 --> Target | |__ Hash file --> transform2 --> report I am using following function to get the count for each link DSG...

Error message indicates XML structure of the file is not valid. Check your XML file structure. Hi All, I need help on this. I have a XML file as target. The file is created. it is opened by editplus.But i need to open this in internet explorer. But it is not opening. It is giving error like The XML ...

Probably the optimal model is to destructively read the input queue, and establish an intemediate "hold" queue in which you can manage your units of work. You might also send your outputs to one queue and your rejects to another. Ray, How do i extract the workunit from the xml file and as...

Scenario : Transferring transactions/data between two transactional databases. Work unit key to be transfered is going to come as MQ Message. I have to extract this key passes this to a job sequence which will extract approximately 50 tables and transform to staging and last job will move this data ...

A good reference for you on IBM Site Transform and integrate data using WebSphere DataStage XML and Web services packs http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0703xiong/ Hello All, I'am new to this technology(data satge server), can any one give me suggestion to extract xml ...

I agree with ArndW

ArndW wrote:Actually that number isn't fixed, it depends upon whether or
not there is a leap year involved.

If your source is RDBMS you can do that at database level using dateadd (sybase) or their variants in other RDBMS. HI All, I need to add 365 days to a date which is in yyyymmdd format. I am using the function DateFromJulianDay(JulianDayFromDate(DSLink3.Date)+365) But the output is *******. The input...

Perl is a good option according to me anything to do with file handling or file manipulation. Hello, I have a curiosity: I have a script ksh which launches a job control which launches a job sequencer. Before launching the job sequencer I want to parse a file and verify its structure. If the structu...

Basically... yes. The source can be anything, I typically land what I need in a flat file and then source from that flat file. If I have five source table with different structure , number of rows can be different in each table for a given key. what should be my approach to create flat file? Should...

As Ray noted - using a single target database stage with multiple input links. Each link would populate one of the related tables and the link order would match any RI dependancies you have between the tables. In that situation, each 'set' of records can be committed individually if you enable Tran...

As Ray noted - using a single target database stage with multiple input links. Each link would populate one of the related tables and the link order would match any RI dependancies you have between the tables. In that situation, each 'set' of records can be committed individually if you enable Tran...

If transfer to each of the table is handled by an independent server job which is a part of a sequence job, can we manage the transactions across multiple server jobs? No, no more than you could across multiple stand-alone procedural processes. I am fairly new to this datastage tool. How do i write...