DSXchange

This is a topic for an orphaned message.

Hello Data Stage Users, I am wondering if anyone has created a metabroker to import Data with ASG Rochade into MetaStage or is using DataStage and Rochade and is integrating both repositories in some way. Does anyone have experience in using both tools in the same environment ? Thanks a lot in advan...

Were setting up some file tracking on our system and only want to select records from our data files whose IDs match those in our Tracking file. My question is this: Now that I have my tracking file setup and working. Can I select the records I want, save them to a list and have the real DS Job use ...

Ah, Progress. Or the lack, thereof. We, too, had to copy a Progress Database (version 6) into an Oracle database for archival purposes. From there, were reporting from it via Business Objects. The price for the ODBC driver was a bit higher than the client wanted, so we took a different approach. Bas...

Hi All We got some difficulties with running DataStage jobs from Microsoft DTS using command line interface (dsjob.exe). In Windows command prompt the command dsjob works fine (as much times as we need) but if we try to do the same using MS DTS "Execute Process Task" - this command is only able to b...

?????, 20 ??????? 2002 ?., you wrote: CH> What database and version of Datastage? CH> -craig CH> Alexandre CH> Stoulov To: datastage-users@oliver.com CH> u> Subject: Loading everything or nothing CH> 02/20/02 CH> 07:36 AM CH> Please CH> respond to CH> datastage-use CH> rs CH> Hi, All! CH> Please adv...

Use ICONV to convert it to an internal date format, and then OCONV to convert it back out to your desired format, all in one step. There is a ton of online help, and these two functions are very well documented. Give it a try! -craig "soares.rui@c lix.pt" To: datastage-users@oliver.com

Hi, All! Please advise, how to solve the following task. The job loads facts to fact table. During this process some records are deleted, some updated and a number are inserted. If the job fails we need to restore the previous state of fact table. The number of records processed is greater than the ...

What database and version of Datastage? -craig Alexandre Stoulov To: datastage-users@oliver.com Subject: Loading everything or nothing 02/20/02 07:36 AM Please respond to datastage-use rs Hi, All! Please advise, how to solve the following task. The job loads facts to fact table. During this process ...

Hi Himanshu No its not! But from DS5.x you can use shared container. Bye Riccardo ----- Original Message ----- From: "Himanshu Patel" To: Sent: Wednesday, February 20, 2002 4:14 PM Subject: Copying objects from 1 job to another > Does anyone know if it is possible to copy > Stages and Transforms fro...

Does anyone know if it is possible to copy
Stages and Transforms from 1 job to another ?


thanks
hp

Thanks. What are the others characters that could be used? (where can I find the information?) Kasia At 14:18 19/02/2002, you wrote: >Hi Kasia, > >If passed into DSRMessage it gets turned into a newline. > >Regards > > - Chris Thornton > >-----Original Message----- >From: Kasia Lewicka [mailto:katar...

Hi, All! Please advise, how to solve the following task. The job loads facts to fact table. During this process some records are deleted, some updated and a number are inserted. If the job fails we need to restore the previous state of fact table. The number of records processed is greater than the ...

Hello Data Stage Users, we are currently evaluating Data Stage on Sun Solaris. What steps and products are necessary to use OS/390 as a database source and target for Data Stage ? Currently DB2 is purely used on mainframe, so nothing can be taken for granted as far as ODBC etc is concerned. Thank yo...

We are experiencing intermittant issues with DataStage loads into SQL Server. At times my jobs hang with a Running status. No rows are selected and none have been loaded into SQL Server as well. Upon investigation, it has always turned out to be a Cognos Query/Report that has been running or was inc...