DSXchange

This is a topic for an orphaned message.

Oracle will display non-printable characters as ?. Is it possible the rows in question contain characters the DataStage browser is not displaying? In other words, it may look like a blank field but it doesnt actually contain blanks. -----Original Message----- From: Regu.Saliah@astrazeneca.com [mailt...

Damien, on your ODBC destination stage have a look at the list of columns being outputted, do you have a primary key specified? There should be three columns with a "Yes" in the Key field. It is my understanding that the stage will try to use the primary key of the column list to build the where cla...

....and from a single transformer, so you can specifically control the order... -----Original Message----- From: alessio.giordani@inwind.it [mailto:alessio.giordani@inwind.it] Sent: Wednesday, April 24, 2002 10:18 AM To: datastage-users@oliver.com Subject: Ri:Multiple ORAOCI stages with foreign key ...

Hello, I have a job which aborts with the following message: ================== Abnormal termination of stage "JobName.TransformerName" detected DataStage Job 1056 Phantom 2584 Program "DSD.INTClose": Line 85, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT ra...

Hi Paul, in order to obtain a single session to load all tables you want, you should to connect all your links to a single OCI stage (each one with the related table), and enable the transaction gouping flag (within transcation handling tab). regards, Alessio > Hi All > > We have a job which puts da...

Hi Anthony, The source files dont actually contain any nulls. Whats actually happening is that and empty string () is passed into the field by one of the transform stages, it is this empty string thats being inserted ok for about 200000 of the records but for a handful I get a ?. To just make sure t...

Hi Regu, Have a look at the columns tab in all the stages that involve this data. Scroll all the way to the right and youll find several options on how that particular stage will deal with missing data etc... Regards, Anthony Corrente. --- Regu.Saliah@astrazeneca.com wrote: > Hi all, > > I have a jo...

Hi all, I have a job that loads an Oracle table via the OCI8 stage. I occasionally get an error reported in the log file of ORA-01722: invalid number. It would seem that for some reason DS is choosing to substitute a null into an nullable field with a ?. The strange thing is that of the 200000ish ro...

Hello Paul, the point from David are rigth. I have the same transaktion problem after upgrading from DataStage 4.0 (ORAOCI 2.3) to DataStage 5.1A (ORAOCI 4). I modifyed many jobs that use differnet link for Insert, Update,Delete to the same OCI-Stage. I hope a later Version have the same transaktion...

This is a topic for an orphaned message.

I am having some difficulty upgrading to DS 5.1 from 4.1. Running OS: WIN2K Server DBMS: Ingres II Stage Types: sequential source loading into an ODBC Destination stage. (Ingres II Connection) This is the error message that I am getting once I have imported all jobs from DS 4.1 (Production, - i.e. w...

You need some indirection (so that your script can get the password without its appearing on the command line, which is reported by ps). For example, the user id and password might be written into a file by the DataStage job (maybe in a before-job routine), then the script reads them from that file ...

FW: DataStage CDC for OracleHi Ian, Generally speaking, DataStage CDC for Oracle utilizes the native Oracle Replication services. To implement, you need to install the Oracle Replication component of the Oracle Enterprise Edition. CDC enables the capture component of Oracle Replication, but not the ...

David & Ray, Thanks for your replies. I tried this but it is still exposed via ps -ef command. c001045 56124 61416 0 11:51:09 - 0:00 sh /home/work/scripts/testpwd.sh ETLuser ETL_pwd1 D011 Can I do an ExecSh in a silent no-footprint mode ? Thanks Bibhu From: "Raymond Wurlod" on 04/22/2002 03:46 PM Pl...