DSXchange

SAMPLE DATA: 0501025414638979P+4 2005-02-01 0 -126.75 507.00 0.25- 0603057365607336P 4 2006-07-01 0 -124.43 1244.33 0.10- 0501025673495227P+4 2005-03-01 0 -282.25 1129.00 0.25- 0501025673495227R+2 2005-01-01 0 -395.15 1129.00 0.35- 0501025673138242P+4 2005-03-01 0 -7.25 29.00 0.25- 0501025674501638R...

I got the above error when I did everything you just said. I think the error is due to "Spaces between columns" value, its set to "0" in the server job when the file was created. I tried giving "0" as the "Fill Char" value in parallen seq stage, it dosent work

I had "smallInt" and "decimal" datatypes in the table definition, I have changed them to "CHAR" now but i get this error. ##I TOSH 000002 14:29:02(001) <main_program> orchgeneral: loaded ##I TOSH 000002 14:29:02(002) <main_program> orchsort: loaded ##I TOSH 000002 14:29...

In parallel seq file I can specify only 1 value under Type defaults>General>Field width. Is theer any other option to do that ?

Where do I specify each and every column length in the parallel seq file stage?

I am using a seq file created in server with "fixed width". Now I need to use the file in parallel but in parallel when I select fixed width I need to specify the width value. Where can I see the fixed width value which was set when the file is created?? I have the job which created the or...

Its working now ..... Think the process got killed ( maybe by the DBA, Donno yet )

I recompiled the job and am running it again .... lets see how it goes this time around! .. thanx guys

There are a couple of ways to "stop" a job in Director. You should tell us what you've tried. Here are the options: 1. highlight the job and hit the 'stop' button 2. go to Job|Cleanup Resources (if enabled on this project) You'll have to find the process (PID) of the job. Then log it out/...

I tried running the job when I returned in the morning. it says the job has been running all night.

And YES its writing to 2 OCI tables. But its supposed to insert just 1 row in each of them.

I have a problem with a job which dosent stop from the director. It bee running all night. Is there a way to stop it from other than the director ?

Resolved ! ... thnx a ton ppl

Did what u said , Most of the data had "" around them , but they were few fields where the "" were missing..... Hmmm..... thats when I figured out that one of the data I am using has 4 fields more than the other !! The original source data was messed up , I have changed it and no...

Actually I have 2 sequential files with the same data but use different delimiters "," and "|" . Both of them give the 'Input buffer overrun at field' error. Wen I change the datatype of that field to VARCHAR in the file with delimiter "," I am able to view the data. Bu...

"|"2002-08-21"|"03"|"2"|"9378643000"|" "|" 0|0|" "|" "|"N"|"2002-08-21"|"SN4150"|" "|" "|" "|" "|0|0|" "|" "|" "| "...

Yes, the length is 10. I tried using VARCHAR but it gives out the same error