DSXchange

Hi ppl, I have same extraction to do, in each of them, i have to use the same condition, Max(date). I get the max(Date) of one table and use this value, in each query. The Max(date) take a lot of time, because the table have too many records. To solve the problem, first we get the Max(date) and put ...

Hi all, Now, We test CDC for DB2 with datastage 5.2, I wonder How many customer used CDC for DB2? If Somebody have a experience withd CDC For DB2. Pls, Gimme any information. - How about CDC Option Performance. - How about Product Stability ( Is it missing data or not?) - ETC Regards Daehwan Kim (wh...

Tricky if youre not on the DataStage server machine! -----Original Message----- From: Ray Daignault [mailto:data_stage@hotmail.com] Sent: Wednesday, 11 September 2002 8:33 AM To: datastage-users@oliver.com Subject: Re: ODBC Drivers for UniVerse In the bin directory, use UVread and UVwrite to access ...

In the bin directory, use UVread and UVwrite to access the single rows of data. Key must be known. Syntax is UVread TABLE KEY. Cheers, Ray D ----- Original Message ----- From: To: Sent: Tuesday, September 10, 2002 9:50 AM Subject: RE: ODBC Drivers for UniVerse > Hi Shawn, > > Im not sure that it is ...

Oki. Thanks Ray for the response. Nuno Pimenta > -----Original Message----- > From: Wurlod, Ray (BSG) [mailto:Ray.Wurlod@riotinto.com] > Sent: segunda-feira, 9 de Setembro de 2002 22:55 > To: datastage-users@oliver.com > Subject: RE: List Parameter > > > It is not possible to access list elements in...

Dont worry all, I have it now Jason Gibson Data Intelligence Hutchison 3G UK Ltd Desk: + 44(0)1189 256346 Mob: + 44(0)7766 560716 ________________________________________________________________________ This e-mail message (including any attachment) is intended only for the personal use of the recip...

Does anyone have the PDF documentation for the XML Reader and Writer stage. Jason Gibson Data Intelligence Hutchison 3G UK Ltd Desk: + 44(0)1189 256346 Mob: + 44(0)7766 560716 ________________________________________________________________________ This e-mail message (including any attachment) is i...

Hi Shawn, Im not sure that it is possible to access the underlying DS database in DS 5.1 or later using the UV ODBC drivers, because of the split between the DS engine and UniVerse as a continuing IBM product. I havent actually tried this myself though, so it might be worth a query to support for th...

This is a topic for an orphaned message.

Thanks again, I was hoping to avoid having to call UV and parse out the results, but that is one of the options on my plate. -----Original Message----- From: Wurlod, Ray (BSG) [mailto:Ray.Wurlod@riotinto.com] Sent: Monday, September 09, 2002 3:58 PM To: datastage-users@oliver.com Subject: RE: ODBC D...

If your Perl script is on the same machine as DataStage server, you can get at the UniVerse tables even more directly. The process running the script will (on UNIX) need to have set appropriate environment variables, typically by running the dsenv script (recently discussed on this list). Then you c...

Thanks Ray, ODBC would be the best for me since I have a pretty good handle on the DBI/DBD interface in Perl, even though I dont think it would be all that bat to pick up and do the little work that I need to do through another API. Shawn -----Original Message----- From: Wurlod, Ray (BSG) [mailto:Ra...

Its probable, though I dont know for sure, that the UniVerse ODBC components could be installed on the DataStage Engine. This driver (UniODBC) is available from IBM and UniVerse resellers, and has components to install on the server and on the Windows client. There are other third-party ODBC drivers...

Hi all,

I am wanting to manipulate (via a Perl script) a couple of UniVerse tables that are part of a job scheduler that we have and was wondering where I can get an ODBC driver to access a DataStage 5.2 UniVerse table.

Shawn Ramsey
Starbucks Coffee Company
E-Mail: sramsey@starbucks.com

It is not possible to access list elements in DataStage components, only in BASIC code. What you can do is access the list elements in a controlling job (DSGetParamInfo function with DS.LISTPARAMVALUES as the InfoType argument), and load multiple parameters in the controlled job with different items...