DSXchange

Ray

So you are a real data miner now!

Good to see you back.

Adam

Youve got two main possibilities. When you install the DataStage client (or subsequently) you can elect to use a database other than MS Access (which is only the default). Scripts are provided, for example, for creating the tables in Oracle, SQL Server and UniVerse. If you use MS Access, the databas...

See the following post in the tools4datastage.com archive: m Chris. www.altis.com.au Quoting Rui Soares : > > > Hi, > > > Anyone have work with Reporting Assistance ? > How we can save and customize this reporting ? > > > > best regards > > Rui Soares > > > > Rui Miguel Soares > > NOVABASE > > Mail ...

We have started using the XML Reader plug in and have an issue with the output from the XML Reader stage: attributes are written to columns as we expect but elements appear in the columns with their opening and closing tags included. We would like it not to have the tags. Does anyone know how we can...

Jerry Loethen Anheuser-Busch - Supply Chain Systems (314)577-4679 -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: Thursday, August 22, 2002 8:28 AM To: datastage-users@oliver.com Subject: RE: Reporting Assistance Hi Rui, yes we have. It is a ni...

Hi Rui, yes we have. It is a nice information tool. It is MS-Access based. If you are a MS-Access-Programmer it is very easy for you to do what you want to do and report. Wolfgang > -----Original Message----- > From: Rui Soares [mailto:rui.soares@novabase.pt] > Sent: Thursday, August 22, 2002 2:07 P...

> Hi, > Anyone have work with Reporting Assistance ? How we can save and customize this reporting ? > best regards > Rui Soares > > Rui Miguel Soares > NOVABASE > Mail : Rui.Soares@Novabase.PT > Tel (NB) : 351 21 383 65 92 > Tlm : 351 96 347 08 40 >

Gavin Thanks for the input. There is no doubt the CTL solution would work. However, as I have started to create one DS job for each table I am going to keep going down this path. The job is called from its controller using variables so the running is quite smooth. This also gives us a more consolida...

Hi Adam, Using RedBrick totally changes the equation. The bulkloader in RedBrick is REALLY fast and also has the ability to to MODIFY records (equivalent of INSERT/UPDATE) unlike Oracle etc. On an NT box you can easily load data at 50000 rows/sec with bulkload into RedBrick. Change your ODBC stage t...

Simon I have tried parameters, they certainly work for ODBC extracts, but I cannot get them to work for the updates. RB Macros may be the go, however I have started down another path, and am nearly finished. Thanks Adam "Simon Fryett" on 21/08/2002 06:26:25 PM Please respond to datastage-users@olive...

> > From: Ian Godsell > Date: 2002/08/21 Wed AM 09:53:29 EDT > To: "datastage-users@oliver.com" > Subject: RE: Error logging from command line > > Thanks David. Works a treat. > > Do not understand though as to why I am able to run it at the Unix > prompt though without having to supply this informa...

Thanks David. Works a treat. Do not understand though as to why I am able to run it at the Unix prompt though without having to supply this information, and yet have to when the script is called from DataStage. -----Original Message----- From: David Lathan [mailto:David.Lathan@kinkos.com] Sent: 21 A...

Udo, Yes, in the case of ORA-01555 being caused by delayed block cleanout, you are right, it doesnt matter what tables are being updated, only that the updates are using the same rollback segment. However, this can only occur if there are still dirty blocks from a prior update (committed before your...

Ian, You will need to insert a command prior to this one or as a part of this one that logs your session into DataStage. Like: dsjob -server dsserver -user dsuser -password dspassword -log -info dev jobname Where: dsserver is the server DataStage is on dsuser is your user ID dspassword is your passw...

This is a topic for an orphaned message.