DSXchange

betterthanever wrote:kld05,
can you post the format tab properties set to that sequential file???

Sure. I have only three values set.

Final Delimiter = end
Delimiter = comma
Quote = none

kld05, dint you get any warnings in the director when reading the file ???.. No I didn't. It's all green. just tested writing 3 columns to a file and then tried to read the same file mentioning only 2 columns in the sequential stage. gives me a warning in the director... Sequential_File_7,0: Field ...

betterthanever wrote:kld05,
dint you get any warnings in the director when reading the file ???..

No I didn't. It's all green.

If your RCP is disabled then you need to map the new columns from source till target. What is your job design ? Right. And my expectation with RCP being disabled is to reject rows with columns undefined in the sequential file stage. This is obviously incorrect. Say I have a process consisting of a ...

ray.wurlod wrote:Does your stage have runtime column propagation (RCP) enabled?

Hi Ray. RCP is disabled. I am a bit embarassed that I do not know this.

I was under the impression that the number of columns defined in a sequential file stage had to match the number of columns in the source file. Recently a new column was erroneously added to one of our source files and our jobs didn't pick it up. Is this the default behavior? If so, how do I trap th...

What is the best way to process a file with a varying numer of columns. I'm thinking of definining the metadata as one very large varchar column and then using the field command to parse the fields that I need. Is this an acceptable approach? I'm concerned about performance. How is space allocated w...

I'm dealing with a fixed width file that is passing decimals as 000100.100. I'm using an upstream trim to remove the leading and tailing zero's to output 100.1. When I pass this column as an exported column the format is going back to 000100.100. How can I preserve the 100.1 value in the column expo...

Is it possible to excute database commits based on a captured key change? For example if my key is State I'd like to commit records for the current State and trigger an update to an availability table setting that State to "processed". Is this possible? No. you can not. If I understood co...

Is it possible to excute database commits based on a captured key change? For example if my key is State I'd like to commit records for the current State and trigger an update to an availability table setting that State to "processed". Is this possible?

Is it possible for server resources to impact a join without throwing an error? I have a job that left outer's on two datasets that produces incorrect results every now and then. The join matches on key's that do not exist and thus I'm getting incorrect values from the right columns. I've verified t...

I changed the scale of one varchar column and now get the following warnings: main_program: Sort key "fund_number" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector main_program: There are no sort keys in the dataset schema. No sortmerge collector...

Is it possible to cast directly in the sql of an oracle enterprise stage? I keep getting the error "the modify operator has a binding for the non-existent output field" The field I'm trying to cast is an Oracle function with metadata of varchar2(4000) but the function only returns two char...

Ray.

There was an attempt to delete these jobs which no doubt caused the issue. I am able to run the selects and retreive the object names but DS.CHECKER is not flagging the job as an orphan. I'm still unable to delete the job for some reason.

I'm trying to clean up my project and am getting an error when I try to delete one job: "Cannot open exectuable job file RT_CONFIG118"

Does anyone know how to get around this?