DSXchange

Hi, I'm having trouble with inserting some dates in a hash file. Let me give you an example. I have a sequential file with a varchar(255) column that has the date (e.g. 2006-11-13-00.52.50.932000), I'm using the following formula to extract it in a yyyymmdd format: Substrings(Link_SecuentialFile.Dat...

It helped me a lot in performance. I have another doubt concerning hash files but I better insert a new post because it got nothing to do with performance.

Thanks a lot!!!

Hi, I have a job that gets data from a sequential file and insert it to an Oracle table. This job runs fine (300,000 rows in 5 minutes more or less) until I put several links of other Oracle table in the transformer in order to get more data. The problem here is that is a fact table with artificial ...

Got it, actually somebody yesterday was updating the file. I don't know if it's related but that file was created in 1.5.2 and when trying to accesing it with 1.5.1.A it fails.

I made the test with 1.5.2 and it worked fine.

Thanks!!!

Thanks for the answer, I'm still getting the same message without the "/" that was before, like this:

DSR.MetaGeta(GET.SEQ.SAMPLE): OPENSEQ of /projectds/Operator/files/File_Special.txt took ELSE clause, STATUS()=0

Please advice, thanks!!!

Hi, I'm having a lot of trouble trying to import some text file definitions to Datastage Manager. When I try to import any file the following message appears: DSR.MetaGeta(GET.SEQ.SAMPLE): OPENSEQ of /projectds/Operator/files//File_Special.txt took ELSE clause, STATUS()=0 I'm connecting via VPN to a...

I'm sorry about that... the "date" column is just a char with separate values, I had this problem before (of the timestamps) so I just wrote the dates in char's (separated with spaces) so I can transform it later. The issue here is the sales column: it appears that the culprits the ones th...

Thanks for the quick answer. There are three records that are the culprits, this is one of them: date(in decimal) = "25 07 86" employeeid = 7499 custid = 104 orderid = 608 productid = 100871 quantity = 2 sales = 11.2 The charactersitics is that the sales field has a decimal value, the rest...

Hi, I'm having trouble in insert a decimal value from SQL 2005 to Oracle 10g. I'm using DS 7.5.1.A and ODBC as a connection. The mistake is: [DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-01722: invalid number the field property are the same: decimal with lengh 8 and scale 2. Using the real and...