DSXchange

Im loading data to an Oracle table via the Orabulk stage and the ExecOraLoadArgDirect routine. I would like to get the number of lines loaded into the table In this routine the sql*loader command is execute with : Call DSExecute(ModeLaunch, CommandToExecute, Output, SystemReturnCode) where : ModeLau...

Hi Vivek, Thanks for yr prompt reply. Your list of SAP R/3 releases does not include V4.6D. That means no clear support for it, right now? Just to re-confirm. Seems you try to send an attachment (ZDSRFC.txt), I did not receive it. Could you pls send it to surja@summit.co.id. Regards, Surja -----Orig...

Dear Surja, What you need is.... DataStage Extract PACK for SAP R/3 Release 3.0.1r1 Release 3.0.1r1 has been tested against: o Windows NT Version 4.0 Service Packs 4 and 5 o Windows 95 Service Pack 1 o Windows 2000 This release of the DataStage Extract PACK for SAP R/3 has been tested against the fo...

Thanks Guys. (Ernie, Anthony, Craig) Please let me confirm, I need to load the Oracle 8i Client on the box, to connect to 9i, no need to load the 9i client then. Or can I load the 9i client, and connect with the OCI8i pack on Data Stage to Oracle 9i. Thanks for the support and help. Regards Yzelle -...

Hi,

Pls advise me, does DS 5.1 has SAP R/3 Plug-in for SAP R/3 4.6 D?

Thanks in advance.

Rgds,
Surja

Exactly. We have done the same thing in the past only the other direction - specifically, used the OCI8 plugin and Oracle 8 client libraries to access a 7.3.4 database. Worked out nicely for two reasons - for one thing the OCI8 plugin is much nicer and has better generated sql options than the OCI p...

Thanks Ernie... A general rule would be use the Oracle client libraries for which the plug-in is designed for: eg: ORAOCI (Oracle 7) - Use Oracle 7 client libraries, eg: ORAOCI8 (Oracle 8.0.x) - Use Oracle 8.0.x client libraries. etc... so theoretically you could use the ORAOCI to access Oracle 8.0....

Numerous customers have reported success in exactly this configuration (8i client libraries, with the plug-in, connecting to 9i server). ERnie -----Original Message----- From: Anthony Corrente [mailto:anthony_corrente@yahoo.com.au] Sent: Sunday, March 17, 2002 7:53 PM To: datastage-users@oliver.com ...

Hi Yzelle, Try it and see... but my guess will be that you can access a 9i server if you use 8i client libraries with the OraOCI8i stage. Regards, Anthony. --- Yzelle De Wet wrote: > Hi Guys and Ladies > > I have a stupid question, I have used the 8i plugin and ODBC to 8i > before. I need to know no...

Hi Guys and Ladies I have a stupid question, I have used the 8i plugin and ODBC to 8i before. I need to know now if the plugin will work for Oracle 9i. Except ODBC is there native connection to 9i? The platform will be Compaq Tru 64 Unix Oracle 9i, and DataStage on the same box. Regards and Thanks Y...

Not directly, but Ascential has a very close partership with a great tool from a company called Natworks. It is called NatQuery and does an excellent job of generating Natural. Ascential also offers their changed data capture product called NatCDC. Please contact your local Ascential office for more...

Hi,

Can Datastage read ADABAS ?


regards
Rui Soares

Rui Soares
NOVABASE - Data Quality - QP
Mail : Rui.Soares@Novabase.PT
Tel (NB) : 351 21 383 65 92
Tlm : 351 93 620 15 98

Actually Peter I use the HashFile Stage. There are also times where I use similar code in the job Control area or in a before / after called subroutine. All of our updates currently go to SQL Server and selection under that date range criteria has not really been an issue on either side. - himanshu ...

himanshu, I assume you are using the UV stage. Have you any comment on performance with this versus database ( Sybase, Oracle ) lookup. Peter -----Original Message----- From: Himanshu Patel [mailto:Himanshu.Patel@globalknowledge.com] Sent: Thursday, 14 March 2002 10:49 PM To: datastage-users@oliver....

Hi, Dave Meeks is right (as always...). The comment in this transform was removed; we withdrew the NLS comments from a number of the routines & transforms after some checks and code revisions of the SDK in later DataStage releases. But if you have an earlier version of the SDK, you can turn off time...