DSXchange

You've enabled Runtime Column Propagation (RCP), and 'exposed' the same columns you are loading.

Turn off RCP and rerun your job.

We already have a license for the VIN data from RL Polk. My real question is is it possible to load the data into Qualitystage like CASS address files.

I won't ask how until its's confirmed that's the route that will be taken.

I have a requirement to standardize and validate VIN's from all auto manufacturers. Currently RL Polk is contracted to be the 'keeper of record' for all VIN's. Is it possible to create and load into qualitystage these VINS and any pertinant information to be used in qualitystage similar to the way C...

Hi Everyone, after several days of reading the installation guide and trial and error I am down to this final error in the SAP BW Pack when trying to read from SAP: Failed to call RfcReceive in the function startProcessChainForExtract rc: 2 The message ID is BWPACK-E-00038. In the SAP administrator ...

No, it's not the name of my file. My file name is: G:\dev\sdw\Temp\one.txt and my error message is: ##E IIS-DSEE-TCOS-00037 14:26:46(011) <main_program> Failed to open performance file False/performance.5144; The only thing that changes in the error message is the timestamp (14:26:46) and the numbe...

What would be the best way to convert a date in format yyddd (mainframe julian)?

Thanks

Mhester, I have to use either a filter or switch because the header and 3 detail records each have their own definition.
Boxtoby, aren't stage variables local to the transform being used? I have 4 transforms after the filter.

I have an input file with a header and 3 types of detail records.
I have split the header and 3 detail records using a filter stage, then into transforms. I need to get the date from the header record in the 3 transformed detail records.
What would be the best way to do this?

Thanks

The column export stage allows you to take multiple colums and export them into one larger column. Example: If you define a generic layout of char(200), the column export stage will concatenate all the columns you select into the generic layout you have created. If you do this for both your detail a...

The error is: XML Error: A derivation Constant node contains an unsupported UVAtVar - '@False'. The Constraint is: StgBranch = @TRUE or StgAcct = @TRUE or StgValidDate = @TRUE or StgSeqCd = @TRUE or StgTranCd = @TRUE or StgAmt = @TRUE or StgTraceNo = @TRUE or StgSrcBnk = @TRUE or StgPostCd = @TRUE o...

Create a generic layout with the length of the longest record. Use the column export stage for both records. This will export all columns from your header and detail records to the generic file layout you created. Then you can use your funnel stage. Make sure you specify the link order to get your h...

Not a problem, when I imported the target record type, I was able to map everything.

Thanks

Here's how I'd do it... Start with a Sequential File stage with the following metadata: COL1 Char(6) RecTyp Char(1) COL3 VarChar(23) Then run the stream through a Switch stage to produce 2 links (streams); one for each RecTyp. Then run the 2 links through 2 Column Import stages (giving a total of 4...

dt12946, this is the situation I have: Record A field1 pic x(4) field2 pic 99 rectyp pic x field5 pic x(5) field6 pic 9(9) Record B field1 pic 9 field2 pic 99999 rectyp pic x rec4 pic x(14) field6 pic 9(9) How would I split a record into these two records above based on the rectyp. Thanks

dt12946 a quick question.
I have a record where the record type is at the end of the record. I need to use the column input stage to input colums for the fields before the record type field.
what is the best solution for this.

Thanks