DSXchange

Ray, i made some progress. I copied the contents (only) from windows and created the file in Unix itself. I also changed Record delimiter as UNIX Newline and Field delimiter as none. Now i am able to process 988 records and rest are going as rejected. I have captured them and this is how it appears....

actually $ character came only when i did cat -vte <filename>. When i am opening the file with vi or cat o head, am unable to see it. Also, one more thing is the last column data is truncated... even if i give varchar(100) even though the column is having only 30 characters max, i am unable to see t...

That was the first thing i checked. i did not see any Ctrl-M characters..

Yes ray, i took the file from Windows and ftpped to Unix box, since my datastage is installed in Unix... Also just to answer your question, it is not processing first 253 rows, but random 253 rows from the file.

This is what i got dsadm@catom-gmapdvl38:/appl/data/Input/US> cat -vte TESTING.txt 2011-05-03DTS RETAIL US 0CADILLAC CARS LUXURY CAR$ 2011-05-03DTS FLEET US 59CADILLAC CARS LUXURY CAR$ 2011-05-03HHR RETAIL US 7CHEVROLET TRUCKS VAN/MPV$ 2011-05-03HHR FLEET US 246CHEVROLET TRUCKS VAN/MPV$ 2011-05-03ST...

Your metadata doesn't match your file's data, nothing more than that. What settings are you using in the stage? What is different between a row it will process and one it rejects? Can you post an example of each? Following two records got loaded. 2011-05-03Aveo RETAIL US 12CHEVROLET CARS ENTRY CAR ...

Yeah qt_ky. the Other rows are getting rejected saying delim=end is not available. But all the rows have same delimiter then how are those 253 rows are able to process.

Hi guys,

I have a sequential file. The file has 2500 rows but when i processed the file using datastage using sequential file, the job is processing only 253 rows.

Even viewdata is showing only 253 rows. No error is occuring.

Can somebody help me to process the whole file.

Cheers!!!

Hi Guys,

I am using Datastage 8.5. I am writing a script which will run every sunday to export the whole datastage project.

Is there a option "-export" in dsjob command???

Or how to export the whole project from unix prompt.

Cheers!!!!

Hi Guys, I have shell script which is calling Datastage job and is running perfectly. The problem is the parameters needed are in a Oracle table which i need to fetch. I am able to fetch them if i write in a separate script,but when i include the same code in the script which is calling Datastage (s...

Hi, Yeah i too saw that. But i have hardcoded 'X' for all Varchar and Char columns and 0 for Decimal. Apart from this, there is only one Date column which i guess should be the issue. Now, even CurrentDate() column is giving the same "Invalid Number" issue. Can somebody help me out with th...

Hi Guys, My source is a Flat file. The Input column sample value is 2011-07-16. I am reading it as Date. My Target is Oracle table. This column is a part of Primary Key. I directly mapped the column. But i am getting the following error. Oracle_Connector_43,0: The OCI function OCIStmtExecute returne...

@chulett,, yeah that did the trick... i made it as Aggregate into one column. Now i am able to create the file for testing as told. But i am not able to route it as Output. In output, i have used the same metadata definition as defined in Input. Also the file being created by XML Output stage is hav...

I have saved the metadata using the XML Metadata Importer and marked TransactionLineNumber as key.
The Metadata had 5 columns with the same XPATH which i used before.
So, i used it in Output stage. But it is still getting aborted.

Hi Guys, This is my first attempt at creating an XML file, though i have worked in parsing an XML file earlier. My input file is as below TransactionID,TransactionLineNumber,StoreID,ScanType,PLUID 1030104,1,625,2,21155269 1030105,1,626,1,21155270 I want to convert it to XML stage as below. <Transact...