DSXchange

Hi, I am trying to read cobol files using CFF. The file has field with occurance clause. But the behaviour of CFF stage in server and parallel seems different. e.g if I have source with 10 occurance for a field. In the server jobs, I am getting 1o rows as output, whereas in parallel job, it is commi...

Hi .

I am trying to read a file which has column no_occur and fo(n) columns.
The no_occur column contains the number of field from which the data is to be assigned to the target field.

e.g if the no_occur = 30. I have to read from fo30 column ( skiping column fo1 to f029).


Thanks,
Gokul

Thanks Ray!

This is helpful

I have the Hexa Decimal input and need to convert it into its corresponding Decimal value & ASCII Value. I am interpreting the input hex value as "Character" i.e. Item Subclass is 'Text' & Interpret as 'Character'. Ex: 44 48 47 33 31 55 37 37 31 39 30 30 39 33 31 00. This is input ...

One of the Arguments of the functional map is EITHER(VehicleRecordGDS CLASS2_VER1:VehicleRecordChoiceGDS:VehicleRecordChoiceGDS2<>VehicleGDSTech2Main:DealerGroup:DEALER_FILE, VehicleRecord CLASS2_VER1:VehicleRecordChoice:VehicleRecordChoice2<>VehicleGDSTech2Main:DealerGroup:DEALER_FILE). I have a pa...

Yes.. The field been absent means it is NULL.

Not until , we are upgrading to DS 8

Hi , The update strategy for an oracle table depends on existence of the fields in the source . e.g if Fields A and B are present but c and D are absent then update the table M set B := source.B, using A as key. IF fields A and B are absent but C and D are present then Update the table M set D := so...

The variable $APT_IMPORT_PATTERN_USES_FILESET_MOUNTED is not supported in version I am using. I tried a workaound and its working. In the sequential file stage, I used Read Method = Specific Files and used 15 different File properties. Each property specifiying name of one of 15 files. Also the opti...

The other variable $APT_IMPORT_PATTERN_USES_FILESET_MOUNTED is not in the version 7.5x2 ( which I am currently using).

Hi , I am trying to read multilpe files from a file landing directory and also obtain the individual file name as one of the output column I have used Sequential file stage's File Pattern Property to read multiple files and File Name Column option to get the individual File Name. There are 2 source ...

Yep Amey!

That is working.. The culprit was continue

ArndW,
In fact in my job I am not doing any conversions/transformation.
The data from oracle stage is dumped directly into Dataset. Within the Dataset i am see the char(150) converted to ?.

Even when I peek the values from oracle stage, they are implictly converted

The need of my project was to replicate the changed data from one database to other.

I am fetching the delta from Oracle source database and storing it in a dataset in one job. In other job, the dataset is loaded in the target database.

As a result, I don't want any conversion of the data in between

It is not '-'. Its hex value is 96. Also I have some value in column having '-' which are processed as it is, without any conversion.

My query is whether channging the NLS of Datastage to 'AMERICAN' will solve the problem and also will it afect other normal running jobs .