DSXchange

Cant be done... Ive tried it. From what I recall from my support calls on this issue, Ascential may support that down the line, but right now they use files in a common location such that only the client that you install *last* will actually work. You need to use two different machines. -craig "Folo...

Hi, We are planning an upgrade from DataStage 4.0 to 5.2 and I would like to know if anybody has experienced the coexistance of the client applications of DataStage (Director, Designer, Administrator and Manager) versions 4.0 and 5.2 on the same Windows NT4 machine? Im not talking about the servers ...

Good Morning Gents and Ladies I have a funny scenario, and I am unable to solve this. DataStage 5.1 on Win 2000 Source: AS400 (V4R2M0) (I am using the DB400 native DB on the AS400 and not DB2) ODBC: Client Access (V4R4M0) to setup the ODBC link. The above connection is working fine, I can move the d...

Perhaps to try and determine if the problem is the ODBC driver or DataStage, you could try and use the driver from something like Microsoft Excel or Access and deliberately use the wrong user/password from them. Remember to do this on your DataStage server, not client. -----Original Message----- Fro...

Hi All, Im doing a DSExport on a project and get the following error when it is Exporting Routines: "Run-time Error 70 Permission Denied" Anyone know how to fix this? More Detail: We are running DataStage 5.1 on NT. The DSExport used to work at one time. So far I tried recompiling all of our Custom ...

Hi Prasad You can use the flat file as your input source and the Oracle database as a reference (lookup). Alternately, you could create a separate job that creates a hash file from the flat file. The 2nd job could read Oracle as the input source and then do the lookup on the hash file. -----Original...

Hi all, I want to join 2 different data sources(one is flat file and other is Oracle) based on a join condition. how can this be done in server jobs thanx prasad -----Original Message----- From: Simon Fryett [mailto:sfryett@hotmail.com] Sent: Wednesday, June 05, 2002 10:33 PM To: datastage-users@oli...

Thanks David, MarkEwartPhipps Ive put the sequence last and start my bind variables with 1. It works fine then. Kasia At 09:17 11/06/2002, you wrote: >ORA-01036 means illegal variable name/number > >it is complaining about your bind variables. In the case of your >insert, the numbers need to start f...

At 08:31 11/06/2002, you wrote: >when you say it doesnt work, what exactly happens? Do you get an >error? The error is : DCustomersInsNewOrUpd..T_D_Customers: Error while trying to retrieve text for error ORA-01036 >I also notice that bind variable :1 is not used anywhere. Do your link >columns and ...

We try to execute a user-defined sql in OCI stage to insert in an Oracle table a sequence.nextval along with other fields from an oracle source table. It doesnt work while it does with and odbc stage. SQL in the OCI stage (doesnt work): INSERT INTO D_CUSTOMERS (SK_CUST,AFE_CUST_CODE,AFE_CUST_NAME,AF...

ORA-01036 means illegal variable name/number it is complaining about your bind variables. In the case of your insert, the numbers need to start from 1 and match up in order with the columns in the link. Does your link still have a column that corresponds to SK_CUST? I suggest that you renumber your ...

Hi Kasia Put the sequence last and see if that works i.e: INSERT INTO D_CUSTOMERS (AFE_CUST_CODE,AFE_CUST_NAME,AFE_SUBSIDIARY_NAME,AFE_CUST_GROUP_NAME,ISO_CUR RENCY_UNIT,ZIP_CODE,CITY_NAME,SUB_REGION_NAME,COUNTRY_NAME,REGION_NAME,REGIO N_CODE,BILL_TO,SHIP_TO,SOLD_TO,CUST_AFE_STATUS,ADRESS_1,ADRESS_2...

when you say it doesnt work, what exactly happens? Do you get an error? I also notice that bind variable :1 is not used anywhere. Do your link columns and bind variables line up correctly? -----Original Message----- From: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Sent: Tuesday, 11 June 2002 ...

Yes, this is the case. We run 5 control jobs simultaneously. Thank you! Leonid "Hall, Doug" on 06/10/2002 02:22:58 PM Please respond to To: "datastage-users@oliver.com" cc: Subject: RE: Job control error -14 In the $uvhome/unishared/unirpc/unirpcservices file there are parameters that control a conn...

In the $uvhome/unishared/unirpc/unirpcservices file there are parameters that control a connection timeout. Typically this is set to a default of 1800 seconds (30 minutes). The timeout is a poor clue to the actually problem. There are a number of possibilities. On a Unix system, we encountered probl...