Search found 72 matches
- Thu Feb 18, 2010 12:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The behaviour of CFF stage
- Replies: 1
- Views: 1110
The behaviour of CFF stage
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...
- Thu Feb 18, 2010 12:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading a speciifc occurance
- Replies: 2
- Views: 1173
Reading a speciifc occurance
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
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
- Thu Jul 09, 2009 5:11 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Conversion of Hex Value to equivalent Decimal & ASCII Va
- Replies: 5
- Views: 7723
- Wed Jul 08, 2009 4:26 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Conversion of Hex Value to equivalent Decimal & ASCII Va
- Replies: 5
- Views: 7723
Conversion of Hex Value to equivalent Decimal & ASCII Va
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 ...
- Tue Jun 30, 2009 5:10 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Can we specify a partition as a type in the input card?
- Replies: 1
- Views: 3078
Can we specify a partition as a type in the input card?
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...
- Wed Jun 10, 2009 5:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating a table using a variable number of Update keys
- Replies: 9
- Views: 2745
- Wed Jun 10, 2009 4:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Multiple Files from a source Directory
- Replies: 6
- Views: 3223
- Wed Jun 10, 2009 4:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating a table using a variable number of Update keys
- Replies: 9
- Views: 2745
Updating a table using a variable number of Update keys
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...
- Wed Jun 10, 2009 2:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Multiple Files from a source Directory
- Replies: 6
- Views: 3223
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...
- Mon Jun 08, 2009 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Multiple Files from a source Directory
- Replies: 6
- Views: 3223
- Mon Jun 08, 2009 4:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Multiple Files from a source Directory
- Replies: 6
- Views: 3223
Reading Multiple Files from a source Directory
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 ...
- Tue Mar 17, 2009 6:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Shell script from a Routine
- Replies: 9
- Views: 3413
- Tue Apr 29, 2008 6:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Charachter handling in Dataset
- Replies: 10
- Views: 3556
- Tue Apr 29, 2008 1:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Charachter handling in Dataset
- Replies: 10
- Views: 3556
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
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
- Mon Apr 28, 2008 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Charachter handling in Dataset
- Replies: 10
- Views: 3556