DSXchange

Thank you all of you, very very much. By setting that environment variable to TRUE, my job works fine.

Thanks again.

Where can you set the preserve blanks option.

The target database is Oracle and the write_method=load. The target column is defined as not null. My input file consists of: record nullable {final_delim=none, record_length=fixed, record_delim_string='\n', delim=none, quote=none} ( code:not_nullable string[1] {width=1}; ) I get an error saying ins...

Can Datastage insert spaces into a column defined as NOT NULL?
I tried to insert space in a column defined as not null but the job fails.

I tried using the schema file with RCP settings and also specified the key column in the compare stage but still I get the same error.

Added another column to hold the result but still I get the same error saying expected ';' and got '.'

(FYI:By the way if I replace the dot with an underscore then I get an altogether different error saying that it did not find the column name.)

I put together a job wherein I read 2 sequential files and pass them through a Cmpare stage and outputs to a sequntial file. Input file -1 and 2 (have the same col's) lname fname initial (key) Output file is defined as such: first.lname first.fname first.initial second.lname second.fname second.init...

Yes, I am looking into the posts but am finidng nothing that is helping. I am looking through the Parallel Developers Guide and I find it a little confusing. For eg. I have a file with account_no and name columns which I want to compare against another file which has the same 2 columns. Do I need to...

Can someone please guide me on using a compare stage?

I am using a custom stage developed for use within my company.

I am using the parallel reader stage currently.

I tried the same schema with sequential file stage and it runs fine.

Pipe delimited. Now when I specify the record delimiter as pipe (|), I get another error on one of the field saying " Delimiter for field 'name' not found". Th following is my record schema: record {final_delim=none,delim='|',charset='ISO8859-1'} ( account:string[max=10] {default='0'}; nam...

I have a variable length file and I am using a parallel reader as an input stage for the variable length file. It is a must to specify the record delimiter within this stage. Now I do not have a record delimiter as none of the records have a newline at the end of the record. What should my record de...

Hi Ray, Thank for the answers. But DSExecute says that the "Command option" (withing the DSExecute) should not prompt for an input (like below). _____________________________________________________________ Call DSExecute(ShellType, Command, Output, SystemReturnCode) ShellType (input) spec...