DSXchange

Thank you. That would help me process data from the second row onwards. But how do I obtain teh values in the first record for later processing?

Hi I have a file which has 3 records. It is a fixed width file. The 1st record is a 'header' record and has different fields. The rest 2 records are 'detail' records and has similar fields. Now, I want to extract data only from the 2nd record onwards. Is there some kind of row count available to do ...

Thank you. That worked..

Hi

I'm gettign an error:
Missing record delimiter "\n", saw EOF instead

In case, someone has come across this error before please do help me to resolve it

Hi,
Thank you very much for your response.
the issue was that the i had defined teh file to 2K as that was teh expected input. Sadly, the file provided to me had only 1912 bytes and hence the error.
It is working fine now.

Hi, I have the following error while trying to read a text file using a sequential file stage: ##W TOIX 000000 09:10:34(000) <Simple_Mapping_In,0> Input buffer overrun at field "Reserved4b", at offset: 880 ##W TOIX 000154 09:10:34(001) <Simple_Mapping_In,0> Import warning at record 0. ##W ...

sorry unable to read the content as im not a premium user

but nothing is being fetched from the source... the value which has to be populated into the target was hardcoded in the transformer it self..

In this case, i had a target column of data type varchar. So i put in "N" in the transformer target defn.

Database: MS SQL Server 2000
The target stage was a bulk loader. The source is an ODBC with a user defined sql. However, I am not fetching this column from the source. I had hard coded it in the transformer.

As per the logs, the error was thrown in the transformer.

Hi, Does someone know the meaning of this error? Failed to convert column value from DataStage type to OLE DB type. In my job, I was populating a varchar (2) column. I had hard coded "N" in the transformer. My job had run fine in the test environment. However, it has aborted with this erro...

Yes, I did try. I came across lots of code stuff.. the only prob is that I have never coded so I cudnt make head or tail of it :oops: Later, I came across a post which said one cud either write a routine or use the UniVerse. So, was trying out the second approach when I saw Pierre's reply. And after...

Hi, I was gng thru the FAQ sections and noticed the following code: Code: UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO'; I am assuming that DS_JOBOBJECTS must refer to a table(?) in teh datastage internal repository. I needed to know how I can access it..in the sense, how can i bro...

Table A | (LINK 2) V HashedFile | | (LINK1) V Source->Transformer->Table A -------> Transformer -----> Target (Table A Hi, my problem is that the LINK 1 and LINK 2 complete simultaneously. Since Table A has not been populated yet, the hash file has 0 rows... I hope I am more clear abt my problem no...

HashedFile (Table A lookup) | | V Source->Transformer->Table A -------> Transformer -----> Target (Table A updated) :) Thank you Ray. I can use this for my future posts too.. My prob (illustrated above) :I need the lookup as I'm updating Table A based on a maximum value of one column. When teh job ...

Thank you for ur response ray.. but I don't know how to convert the code to ASCII art. I tried enclosing it in code tags..but tht didnt help much... can u tell me how to convert tht? I can summarise my problem as: I need to order the links sequence in a job.. i know the same can be done in a transfo...