DSXchange

Hi, The documentation for the OCI8 plugin says that you can specify multiple SQL statements in a user defined SQL by seperating them by a semi-colon (;). We tried it and it returned the error "ORA-00911: invalid character". However, both SQLs work fine when they are separated in two OCIs. Here is th...

Actually, a simpler expression If IsNull(FieldName)Then Else FieldName will work. The problem is any empty string column in Oracle is considered Null. They are NOT null in your input file (nor are they considered null by any other database system), they are simply blank. So, converting all nulls ret...

I would recommend trying the DSDetach Job command ... ErrCode = DSDetachJob(hJob1) after each of your jobs. I had very similar problem with several of my batches that ran multiple jobs, and this command corrected the problem. Lisa "Bidondo, John" on 04/09/2002 08:22:30 AM Please respond to To: "data...

Try this: if isnull() or = then @NULL else Wolfgang > -----Original Message----- > From: Regu.Saliah@astrazeneca.com [mailto:Regu.Saliah@astrazeneca.com] > Sent: Tuesday, April 09, 2002 3:48 PM > To: datastage-users@oliver.com > Subject: RE: Problem with Nulls > > > I tried that and the lookup still...

John, what is your exact platform and DS version? If DS is somewhat 4.0.1 or below you better migrate to 5.1, 5.2 or at least 4.2. Best regards Klaus -----Original Message----- From: Bidondo, John [mailto:john.bidondo@aquila.com] Sent: Tuesday, April 09, 2002 2:23 PM To: datastage-users@oliver.com S...

I tried that and the lookup still failed. I think its because DataStage cant evaluate a column that contains a null. It seems that the constraint on the transform (IsNull(FieldName) = @TRUE) will always be true if the column is return empty from the database(if that makes sense). What Ive done is th...

Himanshu, this is a lot of inserts and might be an issue with the transaction log of the database. Have you set your transaction size to some reliable like 1000 or - at least - below 10,000? If default 0 is used, all records are written to the transaction log first, and the commit is attempted at th...

Regu, for each column that may contain NULL, try the following: if isnull() then @NULL else Best regards Klaus -----Original Message----- From: Regu.Saliah@astrazeneca.com [mailto:Regu.Saliah@astrazeneca.com] Sent: Tuesday, April 09, 2002 2:48 PM To: datastage-users@oliver.com Subject: Problem with ...

Hello All, Im encountering a problem with one of my data loads. Im loading about 500,000+ rows into a SQL server table. Somewhere about 1/2 way thru, the job aborts. I am moving data from a Hash File Stage to SQL Server. In the Transform, I am checking the Link Variables and if the REJECTED flag is ...

Guys, I have a datastage job for loading addresses into an Oracle table from a sequential file input. Prior to loading I do a check against existing data, extracted via OCI8 to a Hash file stage to identify only new records. This I do using a Transform stage and two Hash file stages. My problem is s...

I have a control job that runs over night. It runs 18 other jobs, all of which compile and run fine on their own. Most of the time, the control job runs fine; however, every so often, it gets hung in process, usually while finishing a job that has an Oracle ODBC stage in it. The control job gets stu...

Thats cool thanks. -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: 09 April 2002 11:49 To: datastage-users@oliver.com Subject: RE: Oracle initcap equivalent Try this (I havent tested it, but it is straight from the help) Oconv("your string","MCT") -----Original Message--...

Try this (I havent tested it, but it is straight from the help) Oconv("your string","MCT") -----Original Message----- From: Regu.Saliah@astrazeneca.com [mailto:Regu.Saliah@astrazeneca.com] Sent: Tuesday, 9 April 2002 8:31 PM To: datastage-users@oliver.com Subject: Oracle initcap equivalent Can someo...

Can someone tell me what the initcap equivalent is in DataStage.

Thanks
Regu

Thomas, We have controlling jobs nested several levels deep. I dont recall encountering a significant problem along the lines you have described. If you could provide more information about the specific error message, that might be helpful. -----Original Message----- From: Thomas Nel [mailto:Thomas....